Module 3: Advance Pivot Table
In this course, you will learn how to use Pivot Tables to summarise data points from large databases.
Take this course to learn more.
Happy Learning!
Module 5: Data Forms
In this course, you will learn how to use Data Forms to find, sort, and edit large databases that include data spread across multiple rows and columns with numerous of datapoints.
Take this course to learn more.
Happy Learning!
Module 4: What-if Analysis
Decision making is a crucial part of any business or job role. The What-If analysis, which is an Excel tool, can help you make such informed decisions by running reverse calculations, sensitivity analysis, and scenario comparisons.
In this course you will learn how to use two functions – which are part of the What-If Analysis toolkit – viz.:
1. The Goal Seek function which can help you determine the possible input value necessary to achieve the desired result or outcome.
2. The Scenario Manager function which can help you create multiple plans or scenarios to analyse data.
Take this course to learn more.
Happy Learning!
Module 2: Working with External Data
In this course, you will learn how to Query External Databases, import text files, and use the Power Query Editor.
Take this course to learn more.
Happy Learning!
Module 1: Conditional Formatting using Formula and Function
In this course, you will learn how to use Conditional Formatting with the AND, OR, and Vlookup functions.
Take this course to learn more.
Happy Learning!
