Microsoft Excel Resources

Excel Challenge 47 - Calculate Vacation Entitlement

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

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

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

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

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!

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!

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

Join 472,638 serial learners

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

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!