Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Use Power Pivot with DAX formulas for advanced data analysis I always advise Excel beginners to familiarize themselves with Power Pivot and DAX formulas.

Learn how to use the VLOOKUP function in Excel to retrieve data from a table. From the basic syntax of the function, how to handle common ...

Microsoft Excel is a powerful spreadsheet program that can be used for a variety of tasks, including basic math. Here's how to use Excel as a calculator to perform basic arithmetic operations such ...

Using the basic Excel filter function formula Before we explain how to use the Excel filter function with multiple criteria, it’s important to understand how the Excel filter function formula works.

Learn how to use Excel to your advantage. This Microsoft Excel Beginner to Advanced course normally goes for $80, but until April 2 at 11:59 p.m., PT, you can grab it on sale for $16.97.

If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Think you know how to use Excel? Check our list of Microsoft Excel tips and tricks to learn more about this spreadsheet software.