Resources
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...
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
Help Employees Understand Why You Use SCRUM for Project Management
You might be ready to make the change to SCRUM project management, but how do you get your team on board? Explain the "why" with this simple guide.
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!
7 min
Why Employers Will Value Soft Skills Over Tech in the Age of AI
As AI becomes ubiquitous, it's becoming increasingly difficult to stand out. Learn how to use your soft skills in a tech-saturated environment.
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...
3 min
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.
8 min
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.
3 min
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.
5 min
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.
11 min
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...
12 min
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!
8 min
Using VBA Range Object in Microsoft Excel
Learn how to use Excel VBA Range object for manipulating cell ranges to streamline your spreadsheets.
3 min
Excel Challenge 37: Keeping Track of Inventory
Use Excel to keep track of inventory with this challenge, guided by Microsoft MVP Deb Ashby.
99 Insanely Helpful Word 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 Word. Well, get ready to be even fanc...
100 Insanely Helpful PowerPoint 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 PowerPoint. Well, get ready to be eve...
9 min
A Quick Reference Guide to Excel VBA Loops
Automate repetitive tasks in Excel using Loops in VBA. Learn about For Loops and Do Loops with examples and syntax. Check out GoSkills' Excel resou...