Learn Excel

Absolute Cell References in Excel Calculations

Absolute cell references. Absolute cell references are very important in Excel when you're working with calculations where you have multiple values and a...

Demystifying VLOOKUP, XLOOKUP

Learn about the unique properties and uses of an Excel table, which offers additional functionalities that can significantly enhance data management and...

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

Discover the time-saving capabilities of cell styles in spreadsheet software, allowing easy formatting adjustments across thousands of cells with just a few...

Remove Duplicates in Excel Using Data Tools

Remove Duplicates. In this section, we'll use Remove Duplicates to eliminate duplicate data.

Basic Excel Calculations and Order of Operations

Calculations. Let's take a look at how you can perform very simple calculations in Excel.

Excel’s Latest Innovations

If you subscribe to Office 365, every time you fire up one of the applications, you’re getting the latest version of the software. While we used to have to buy...

Laurie Ulrich

Conditional Formatting in Excel

Explore the wide-ranging capabilities of Excel's conditional formatting, including the ability to format cells based on specific conditions, highlight cells...

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

Discover the various methods to hide, show, and change the dimensions of rows and columns in Excel. This inclusive guide primarily focuses on operations...

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

Learn step-by-step how to create a simple UserForm in Excel using VBA coding which allows users to input information into a form that can be stored or used...

Using Excel Tables

Learn how to manage and utilize Excel Tables more effectively with this comprehensive guide, covering everything from creating tables and selecting rows or...

Managing Excel Worksheets with Ease

Worksheets. In this section, we're going to talk about managing your worksheets in your Excel file.

Windows Management: Keyboard Shortcuts for Excel

In this section, we're going to talk about how to work with windows inside of the Windows operating system. This particular topic is not applicable to Macs.

AND & OR Functions: Logic in Real-Life Scenarios

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

Creating Dynamic Visuals with Pivot Charts in Excel

Pivot Charts. Pivot Charts are dynamic graphical representations of Pivot Table data that work in tandem with pivot tables.

Data Validation

Learn how to ensure data consistency and accuracy within your worksheets using Data Validation, a powerful tool that establishes standards for data entry...

Streamlining Daily Reports with Macros for Accuracy

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

Multi-Input Functions: From Text Extraction to Rounding

The main purpose of this section is to show you how to use functions that may take more than just one input. Earlier on in our Excel exercises, when we used...

Project Management with Excel

Download the project file Being a project manager is a lot like being a juggler. You’ve got to keep a lot of things—people, resources, schedules, tasks,...

Laurie Ulrich

Data Organization: Sorting, Filtering, and Subtotals in Excel

Sort and Filter. We will use Sort and Filter to find and organize data in large databases.

Conditional SUMPRODUCT for Data Analysis in Excel

Conditional SumProduct. Using SumProduct with conditions to exclude data that does not meet a certain criterion.