![Excel VBA Array Tutorial](https://www.goskills.com/blobs/blogs/691/83702315-572f-4bfe-9a31-181741c2efff-thumb.jpg)
10 min
Excel VBA Array Tutorial
Understanding Excel VBA Array is crucial in mastering Microsoft Excel.
![Top 12 Excel Lookup Functions (+ Free Cheatsheet!)](https://www.goskills.com/blobs/blogs/753/b391b687-8636-489d-b4d8-f00ddeba9832-thumb.png)
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.
![Understanding Excel VBA If Then Else Statements](https://www.goskills.com/blobs/blogs/692/aab9c0c0-5e32-4b8b-988f-af70de60a0fe-thumb.jpg)
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.
![Excel Challenge 34: Advanced Data Validation](https://www.goskills.com/blobs/blogs/746/8cdf7ceb-30c5-4df6-8516-364ae97cc301-thumb.png)
4 min
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](https://www.goskills.com/blobs/blogs/749/191061f1-b4df-47b4-bd45-2c3d268d0b25-thumb.jpg)
8 min
How to Use the Excel FILTER Function
Learn how to use the dynamic FILTER function in Excel from scratch.
![Formula Auditing Tools in Excel](https://www.goskills.com/blobs/blogs/690/b0df5201-f1b3-400e-9786-4fa6a946c064-thumb.jpg)
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.
![Excel Challenge 33: What-If Analysis to Calculate Monthly Payments](https://www.goskills.com/blobs/blogs/743/894d5c6e-ee0f-4a09-8bcb-c976adbaadd1-thumb.jpg)
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 ...
![Understanding Number Formats in Excel](https://www.goskills.com/blobs/blogs/741/dba77f18-3d27-40b2-8bb2-fe452415c0fc-thumb.jpg)
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 ...
![Excel Challenge 32: Counting Values That Meet Conditions](https://www.goskills.com/blobs/blogs/739/fee22bf9-a276-4d5d-af08-9f75ae6238ba-thumb.png)
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.
![GoSkills Success Stories: How to Make a Successful Career Change](https://www.goskills.com/blobs/blogs/737/fd02e8f4-7b46-4f38-b34e-f706169e36ad-thumb.png)
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...
![Excel Challenge 31: Data Analysis with Power Query and Pivot Tables](https://www.goskills.com/blobs/blogs/732/50da7650-9562-4ec6-8405-94ab138caea9-thumb.jpg)
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...
![Excel Challenge 30: Create a Dynamic Chart Using Multiple Criteria](https://www.goskills.com/blobs/blogs/715/49a3dea0-e9ab-4a0c-be6f-534382f13f6d-thumb.jpg)
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.
![How to Use the OFFSET Function in Excel](https://www.goskills.com/blobs/blogs/706/cb846904-6aa5-4eb0-a31a-20bceb0a2670-thumb.jpg)
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...
![Excel Challenge 29: Make a Progress Bar in Excel](https://www.goskills.com/blobs/blogs/703/2f411e4d-5b45-48ed-8b8b-b89da2e59166-thumb.jpg)
3 min
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](https://www.goskills.com/blobs/blogs/698/0acd46bf-af59-4c43-a756-a14e2492abd1-thumb.png)
5 min
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)](https://www.goskills.com/blobs/blogs/697/e1f68af5-2393-45b2-a8ec-0b40714db566-thumb.jpg)
17 min
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](https://www.goskills.com/blobs/blogs/695/4b763ca7-df1e-402b-89da-01bf5a41ab9e-thumb.jpg)
3 min
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](https://www.goskills.com/blobs/blogs/662/0667f741-f066-4097-bca6-ae6bba5b0037-thumb.jpg)
6 min
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](https://www.goskills.com/blobs/blogs/687/3a44692d-c1a2-41f5-93ae-a0655ba8a564-thumb.jpg)
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...
![How to Use the Excel REPLACE Function](https://www.goskills.com/blobs/blogs/661/b84748db-eb82-44c8-b9e8-74621890db1f-thumb.jpg)
11 min
How to Use the Excel REPLACE Function
The Excel REPLACE function can be used in a variety of unexpected ways.