Learn Excel
Clear explanations, real-world industry examples, and interactive step-by-step walkthroughs for every function.
Functions
=AVERAGE()
The AVERAGE function finds the average of a group of numbers.
=COUNTIFS()
The COUNTIFS function counts the number of cells in a range that meet a single condition or multiple conditions.
=FILTER()
The Excel FILTER function shows only the rows of your data that match one or more conditions, and hides everything else.
=IF()
The IF function in Excel is used to run a logical test and show one result if the test is true, and a different result if the test is false.
=MATCH()
The Excel MATCH function searches for a specific item in a list and tells you exactly what position it is in.
=SUMIFS()
The Excel SUMIFS function adds numbers together only if they meet one or more specific conditions that you set.
=TEXT()
The Excel TEXT function converts a numerical value into a text string and applies a specific display format (like a date, currency, or percentage) to…
=TODAY()
The Excel TODAY function automatically shows the current date in your spreadsheet.
=VLOOKUP()
The Excel VLOOKUP function searches for a specific value in the first column of a table and returns data from the same row in another column.
=XLOOKUP()
The XLOOKUP function searches for a specific item in one column or row and returns related information from another column or row.
Resources
Practice
Free Excel Practice Workbooks
A free Excel workbook for every lesson, with real-world examples, blank cells to fill in, and an answer key. No sign-up needed.
Open guideTroubleshootingCommon Excel Errors and How to Fix Them
Every Excel error code in one place: #REF!, #N/A, #VALUE!, #SPILL! and more. What each one means, why it happens, and exactly how to fix it.
Open guideReferenceExcel Criteria and Wildcards
The criteria patterns shared by every conditional function (SUMIF, COUNTIF, AVERAGEIFS and more), with a copyable example for each.
Open guideFormattingExcel Custom Number Formats Guide
Every custom number format code, what it does, and a working example you can paste into a cell, for TEXT() and Format Cells → Custom.
Open guide