Learn Excel Online

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!

16 Free Excel Chart Templates for Your Business

Download 16 of the best chart templates for business in project planning, financial management, sales, social media analytics, and more.

Excel Challenge 44: Build an Employee Performance Review Sheet

Create a performance review sheet in Excel with weighted scores, conditional formulas, and a radar chart. Test your skills in GoSkills’ Excel Challenge 44!

How to Use the IFS Function in Excel

The IFS function in Excel returns different results based on the result of progressive logical tests. It is a newer alternative to nesting multiple IF statements.