Resources in Microsoft Excel
3 min
Excel Challenge 52: Data Analysis With PivotTables
Use PivotTables to perform data analysis with this sales performance Excel challenge.
3 min
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.
11 min
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 mor...
3 min
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!
3 min
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 anal...
3 min
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.
3 min
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.
15 min
Sample Copilot Prompts for Excel 365
Learn how to use Copilot prompts in Excel to simplify data analysis, create visualizations, and perform predictive analytics.
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...
11 min
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.
3 min
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...
3 min
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!
9 min
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.
4 min
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...
10 min
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...
13 min
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...
3 min
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...
4 min
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!
11 min
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...
4 min
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...