Microsoft Excel

Resources in Microsoft Excel

Excel Challenge 29: Make a Progress Bar in Excel

Excel Challenge 29: Make a Progress Bar in Excel

Challenge your ability to create a functional progress bar in Excel with this workout, then check out our expert's solution!

GoSkills Success Stories: How 30 Minutes of Online Learning Led to a Promotion

GoSkills Success Stories: How 30 Minutes of Online Learning Led to a Promotion

Thirty minutes a day of learning new skills can have impactful outcomes, like a job promotion. This is the story of a GoSkills learner.

10 Most Common Excel Errors (and How to Fix Them)

10 Most Common Excel Errors (and How to Fix Them)

Understand and solve common Excel errors, such as #DIV/0!, #N/A, #NAME? with this comprehensive guide and handy tips for error checking and formula...

Excel Challenge 28: Create a Column Chart With Conditional Formatting

Excel Challenge 28: Create a Column Chart With Conditional Formatting

This Excel Challenge asks you to create a column chart that applies conditional formatting and other advanced elements. This isn't your everyday Ex...

PI Function in Excel

PI Function in Excel

PI is one of the most popular numbers in mathematics, and it pops up quite frequently in the physical world. Unsurprisingly, Excel carries a functi...

How to Use the Excel TEXTJOIN Function

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...

How to Use the Excel REPLACE Function

How to Use the Excel REPLACE Function

The Excel REPLACE function can be used in a variety of unexpected ways.

Excel Challenge 27: Create a Dataset Using Random Selection

Excel Challenge 27: Create a Dataset Using Random Selection

Take this Excel challenge to create a database using randomly-selected values from a list!

How to Use the Excel SEQUENCE Function

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.

GoSkills 10th Anniversary Special: 10 Resources for Leveling Up Your Career

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 ...

Excel Challenge 26: VLOOKUP With Duplicates

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?

How to Use the Excel MID Function

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.

How to Calculate Compound Interest in Excel

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...

Introduction to VBA Editor in Excel

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.

The Ultimate Guide to Pivot Tables in Excel

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.

Excel Challenge 25: Convert Dates Stored as Text

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!

How to Use the Excel ISERROR Function

How to Use the Excel ISERROR Function

Figure out whether an input will result in an error in advance with the Excel ISERROR Function.

Join 473,156 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

Your Guide to VLOOKUP Table Array

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.

Excel Challenge 24: Extract Unique Values From a Dataset

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!

Easy VBA Message Box Tutorial

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 ...