Learn Excel

Feb 13, 2024 3 min read

Edit PivotTable

Learn how to edit a Pivot Table

Feb 7, 2024 3 min read

Responding to Excel Warnings

Learn how to respond to Excel warnings.

Jan 28, 2024 4 min read

Editing and Formatting Charts

Learn how to Edit and Format Charts.

Jan 28, 2024 5 min read

Excel AND OR Logical Functions

In this section, we'll take a look at how you can use the AND OR functions to test if multiple criteria are all true, or at least one of them is true.

Jan 26, 2024 5 min read

Using SUM and AutoSUM

Learn how to use SUM and AutoSUM in Excel.

Jan 22, 2024 7 min read

Excel Go to Special

Learn to use Go to Special to perform several time-saving tasks in your Excel spreadsheet.

Jan 4, 2024 4 min read

Tour of the Excel Workspace

Learn how to navigate the Excel Workspace.

Jan 1, 2024 7 min read

IF Statements

In this section, we’ll cover IF statements. IF statements allow you to check to see if something is true or false and then take different actions depending on…

Dec 25, 2023 1 min read

Using SUM for a whole Column

Learn how to use SUM for a whole Column.

Dec 21, 2023 4 min read

Protection in Excel

Excel cells are locked by default in any new file, but this locking only takes effect when the worksheet is protected. Learn how to protect your worksheet in…

Bob Umlas

Dec 9, 2023 4 min read

Filter Lists in Excel

Learn how to Filter Lists in Excel

Dec 7, 2023 6 min read

Inserting and Deleting Cells, Columns, and Rows

Learn how to Insert and Delete Cells, Columns, and Rows.

Dec 5, 2023 5 min read

Understand PivotTable Structure

Understand Pivot Table Structure.

Dec 5, 2023 7 min read

Excel Conditional SUMPRODUCT

Learn to use conditional SUMPRODUCT to extract the subset of the information that you want and exclude everything else.

Nov 19, 2023 6 min read

Creating a Subtotal Report

Discover how to build a subtotal report in Excel, a resource for sorting and grouping data, applying functions like sum and average, and customizing your data…

Nov 18, 2023 5 min read

Advanced Filtering in Excel

Master complex filtering operations using Excel's Advanced Filter, including filtering based on column relationships or unique records, without the need for…

Bob Umlas

Nov 15, 2023 3 min read

Advanced Filtering

Learn how to use Advanced Filters in Excel.

Nov 12, 2023 4 min read

Introduction to Excel’s Page Layout Tab: Setting Margins, Page Orientation, Size, Print Area, & Breaks in Excel

Delve into a comprehensive guide detailing the usage of the Page Layout tab in Microsoft Excel, including commands like Margins, Orientation, Size, Print Area…

Bob Umlas

Nov 9, 2023 6 min read

Excel IF Statement with AND OR

Expand your knowledge on using IF statements by incorporating AND and OR functions to enhance the functionality of logical tests.

Nov 5, 2023 4 min read

Learn how to save Workbooks

Learn how to save Workbooks.