Excel Practice Online | Free Excel Exercises (2024)

Welcome to Excel Practice Online!

On this website, you will learn and practice Excel functions and tools!

Now you can practice Excel everywhere! You can evenpractice on your mobile phone!

Every function and tool has an explanation followed by an online excel exercise which can be solved within the page itself, no need to download anything – All thanks to the amazing powers of Excel Online!

The tutorials are sorted from beginner level to advanced level. If you like this site please share it with your friends! 🙂

Tip for mobile phone users – tap twice on the cell you want to edit in order to edit it.

Articles

HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.
New! Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version
Can’t find what you’re looking for? Suggest a tutorial here!

Beginner

Basics

Excel Basics – Start here if you are new to Excel! Learn how Excel works, how to perform basic calculations, and how to use cell references to save time and increase efficiency!
Basic Math in Excel:
- Addition (Plus)
- Subtraction (Minus)
- Multiplication
- Division

Shortcuts

Excel Shortcuts for Windows – Master Excel Shortcuts to save time and increase efficiency!
Excel Shortcuts for Mac – Learn how to make the most of Excel on your Mac!

Formulas/Functions

SUM function – Sum multiple values in Excel
MAX – find the maximum value in a range
MIN – find the minimum value in a range
COUNT – Count numeric values in a range
COUNTA – Count numeric and textual values
AVERAGE – Calculate average of a range

Tools

Filtering in Excel – Learn how to filter your data using Excel’s Filter Tool
Excel Sort – Learn how to sort your data in Excel.
Flash Fill – Excel’s hidden gem for auto-completing data based on a pattern
Remove Duplicates – Remove duplicate values in a single column or multiple columns!

Intermediate

Conditional

IF function – check if a condition is met
NESTED IF – Multiple if conditions
Conditional Formatting – Format Excel Cells based on criteria
COUNTIF – Count cells in range which meet a certain criteria
SUMIF – Sum range based on criteria
AVERAGEIF – Calculate the average of a range based on criteria
SUMIFS – Sum cells using multiple criteria
COUNTIFS – Count cells using multiple criteria
MAXIFS – Find maximum value in a range based on criteria
MINIFS – Find minimum value in a range based on criteria
AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!)
ISBLANK – Check if a cell is blank or not

Lookup

VLOOKUP – lookup value and return corresponding value from a table
HLOOKUP – lookup value and return corresponding value from a table
Hot!!! XLOOKUP – Excel’s next generation lookup function which combines the best features from VLOOKUP, INDEX MATCH, HLOOKUP and IFERROR/IFNA

Pivot tables

Pivot Table – Quickly Analyze and Summarize your data using Excel’s most powerful tool!

Text Formulas

LEFT, MID, RIGHT – Basic Text Functions
HOT! – TEXTSPLIT – Split your text into multiple cells using this super powerful new function!
TEXTJOIN – Easily combine multiple cells using delimiter
CONCAT – Combine range of cells without delimiter
CONCATENATE – Combine two cells or more into one cell
LEN – Find the length of a cell
FIND – Find the position of a text within another text (Case-sensitive)
SEARCH – Find the position of a text within another text (Case-insensitive)
SUBSTITUTE – Replace text with another text in a cell/expression
TRIM – Remove extra spaces from the text
LOWER, UPPER, PROPER – Convert text to lowercase, uppercase and proper case
VALUE – Convert data stored as text into values
TEXT – Convert and format numbers into text
Text to Columns – Quickly split a column into multiple columns using a delimiter. Bonus – Quickly change date formats or convert text to numbers!
FORMULATEXT – display a formula in another cell as text

Date functions

DAY, MONTH, YEAR – Extract day, month and year from a date in Excel
DATE – Create a date from individual values
WEEKDAY – Return the number of the day of the week
EOMONTH – Return the date of the last day of the month based on a specific date

Advanced

Index & Match lookup

INDEX – Retrieve cell in nth position in a range
MATCH – Find position of value in a range
INDEX MATCH – Just like VLOOKUP, only better.

Other advanced tools

SUMPRODUCT – Sum the products of Excel ranges
Excel Wildcards – Advanced searching and matching in Excel
Advanced Filter – Filter by multiple criteria in the same column, or even in different columns!

Power Query

Combine data from multiple Excel workbooks using Power Query
Column from Examples tool – Learn the secret to mastering Power Query without any prior knowledge!
Unpivot columns easily using Power Query

Secret Excel Functions

This section covers Excel functions that are not available in most of Excel’s versions. These functions will unlock a new set of capabilities such as fining only unique values, sorting, and filtering – the tutorials below will help you with mastering Excel’s new functions!

UNIQUE – Extract unique values from a range
SORT Function – Sort range dynamically
SORTBY – Sort range dynamically by using another range
FILTER Function – Filter range by specific criteria
RANDARRAY – Create an array of random numbers
SEQUENCE – Create a range of sequential values
LET – Assign values and calculations to names to improve your formula’s ease of use, readability, and performance!
HOT! – LAMBDA – The mother of all functions that will help you create amazing and powerful custom functions for your own need!
VSTACK – Vertically stack arrays/ranges in Excel
HSTACK – Horizontally stack arrays/ranges in Excel
CHOOSEROWS – Return specific rows from a range or array
CHOOSECOLS – Return specific columns from a range or array
TOROW – Convert a range/array into a single row
TOCOL – Convert a range/array into a single column

Financial Functions

Learn how to use Excel to make financial calculations!

Excel Financial Calculator – quickly calculate PV, FV, PMT, NPV, IRR
PMT – Calculate the periodic payment amount of a loan, mortgage, or another financial instrument
PV – Find the Present Value of a loan, mortgage, or any other financial instrument
HOT! – Excel Mortgage Calculator – Calculate your mortgage payments and get the payment schedule for the entire period of the loan – Step-by-step tutorial on how to build a Mortgage Calculator in Excel.

Excel Macros – VBA (Visual Basic for Applications)

Start here – How to run your first VBA Macro in Excel without knowing VBA?

Excel Data Sheets for Practice

Want to do some freestyle practice? Create your own Excel playground with our blank excel Worksheet!

Excel-Online Blank Worksheet
Excel Practice Data

How to Calculate in Excel – Excel-Online Calculators

Excel Financial Calculator – quickly calculate PV, FV, PMT, NPV, IRR
How to Calculate GPA in Excel
How to Calculate BMI in Excel
How to Calculate Density in Excel
How to Calculate Weighted Average in Excel

Lists in Excel (Download Link Available)

List of Numbers in Excel –Generate sequential or custom patterns of numbers for your Excel projects.
ABC List in Excel – Easily create alphabetical lists from A-Z for indexing, sorting, and categorization.
List of U.S. Statesin Excel – Access a comprehensive list of all 50 U.S. states.
Days of the Week in Excel – A quick list of the days of the week, essential for scheduling and planning.
Months of the Year in Excel – Download a list of the 12 months of the year for time-based analyses.
List of Colors in Excel – Explore a list of standard color names for data visualization and UI design.
Country List in Excel – A global list of countries for international datasets or geographic studies.
Holiday List in Excel – A curated list of standard holidays for planning and project management.
List of Currencies: A list of world currencies for financial modeling or international business.