Resources in Microsoft Excel
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!
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
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.
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.
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.