Resources in Microsoft Excel
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...
7 min
Why Your Team Needs Excel Training
Team Excel training can help your organization perform tasks better and faster. Here’s the best way to train them.
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.
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...
4 min
Excel Challenge 36: Calculate and Maximize Commission With What-If Analysis
Can you apply what-if analysis to a real-world situation? Take this Excel challenge to find out.
8 min
An Introduction to Excel VBA Functions
Use this helpful guide to Excel VBA functions for a solid introduction to one of Excel's most powerful tools.
5 min
Excel Challenge 35: Create an Invoice Tracker
Challenge yourself to create a tracker in Excel that updates automatically when invoices are due soon or overdue.
10 min
Excel VBA Array Tutorial
Understanding Excel VBA Array is crucial in mastering Microsoft Excel.
24 min
Top 12 Excel Lookup Functions (+ Free Cheatsheet!)
Learn how to use the top 12 Excel lookup functions and download a free cheatsheet to keep for easy reference.
9 min
Understanding Excel VBA If Then Else Statements
Get a comprehensive overview of the If Then Else statement in Excel VBA and its different syntaxes.
4 min
Excel Challenge 34: Advanced Data Validation
Flex your data validation and worksheet protection skills with this month's Excel challenge.
8 min
How to Use the Excel FILTER Function
Learn how to use the dynamic FILTER function in Excel from scratch.
10 min
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.
3 min
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 ...
7 min
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 ...
3 min
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.