Resources in Microsoft Excel

10 min
GoSkills Top 10: Our Must-Read Resources for Leveling Up Your Career
These GoSkills resources provide the best tips for personal and professional development. Discover even more helpful ways to boost your career and ...

3 min
Excel Challenge 26: VLOOKUP With Duplicates
In this Excel challenge, some of the lookup values are duplicated in the source data set. Can you get Excel to find the right one?

8 min
GoSkills Top 10: Our Most Popular Online Courses
This blog celebrates GoSkills' 10th anniversary and counts down its top 10 most popular online courses. From Excel to project management, the cours...

15 min
How to Use the Excel MID Function
The Excel MID function helps you extract a piece of text when there is text on either side.

8 min
How to Calculate Compound Interest in Excel
Discover how to easily calculate compound interest in Excel with this step-by-step guide. Learn the formulas and functions needed to accurately pro...

7 min
Introduction to VBA Editor in Excel
Writing VBA code enables you to create powerful macros that can complete repetitive tasks at the push of a button. Learn how to use the VBA editor ...

11 min
The Ultimate Guide to Pivot Tables in Excel
Learn how to master pivot tables in Excel to summarize, discover trends, and make sense of large data sets. This guide covers how to create pivot t...

2 min
Excel Challenge 25: Convert Dates Stored as Text
What are your options when dates in Excel are stored as text? Take this Excel challenge for a spin, then check out our solution!

5 min
How to Use the Excel ISERROR Function
Figure out whether an input will result in an error in advance with the Excel ISERROR Function.

13 min
Your Guide to VLOOKUP Table Array
Learn the most useful tips and best practices for using VLOOKUP Table Array, from Microsoft Excel expert Claudia Buckley.
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...

2 min
Excel Challenge 24
Can you leverage the power of combining Excel dynamic array formulas? Take this Excel challenge to return unique values and non-contiguous columns!

9 min
Easy VBA Message Box Tutorial
Improve the interactivity of your worksheet by adding a message box to your macro's VBA code. Learn how to create your first message box with this ...

7 min
How to Divide in Excel
As simple as division may seem, learning how to divide in Excel is key to mastering some of the most complex functions and formulas.

11 min
How to Freeze Panes in Excel
Once you learn how to freeze panes in Excel, analyzing giant spreadsheets won't seem so daunting.

10 min
13 Tax Benefits and Deductions for the Self-Employed
Reduce your self-employment taxes with these 13 tax benefits and deductions you could be claiming.

2 min
Excel Challenge 23
Take this Excel challenge! How do you rank the top 5 agents when duplicate scores exist?

10 min
Pivot Table Filter in Excel
So you've entered all your data in Excel and you want to zero in on a special segment. Pivot Table filters help to display select portions of data ...

12 min
Handling Lookups for Multiple Criteria in Excel
Learn how to lookup multiple criteria in Excel. Analyze the best options from the FILTER function to XLOOKUP.

2 min
Excel Challenge 22
Can you create a dynamic cell range reference in Excel? Take our latest Excel challenge to prove it!