Learn Excel

May 21, 2023 5 min read

Excel Macros Report

In this video, we'll create a macro that's going to format a report that we are going to imagine we need to create every single day.

May 19, 2023 10 min read

Multiple Pivot Tables Excel

Learn advanced features of Pivot Tables like adding percent totals, creating slicers, and creating multiple Pivot Tables off the same dataset.

May 18, 2023 6 min read

Applying Basic Font & Alignment Formatting in Excel

Learn how to apply Basic Font and Alignment Formatting in Excel.

Apr 28, 2023 3 min read

Creating Grand Totals in Excel

Delve into the intricacies of calculating grand totals in Excel worksheets, as we discuss alternative methods, potential errors, and optimal solutions.

Bob Umlas

Apr 19, 2023 5 min read

Applying Basic Number Formats

Learn how to apply basic number formats.

Apr 15, 2023 3 min read

Creating a new Workbook

Learn how to create a new Workbook

Apr 7, 2023 7 min read

Excel COUNTIFs and SUMIFs

Learn to use SUMIFS and COUNTIFS to count and sum based on conditions.

Apr 3, 2023 3 min read

Rearranging Data with New Functions in Excel

In this article, we’ll explore these new functions: TOCOL, TOROW, WRAPCOLS, WRAPROWS, CHOOSECOLS, and CHOOSEROWS.

Bob Umlas

Apr 2, 2023 3 min read

Editing Cells and Ranges

Learn how to edit cells and ranges in Excel.

Apr 1, 2023 2 min read

Using Concatenate

Learn how to use CONCATENATE.

Mar 30, 2023 6 min read

Excel Index Match

Learn how INDEX and MATCH efficiently return a value in a row or column that matches a value in another row or column in Microsoft Excel.

Mar 17, 2023 6 min read

Excel Hotkeys

Learn to use a keyboard shortcut to access any commands on the ribbon on a PC.

Mar 12, 2023 7 min read

Excel Macros

Learn to use Macros to help you to automate work in Excel.

Mar 6, 2023 4 min read

Entering Worksheet Content

Learn how to enter content in an Excel Worksheet.

Mar 5, 2023 8 min read

Number Formatting in Excel

Discover the various techniques for efficiently formatting numbers in Excel, featuring shortcuts, custom categories, and comprehending the utilization of…

Bob Umlas

Mar 3, 2023 4 min read

Combo Charts

Combo charts combine two or more charts into a single chart with the option of adding a secondary axis.

Mar 1, 2023 4 min read

Using Undo, Redo, and Repeat

Learn how to use Undo, Redo, and Repeat in Excel.

Feb 25, 2023 3 min read

Customize the Excel Quick Access Toolbar

Learn how to customize the Excel Quick Access Toolbar.

Feb 19, 2023 5 min read

Making Magic Dynamic Arrays

Dive into Excel's dynamic array functions like SORT, FILTER, UNIQUE, SORTBY, and RANDARRAY to create advanced, automatically updating spreadsheets.

Bob Umlas

Feb 14, 2023 2 min read

Using the JUSTIFY Command: Reflow Text in Microsoft Excel

Reflow text in Microsoft Excel with the JUSTIFY command.

Bob Umlas