Resources in Microsoft Excel
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.
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.
7 min
GoSkills Success Stories: How to Make a Successful Career Change
Considering a career change is increasingly common. But is it the right move? For those committed, here are five tips to ensure a successful transi...
4 min
Excel Challenge 31: Data Analysis with Power Query and Pivot Tables
In this Excel Challenge you’ll practice Data Analysis skills with Power Query and Pivot Tables. Solve a data challenge that’s based on a real-world...
3 min
Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria
Take this free Excel challenge to test your ability to make dropdown lists and dynamic charts! Learn real-word skills in data management.
10 min
How to Use the OFFSET Function in Excel
The Excel OFFSET function returns a cell or range of cells based on a reference point. It can be used to bring about dynamic behavior, even in lega...