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.
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.
12 min
How to Use the Excel FIND Function
The Excel FIND function helps you look for something within a specific text string. Learn how in this tutorial.
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.
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...
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 ...