Resources in Microsoft Excel
![How to Calculate Averages in Excel (7 Simple Ways)](https://www.goskills.com/blobs/blogs/470/c6e63ac9-d1ee-4e41-804f-ebfe518d91b7-thumb.jpg)
12 min
How to Calculate Averages in Excel (7 Simple Ways)
Learn how to calculate averages in Excel using the AVERAGE, MEDIAN, and MODE functions.
![How to Create Pivot Table Calculated Fields](https://www.goskills.com/blobs/blogs/469/7a394f4e-4223-4529-a28d-f567114864d2-thumb.jpg)
6 min
How to Create Pivot Table Calculated Fields
Want to level up your pivot table skills? Learn how to add and modify a pivot table calculated field with this how-to guide.
![The SUMIFS Excel Function](https://www.goskills.com/blobs/blogs/466/a383bbe1-c862-4dd0-82bf-8099dadced6f-thumb.jpg)
7 min
The SUMIFS Excel Function
Learn how to use the SUMIFS Excel function to add values that meet multiple specific criteria with this step-by-step tutorial.
![How to Use the IF Function in Excel](https://www.goskills.com/blobs/blogs/457/f85f1ea4-98e0-4e11-8cfa-5d6bafd8b059-thumb.jpg)
8 min
How to Use the IF Function in Excel
Learn how to use the IF function in Excel and see how it can be combined with the OR and AND functions.
![The SUMIF Excel Function](https://www.goskills.com/blobs/blogs/464/c375bdee-ab16-4b44-b84c-12c6f5428eb0-thumb.jpg)
![The COUNTIF Function in Excel](https://www.goskills.com/blobs/blogs/461/841d4535-cb40-43f1-95cd-4cc1cab7fce2-thumb.jpg)
9 min
The COUNTIF Function in Excel
Improve your data management skills by learning how to use the COUNTIF function in Excel.
![The Excel AND Function](https://www.goskills.com/blobs/blogs/462/2eee9472-a0d9-4381-8ef5-a851fe9b559b-thumb.jpg)
9 min
The Excel AND Function
Learn how to use the Excel AND function and combine it with other functions for more flexibility.
![How to Create a Running Total in Excel (Cumulative Sum)](https://www.goskills.com/blobs/blogs/459/166f12f4-d1e5-4bff-9380-023072d6dba0-thumb.jpg)
9 min
How to Create a Running Total in Excel (Cumulative Sum)
Learn how to create a running total in Excel with this step-by-step tutorial.
![The Excel OR Function](https://www.goskills.com/blobs/blogs/453/45a4c103-0d6d-4f3d-a4b0-6ce0a0b7a9b0-thumb.jpg)
6 min
The Excel OR Function
What is the Excel OR function? How do you use it? Find out in this tutorial.
![Excel Challenge 4: Analyze Data With Power Query](https://www.goskills.com/blobs/blogs/454/8c41c50f-34f5-4d06-8957-91b686f01d0c-thumb.jpg)
3 min
Excel Challenge 4: Analyze Data With Power Query
Ready for some more fun with Power Query in Excel? Try solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga).
![The New Excel LET Function](https://www.goskills.com/blobs/blogs/452/b76ac0ef-294d-455e-8004-3c7251da5e0f-thumb.jpg)
4 min
The New Excel LET Function
Learn about the new Excel LET function. This new function can help make complex formulas easier to read and use.
![The Excel Ribbon](https://www.goskills.com/blobs/blogs/445/7e2e9225-1456-4384-8d73-9f4056c0e997-thumb.jpg)
7 min
The Excel Ribbon
Improve your Excel navigational skills with these tips on how to use and customize the Excel ribbon.
![How to Sort in Excel](https://www.goskills.com/blobs/blogs/450/88ebc103-92dd-4128-9fa6-374236decb3f-thumb.jpg)
14 min
How to Sort in Excel
Learn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting.
![Excel Challenge 3: Power Query and Pivot Tables](https://www.goskills.com/blobs/blogs/437/fe4f40fd-fe0e-42f0-a58f-53c0b2e87e47-thumb.jpg)
2 min
Excel Challenge 3: Power Query and Pivot Tables
Use power query and pivot tables to solve this GoSkills Excel challenge by Alan Murray.
![VLOOKUP Exact Match & Approximate Match](https://www.goskills.com/blobs/blogs/441/f6690e64-4f05-4e3d-8b9e-bc648f553d2f-thumb.jpg)
7 min
VLOOKUP Exact Match & Approximate Match
Learn one of Excel's most useful functions: VLOOKUP exact match and approximate match.
![VBA Variable Types in Excel](https://www.goskills.com/blobs/blogs/440/ee8b72e2-96ed-4b13-a3b9-37e814986717-thumb.jpg)
12 min
VBA Variable Types in Excel
Learn what a variable is, why they are important, and understand how to use the different VBA variable types in Excel.
![How to Remove Blank Rows in Excel](https://www.goskills.com/blobs/blogs/431/5e15c192-9b3b-4f27-88b3-ece1d8af3576-thumb.jpg)
9 min
How to Remove Blank Rows in Excel
Avoid data errors by learning how to remove blank rows in Excel the right way.
![Mixed References in Excel - a Beginner's Guide](https://www.goskills.com/blobs/blogs/433/3a0d6bd3-73a0-48c9-b4de-f6c65ad70320-thumb.jpg)
6 min
Mixed References in Excel - a Beginner's Guide
Learn all about the mixed reference Excel feature in this beginner's guide.
![Relative References in Excel - A Beginner's Guide](https://www.goskills.com/blobs/blogs/428/d090ef4e-e2f5-4f4d-af64-32165cde232a-thumb.jpg)
6 min
Relative References in Excel - A Beginner's Guide
Learn all about the relative reference Excel feature in this beginner's guide.
![Excel Challenge 2: Clean and Transform Data with Power Query](https://www.goskills.com/blobs/blogs/425/d654633f-d611-4079-aa35-80efd7508cf9-thumb.png)
2 min
Excel Challenge 2: Clean and Transform Data with Power Query
Ready for some fun with Power Query in Excel? Try your hand at solving this Excel challenge from Excel MVP Alan Murray (aka. Computergaga) now!