Learn Excel

Oct 30, 2024 12 min read

Data Organization: Sorting, Filtering, and Subtotals in Excel

Master Excel's essential tools for sorting, filtering, and displaying subtotals like a pro. Discover how to quickly organize your data and create clear…

Garfield Stinvil

Oct 29, 2024 10 min read

Mixed Cell References in Excel Formulas

Unlock Excel's full potential by mastering advanced cell locking and mixed referencing techniques. Learn to build powerful, flexible formulas that adapt…

Garfield Stinvil

Oct 24, 2024 5 min read

Inserting, Deleting, Hiding, and Grouping Rows and Columns

Master Excel by swiftly inserting, deleting, hiding, and grouping rows and columns using simple ribbon commands or powerful keyboard shortcuts. Unlock…

Garfield Stinvil

Oct 23, 2024 5 min read

Streamlining Daily Reports with Macros for Accuracy

Macros can drastically reduce tedious daily tasks from minutes to seconds. Learn how recording a simple Excel macro can save you hours of repetitive work every…

Garfield Stinvil

Oct 23, 2024 11 min read

Multi-Input Functions: From Text Extraction to Rounding

Ever wondered how Excel experts quickly extract text, multiply columns, or accurately round numbers? Dive into this guide to master multi-input functions and…

Garfield Stinvil

Oct 9, 2024 6 min read

Using Excel Tables

Master Excel Tables with our comprehensive guide, delving into table creation, row and column selection, structured referencing syntax, and exploration of…

Bob Umlas

Oct 2, 2024 15 min read

Excel Data Analysis with Statistics

In this article, we are going to look at how Data Analysis with Statistics can be done efficiently through the use of Microsoft Excel.

Laurie Ulrich

Sep 29, 2024 3 min read

Nesting Functions

Learn how to Nest Functions.

Sep 28, 2024 4 min read

Using COUNT Functions

Learn how to use COUNT Functions.

Sep 22, 2024 12 min read

Designing Impressive Reports with Excel

In this article, we're going to look at how to build complex and thorough reports in Microsoft Excel

Laurie Ulrich

Sep 21, 2024 5 min read

Using SUM and AVERAGE Functions

Learn how to use SUM and AVERAGE Functions.

Sep 18, 2024 4 min read

Printing Worksheets, Workbooks, and Ranges

Learn how to print Worksheets, Workbooks, and Ranges

Sep 15, 2024 15 min read

Using Excel's Analyze Data Tool

Explore the utilization of Excel's Analyze Data tool for streamlined data analysis, featuring automatic evaluation of crucial data segments, customizable…

Sep 3, 2024 6 min read

Excel Windows

Work with Excel windows on the Windows operating system (not for Macs)

Aug 31, 2024 5 min read

Formatting Cells in Excel

In this article, we are going to look at the many ways you can Format Cells in Microsoft Excel

Bob Umlas

Aug 30, 2024 3 min read

Using Shapes, Lines, Icons, and Text Boxes in Excel

Learn to amplify the impact of your Excel worksheets through the incorporation and formatting of shapes, lines, icons, and text boxes for compelling data…

Aug 8, 2024 4 min read

Create Mixed References

Learn how to Create Mixed References.

Jul 21, 2024 5 min read

Pivot Table Sales Report Variances

In this Excel tutorial, we're going to create a Pivot Table. In order to do this, we're going to have to use one of the Value Field Settings calculations that…

Jul 5, 2024 3 min read

Collection of Excel Tips and Tricks, Part 1

Dive into our comprehensive guide that provides a wide range of Excel tips and tricks, from simple shortcut keys to advanced VBA code and userform techniques…

Bob Umlas

Jul 4, 2024 4 min read

Understanding Formulas vs. Functions

Understand Formulas vs. Functions in Excel.