Microsoft Excel

Resources in Microsoft Excel

How to Use the IF Function in Excel

How to Use the IF Function in Excel

Learn how to use the IF function in Excel and see how it can be combined with the OR and AND functions.

The SUMIF Excel Function

The SUMIF Excel Function

Discover what the SUMIF Excel function is and how to use it.

The COUNTIF Function in Excel

The COUNTIF Function in Excel

Improve your data management skills by learning how to use the COUNTIF function in Excel.

The Excel AND Function

The Excel AND Function

Learn how to use the Excel AND function and combine it with other functions for more flexibility.

How to Create a Running Total in Excel (Cumulative Sum)

How to Create a Running Total in Excel (Cumulative Sum)

Learn how to create a running total in Excel with this step-by-step tutorial.

The Excel OR Function

The Excel OR Function

What is the Excel OR function? How do you use it? Find out in this tutorial.

200+ Best Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fan...

Excel Challenge # 4

Excel Challenge # 4

Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).

The New Excel LET Function

The New Excel LET Function

Learn about the new Excel LET function. This new function can help make complex formulas easier to read and use.

The Excel Ribbon

The Excel Ribbon

Improve your Excel navigational skills with these tips on how to use and customize the Excel ribbon.

How to Sort in Excel

How to Sort in Excel

Learn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting.

Excel Challenge # 3

Excel Challenge # 3

Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).

VLOOKUP Exact Match & Approximate Match

VLOOKUP Exact Match & Approximate Match

Learn one of Excel's most useful functions: VLOOKUP exact match and approximate match.

VBA Variable Types in Excel

VBA Variable Types in Excel

Learn what a variable is, why they are important, and understand how to use the different VBA variable types in Excel.

How to Remove Blank Rows in Excel

How to Remove Blank Rows in Excel

Avoid data errors by learning how to remove blank rows in Excel the right way.

Mixed References in Excel - a Beginner's Guide

Mixed References in Excel - a Beginner's Guide

Learn all about the mixed reference Excel feature in this beginner's guide.

Relative References in Excel - A Beginner's Guide

Relative References in Excel - A Beginner's Guide

Learn all about the relative reference Excel feature in this beginner's guide.

Excel Challenge #2

Excel Challenge #2

Ready for some fun with Power Query in Excel? Try you hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga). Download...

Excel VBA Code Library - Useful Macros for Beginners

Excel VBA Code Library - Useful Macros for Beginners

Automate your Excel tasks with ready-made code from our VBA code library.

Join 265,459 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

Absolute References in Excel - A Beginner's Guide

Absolute References in Excel - A Beginner's Guide

Learn all about the absolute reference Excel feature in this beginner's guide.