• Using other formula within If Function

• Use calculation inside if Function

• Learn how to add multiple if conditions?

• Understand the usage of IFS

• IFS is used to check multiple conditions up to 127 times

• Auditing Formula

• Trace Precedents

• Trace Dependents

• Show Formulas

• Help us to get the desired output or summaries

• Converting the data as table

• Renaming the table to our convenance

• Insert-Pivot Table

• Add desired summaries or headers using drag and drop method in Pivot Table

• Get data summary based on dates, month, year

• Adjusting the decimal points value in numbers

• Number formatting in Values

• Group selection - This is to get the data based on Quarter

• Ungrouping a selection

• Manfully group the data using Pivot Table Analyzer

• Filtering data

• Analysis of data

• Drilling down the data

• Comparing data for analysis

• Adding slicer (Data Headers) for better viewability and customization

• Adding TimeLine for filtering the data based on time

• Adding chart using PivotChart

• Understand the use of Macro

Explains how to create a Macro

• Learn to create a Button

• Assign Macro to Button