Learn Excel

Feb 14, 2023 4 min read

Working with Rows & Columns in Excel: How to Hide Them, Show Them, & Change the Height or Width

Follow along with this guide to hide, show, and adjust rows and columns in Excel.

Bob Umlas

Feb 14, 2023 5 min read

Finding Data with XLOOKUP

Explore the dynamic and efficient XLOOKUP function in Excel that replaces the older VLOOKUP and HLOOKUP functions, offering seamless vertical and horizontal…

Feb 13, 2023 4 min read

Cell Referencing

Enhance your knowledge of Excel's cell referencing system, explaining absolute and mixed cell references and their impact on spreadsheet operations.

Bob Umlas

Feb 9, 2023 7 min read

Excel Advanced Conditional Formatting

Learn to use advanced conditional formatting to format cells based on values in another location.

Feb 7, 2023 5 min read

Using Cut, Copy, Paste, and Paste Special

Learn how to use Cut, Copy, Paste, and Paste Special.

Feb 3, 2023 6 min read

Demystifying VLOOKUP, XLOOKUP

Discover the distinct properties and functionalities of an Excel table that can greatly improve your data management and processing tasks.

Bob Umlas

Feb 3, 2023 4 min read

Create SmartArt Diagrams in Excel

Learn how to create SmartArt Diagrams in Excel.

Feb 2, 2023 15 min read

Event Planning with Excel

In this article, we are going to look at how Event Planning can be done efficiently through the use of Microsoft Excel.

Laurie Ulrich

Jan 22, 2023 6 min read

Excel Date Functions

In this section, we'll take a look at five Excel date functions you can use to calculate dates in the future or the total number of days between any two dates…

Jan 21, 2023 3 min read

Working with Flash Fill

Learn how to work with Flash Fill.

Jan 9, 2023 17 min read

Top Cities for Excel Classes & Training

Noble Desktop

Jan 9, 2023 11 min read

Comparison of Excel Training Formats

Noble Desktop

Jan 9, 2023 9 min read

Which Industries & Professions Use Excel?

Noble Desktop

Jan 9, 2023 8 min read

How Does Learning Excel Compare with Other Skills?

Noble Desktop

Jan 9, 2023 8 min read

What Can You Do with Excel Skills?

Noble Desktop

Jan 9, 2023 4 min read

Filtering Data in Excel

Explore the diverse methods of filtering data in Excel to effectively manage and analyze your datasets in our training program.

Bob Umlas

Jan 9, 2023 8 min read

Conditional Formatting in Excel

Discover the vast potential of Excel's conditional formatting, showcasing the ability to tailor cell formats based on distinct conditions, emphasize cells with…

Bob Umlas

Jan 6, 2023 5 min read

Pivot Charts in Excel

Learn how to work with Pivot charts in Microsft Excel. Pivot charts are dynamic graphical representations of Pivot Table data that work in tandem with pivot…

Jan 3, 2023 4 min read

Excel Goal Seek

Learn to use Goal Seek to calculate equations in Excel.

Dec 18, 2022 19 min read

Functions Built to Work with a Database

In this article, we are going to look at how to build functions to work with a database in Microsoft Excel.

Laurie Ulrich