Resources
13 min
A Beginner's Guide to What If Analysis in Excel
To help you do a what if analysis in Excel, there are three tools. Learn how to use them all in this guide - Goal Seek, Scenario Manager, and data ...
7 min
How to Calculate Weighted Average in Excel
Explore this guide on how to calculate a weighted average in Excel using the SUMPRODUCT function.
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. Includes a video walkthrough and exercise file.
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.
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.
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.
9 min
The COUNTIF Function in Excel
Improve your data management skills by learning how to use the COUNTIF function in Excel.
9 min
The Excel AND Function
Learn how to use the Excel AND function and combine it with other functions for more flexibility.
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.
6 min
The Excel OR Function
What is the Excel OR function? How do you use it? Find out in this tutorial.
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.
10 min
How to Design Your Own Professional Development Plan
Are you ready to take your career to the next level? Map out your career goals with this free professional development plan sample.
7 min
The Excel Ribbon
Improve your Excel navigational skills with these tips on how to use and customize the Excel ribbon.
19 min
Value Stream Mapping (Free Templates Included)
Learn what value stream mapping is, when and how to use it, and how to conduct your own value stream analysis.
14 min
How to Sort in Excel
Learn how to sort in Excel including multi level sorting, alphabetical sorting, numeric sorting, and custom sorting.
13 min
11 Microsoft Teams Features You Should Be Using
Learn about essential Microsoft Teams features and tools that you should be using in your workplace.
16 min
11 Best Note Taking Apps for Windows and macOS
What are the best note taking apps for Windows and macOS? We itemize the best notes apps to use so you can better collect, organize, and share your...
25 min
QuickBooks Online vs Desktop: The Ultimate Guide
Which product should you use for your bookkeeping needs? Get the information you need to make the best decision in this QuickBooks Online vs Deskto...
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.