Resources
10 min
How to Use the Excel TEXTJOIN Function
Discover the Excel TEXTJOIN function as a simpler way to combine text strings than CONCATENATE and &. Learn tricks like line breaks and dynamic out...
18 min
The 10 Best Online IT Certifications for 2024
In an ever-growing industry, here are the best online IT certifications to stay on top of things.
11 min
How to Use the Excel REPLACE Function
The Excel REPLACE function can be used in a variety of unexpected ways.
3 min
Excel Challenge 27: Create a Dataset Using Random Selection
Take this Excel challenge to create a database using randomly-selected values from a list!
4 min
How to Use the Excel SEQUENCE Function
Your simple, no-fluff guide on how to use the SEQUENCE function in Excel. Use dynamic arrays to return multiple values with a single input.
13 min
Understanding the Importance of Sprint Planning in Agile Project Management
Learn the key benefits of Sprint Planning in Agile Project Management and how it can help teams prioritize tasks, allocate resources, and achieve p...
10 min
GoSkills 10th Anniversary Special: 10 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
10 Best Courses to Boost Your Career
From Excel to project management, GoSkills courses have helped thousands of learners improve their skills and advance their careers. Here are the t...
9 min
Tips From Experts: How to Manage Your Finances While Looking for a Job
Get expert tips on how to stay on top of your finances while searching for a job. Learn about budgeting, saving money, and reducing expenses to hel...
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. Use formulas and functions to accurately project growth o...
7 min
Introduction to VBA Editor in Excel
Open the VBA editor in Excel to add and edit VBA code. Learn the basics in this beginner-friendly, step-by-step guide.
10 min
The Ultimate Guide to Pivot Tables in Excel
Master pivot tables in Excel to summarize and make sense of large data sets. Learn how to create pivot tables, create filters, slicers, and more.
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.
2 min
Excel Challenge 24: Extract Unique Values From a Dataset
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 a VBA message box with this easy ...
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.