Free Excel Tutorials & Practice

Excel Challenge 53: Dependent Dropdown Lists

Practice creating dependent dropdown lists in Excel with this fun challenge! Learn how our expert solved it in the easy-to-follow solution tutorial.

Excel Challenge 52: Data Analysis With PivotTables

Use PivotTables to perform data analysis with this sales performance Excel challenge.

Excel Challenge 51: Build an Amortization Schedule

Build an interactive Excel tool to track loans and payments! Master finance functions to create your own amortization schedule template.

How to Add Error Bars in Excel

Error bars display the degree of variability associated with the data presented. Learn how to use them in Excel to make your charts clearer and more accurate.

Excel Challenge 50: Break-Even Analysis Using Data Tables

Master break-even analysis in Excel! Use data tables and conditional formatting to identify profit and loss scenarios. Take on this challenge now!

Excel Challenge 49: Create a Dynamic Lookup Tool With Images

Build a dynamic lookup tool in Excel to retrieve player details—including images! Plus, create an interactive PivotTable with slicers for easy analysis.

Excel Challenge 48: Build a Library Book Tracker

Flex your Excel formula skills with this library book tracker challenge! Tackle real-world tasks and sharpen your data analysis expertise.

Excel Challenge 47 - Calculate Vacation Entitlement

Master Excel skills with this employee vacation tracker challenge. Practice date functions, lookups, and advanced logic for workforce management.

Sample Copilot Prompts for Excel 365

Learn how to use Copilot prompts in Excel to simplify data analysis, create visualizations, and perform predictive analytics.

Copilot in Excel — How to Get Started

Learn how to enable Copilot in Microsoft Excel to automate tasks, enhance data analysis, and boost productivity using AI and natural language prompts.

Excel Challenge 46: Inventory Optimization With Excel Solver

In this Excel practice exercise, optimize inventory levels across stores and warehouses! Using Solver, balance stock levels, meet demand, and minimize costs.

Excel Challenge 45: Create an Interactive Sales Chart

If you're creating a dashboard in Excel, an interactive chart will most likely be one of the elements. Learn how to create one in this fun scenario!