In this course you will learn:
“How to make beautiful, interactive, dynamic & insightful Dashboard by using advance functionality of MS Excel?”
“How to visualize your data in MS Excel?”
“Business Analytics in MS Excel”
“How to create infographicsin Excel?”
“How to create auto populated dashboards (HR, Sales, Finance, IT etc.) as like Tableau/Power BI and other analytical software's”

Part 1: Advance Excel Functionality
Module 1 :Useful functions & Name Manager
Module 2:Pivot Table / Chart & Power Query
Module 3:Conditional Formatting, Charts in cell
Module 4:Shapes, Smart Arts & Sparkline’s
Module 4:Charts

Module 5:Infographics & Conditional charts
Module 6 :Control Tools &
Macro Recording (Basics for Understanding)
Part 2: Case Studies
Dashboard Planning
Database Management
Space Management
Infographics / Chart Selection
Finalization of Dashboard
Linking between two dashboards

Step by step working on dashboards (choose as per your profile):
PMS DashboardAbsence Dashboard
Recruitment DashboardHelpdesk
Attrition DashboardEngagement Dashboard
Process Implementation DashboardPayroll & Compensation
Learning & DevelopmentManager’s Sales Analysis Dashboard
Product Dashboard (New, Critical, Top)Sales Representative Dashboard

GST Dashboard 

Useful functions & Name Manager:

Lookup Functions: vlookup, match, index
Sumif, Countif, Averageif
Indirect Function
Min, max, iferror, #na
Offset & Name Manager
Table concept for dynamic range

Pivot Table / Pivot chart

Pivot Table
Pivot Chart
Timeline
Slicers
Getpivot function

Power Query:

Merging of data
How to make huge data dashboards

Conditional Formatting & Charts in Cell

Chart in Cell & Cell Formatting

Shapes , Smart Arts & Sparkline's

Control Tools

Macro Recording 

Charts

Infogrpahics

Infographics in Charts

Conditional Charts

Case Studies
Step by step Dashboard Creation.. How to create dynamic dashboard with the help of Slicers & Timelines?

Selection of right chart & effective use of their formatting

Use of Infographics & linking of dashboards

How to create version compatibility dynamic dashboard with the help of control tools?

Tricks to remember keyboard shortcut keys
Master Shortcut KeyVNautoAnalyticsAutomate processes.. Use Analytics.. Grow Business

VNautoAnalytics

Automate processes.. Use Analytics.. Grow Business..