Learn Excel Online

Formula Auditing Tools in Excel

Learn how to use formula auditing tools in Excel, like trace precedents & trace dependents, to identify and troubleshoot any formula errors.

Excel Challenge 33: What-If Analysis to Calculate Monthly Payments

Can you use Excel to calculate monthly loan payments using a what-if analysis? Do you know of any other methods? Take the challenge and share your solution!

Understanding Number Formats in Excel

Excel has built-in number formats to control how cells with numeric data appear in Excel. Learning how they work will help you represent your data correctly.

Excel Challenge 32: Counting Values That Meet Conditions

Explore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge.

GoSkills Success Stories: How to Make a Successful Career Change

Considering a career change is increasingly common. But is it the right move? For those committed, here are five tips to ensure a successful transition.

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

In this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world scenario.

Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria

Take this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management.

How to Use the OFFSET Function in Excel

The Excel OFFSET function returns a cell or range of cells based on a reference point. It can be used to bring about dynamic behavior, even in legacy Excel.

Excel Challenge 29: Make a Progress Bar in Excel

Challenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution!

GoSkills Success Stories: How 30 Minutes of Online Learning Led to a Promotion

Thirty minutes a day of learning new skills can have impactful outcomes, like a job promotion. This is the story of a GoSkills learner.

10 Most Common Excel Errors (and How to Fix Them)

Understand and solve common Excel errors, such as #DIV/0!, #N/A, #NAME? with this comprehensive guide and handy tips for error checking and formula auditing.

Excel Challenge 28: Create a Column Chart With Conditional Formatting

This Excel Challenge asks you to create a column chart that applies conditional formatting and other advanced elements. This isn't your everyday Excel chart, so join the fun and check out our solution!