Learn Excel

Using Excel's Analyze Data Tool

Discover how to harness the power of Excel's Analyze Data tool to simplify data analysis, offering intuitive, automatic analysis of key data segments,...

How to Set a Picture as a Background in Excel: Using the Page Layout Tab to Add Graphics to Your Sheets

Continue your understanding of Excel's Page Layout tab with insights into the "Background" and "Print Titles" commands, where you can customize your sheet's...

How to Add Headers & Footers in Excel: More Fun with Excel's Page Layout Tab

Explore the detailed guide to understanding the Page Layout tab and other features in Excel, along with a step-by-step explanation on customizing headers,...

Finding Data with XLOOKUP

Discover the powerful, versatile XLOOKUP function in Excel, which has replaced and improved upon the older VLOOKUP and HLOOKUP functions, enabling both...

Date Analysis with Pivot Tables: Grouping and Timelines

Pivot Tables, Grouping, and Timelines. In this section, we'll look at how Pivot Tables make it really easy for you to work with dates in your dataset.

Mixed Cell References in Excel Formulas

Advanced cell locking. Create powerful formulas by locking either the column or the row or both.

HLOOKUP: Mastering Horizontal Data Searches

HLOOKUP. HLOOKUP is exactly like VLOOKUP except for two things.

Joining Text in Excel: Using Concatenate and Ampersand

Joining Text. In this section, we're going to take a look at joining text.

Creating Line Charts in Excel

In this section, we're going to go over how to create a basic line chart. Now, when you're selecting the information for creating your line chart, all you...

Where to Find Excel Classes

How Long Do Excel Courses Take?

Collection of Excel Tips and Tricks, Part 1

Explore this comprehensive guide for insightful Excel tips and tricks to enhance your productivity, ranging from simple shortcut keys to advanced VBA code and...

Excel Certifications and Certificates

Excel's Autosum: Simplifying Calculations

AutoSum functions. Excel's AutoSum functions help you to automate your calculations when it comes to coming up with answers for complex tables like this.

Match Function: Finding Positions in Rows and Columns

VLOOKUP and the MATCH function. The MATCH function serves a single purpose.

Data Validation in Excel

Explore how to use data validation to set restrictions on cell entries, alert users, and prevent incorrect values from entering your data cells, with examples...

Inserting, Deleting, Hiding, and Grouping Rows and Columns

Rows and columns. In this section, we'll take a look at how to insert, delete, hide, and group rows and columns.

Creating a Subtotal Report

Learn how to create a subtotal report in Excel, a tool that allows you to sort and group your data, apply functions like summing and averaging, and then...

Paste Special: Excel Skills with Key Techniques

Paste Special. In this section, we will use Paste Special to apply formats as well as perform calculations on selected cells.

Excel's True-False Comparisons for Data Analysis

The true/false statement. What does the true/false statement do?