Microsoft Excel Resources

Copilot in Excel — How to Get Started

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

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 minim...

Excel Challenge 45: Create an Interactive Sales Chart

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!

200+ Best Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fan...

16 Best Free Excel Chart Templates for Your Business

16 Best 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

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 Chall...

How to Use the IFS Function in Excel

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...

What Excel Skills Are Employers Looking For?

What Excel Skills Are Employers Looking For?

Excel skills are required for most admin, engineering, and management jobs and can provide a pathway to high-paying jobs if you don't have a colleg...

Excel Challenge 43: Assign Random Values From a List

Excel Challenge 43: Assign Random Values From a List

Test your skills with this Excel challenge: create random schedules for athletes and display dynamic rosters. Dive in, explore our resources, and g...

Excel Challenge 42: Prepare an Excel Worksheet for Printing

Excel Challenge 42: Prepare an Excel Worksheet for Printing

In this Excel challenge, reformat and prep a messy sales worksheet for printing. Join our Slack community; you might learn a trick or two!

Join 470,487 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

Nesting Multiple Formulas in Excel: A Beginner’s Guide

Nesting Multiple Formulas in Excel: A Beginner’s Guide

Nested functions allow you to combine multiple functions in Excel to perform several calculations in one go. Learn best practices and tips for form...

Excel Challenge 41: Transforming Data With Excel Functions

Excel Challenge 41: Transforming Data With Excel Functions

Take this Excel challenge to convert data in different formats using Excel functions. Which formulas will you use to organize this group of maratho...

Excel Challenge 40: Create a Custom Excel Calculator

Excel Challenge 40: Create a Custom Excel Calculator

Would you like to build your own Excel calculator? It might be easier than you think! Take the challenge and see how our community members solved it.

Sort Functions in Excel — How to Use SORT and SORTBY

Sort Functions in Excel — How to Use SORT and SORTBY

Excel sort functions are superior to manual sorting methods because they will automatically update the sort order without user intervention.

Excel Challenge 39: Generate Unique Random Values

Excel Challenge 39: Generate Unique Random Values

What is the best way to generate random values in Excel? Better yet, can you make them unique? Put your skills to the test with this Excel challenge.

Excel Challenge 38: Data Lookup From Multiple Sources

Excel Challenge 38: Data Lookup From Multiple Sources

Take this Excel challenge by showing us what to do when XLOOKUP or VLOOKUP alone isn't enough to extract the values you want.

How to Use Excel to Manage Your Travel Budget

How to Use Excel to Manage Your Travel Budget

You'll probably want to avoid surprises like going over budget when you travel. Take charge with these expert tips for managing your travel expense...

Mastering Excel: A Beginner’s Guide to 10 IF Functions (+Free Cheatsheet!)

Mastering Excel: A Beginner’s Guide to 10 IF Functions (+Free Cheatsheet!)

Master IF functions in Excel with this beginner's guide. Learn their logic and uses with real-world examples. Free cheatsheet included!

Using VBA Range Object in Microsoft Excel

Using VBA Range Object in Microsoft Excel

Learn how to use Excel VBA Range object for manipulating cell ranges to streamline your spreadsheets.

Excel Challenge 37: Keeping Track of Inventory

Excel Challenge 37: Keeping Track of Inventory

Use Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby.