Microsoft Excel Resources

Excel VBA Array Tutorial

Excel VBA Array Tutorial

Understanding Excel VBA Array is crucial in mastering Microsoft Excel.

Top 12 Excel Lookup Functions (+ Free Cheatsheet!)

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.

Understanding Excel VBA If Then Else Statements

Understanding Excel VBA If Then Else Statements

Get a comprehensive overview of the If Then Else statement in Excel VBA and its different syntaxes.

Excel Challenge 34: Advanced Data Validation

Excel Challenge 34: Advanced Data Validation

Flex your data validation and worksheet protection skills with this month's Excel challenge.

How to Use the Excel FILTER Function

How to Use the Excel FILTER Function

Learn how to use the dynamic FILTER function in Excel from scratch.

Formula Auditing Tools in Excel

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.

Excel Challenge 33: What-If Analysis to Calculate Monthly Payments

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

Understanding Number Formats in Excel

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

Join 430,152 serial learners

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

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

Excel Challenge 32: Ways To Count Values With Specific Criteria

Excel Challenge 32: Ways To Count Values With Specific Criteria

Explore ways to count values with specific criteria and flex your problem-solving skills with this month's Excel challenge.

GoSkills Success Stories: How to Make a Successful Career Change

Finance

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

GoSkills Success Stories: How Online Learning Can Help You Grow Professionally (and Personally)

GoSkills Success Stories: How Online Learning Can Help You Grow Professionally (and Personally)

To grow professionally doesn’t just mean climbing the corporate ladder. Explore four ways online learning fosters professional growth.

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

Excel Challenge 31: Data Analysis with Power Query and Pivot Tables

Find out the solution to Excel Challenge #31!

How To Do a Mail Merge in Excel

How To Do a Mail Merge in Excel

A step-by-step guide to mail merge in Microsoft Word using an Excel source list.

Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria

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!

How to Use the OFFSET Function in Excel

How to Use the OFFSET Function in Excel

The OFFSET function in Microsoft Excel returns a cell or range of cells based on a reference point. It can be used to bring about dynamic behavior,...

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