Learn Excel

May 17, 2024 4 min read

Collection of Excel Tips and Tricks, Part 2

Explore efficiency-boosting Excel skills like placing totals in specific cells, utilizing formulas for grand totals, creating multi-column text boxes, and…

Bob Umlas

May 14, 2024 6 min read

Excel VLOOKUP and MATCH Function

Learn to create a more accurate VLOOKUP by enhancing the determination of the column index number by using the MATCH function in Microsoft Excel.

May 10, 2024 5 min read

Data Validation

Discover the Art of Maintaining Consistency and Accuracy in Your Worksheets with Our Course That Focuses on Utilizing Data Validation, a Crucial Tool That Sets…

May 7, 2024 4 min read

Inserting Current Dates and Times with Functions

Learn how to insert Current Dates and Times with Functions.

May 6, 2024 6 min read

Get Started with UserForms: Create Simple Forms with VBA in Excel

Gain knowledge on creating an uncomplicated UserForm in Excel through VBA coding, enabling users to input information to be stored or utilized within the…

Bob Umlas

Apr 29, 2024 4 min read

Working with Date and Time Formats

Learn how to work with Date and Time Formats.

Apr 27, 2024 9 min read

Project Management with Excel

Organize projects, tasks, and deadlines with the help of Microsoft Excel.

Laurie Ulrich

Apr 20, 2024 4 min read

Creating and Modifying a Custom List

Learn how to create and modify a custom list.

Apr 9, 2024 4 min read

Excel Consolidation

Learn to use the Consolidate function to consolidate information across multiple sheets in Excel.

Mar 30, 2024 3 min read

Sort Lists in Excel

Learn how to Sort Lists in Excel

Mar 28, 2024 3 min read

Create a Quick PivotTable

Learn how to create a Quick Pivot Table in Excel.

Mar 21, 2024 4 min read

Storing Lists in Excel

Learn how to Store Lists in Excel.

Mar 18, 2024 5 min read

Create Charts in Excel

Learn how to create a Chart in Excel.

Mar 17, 2024 4 min read

Cell Styles in Excel: How to Style Cells for Quick & Easy Modification

Make future modifications quick and easy by using Styles in Excel.

Bob Umlas

Mar 10, 2024 10 min read

Excel’s Latest Innovations

Learn about Excel's newest and most exciting features in this guide.

Laurie Ulrich

Mar 9, 2024 10 min read

Excel Advanced Cell Locking

Learn to create powerful formulas by locking either a column, a row or both in Excel.

Mar 4, 2024 4 min read

Applying Borders and Shading

Learn how to apply Borders and Shading.

Feb 25, 2024 4 min read

Absolute References vs. Relative Addressing

Understand Absolute v. Relative Addressing in Excel.

Feb 21, 2024 4 min read

Naming Cells and Ranges

Learn how to name Cells and Ranges

Feb 13, 2024 4 min read

Working with Shapes in Excel

Enhance your digital drawing prowess as you delve into the complexities of shape manipulation, which includes rotating and formatting shapes, working with…

Bob Umlas