Professional Interactive Excel Dashboards

English + Hindi
Batch Size
12 hours
Request Training Proposal

Course Contents

Create Professional Interactive Excel Dashboards from scratch

Module 1 (4 hrs)

Introduction to Excel 2016
•    Excel 2016 Overview
•    Basics of Excel
•    Shortcuts of Excel
•    Keyboard Shortcuts

Working with Formulas
•    Text function – Left,Right,Mid,Upper,Lower,Proper,Concatenate Etc
•     Statistical function – Sum. Max,Min, Large, Small, Average Etc
•    Date/Time Functions: Using The TODAY,  NOW & DATE Functions

Create named ranges
•    Create and revise a formula
•    create a formula that references an Excel table
•    use relative and absolute references  

Logical Functions:
•    IFs and Nested IF Functions
•    Using AND/OR/NOT Functions 

More Statistical Functions:
•    Using The SUMIF/COUNTIF, COUNTA,RANK  Functions
•    Array Formulae’s- SumProduct

Chart Data Techniques:
•    The Chart Wizard 
•    Chart Types  -Line,Pie,Bar,Waterfall
•    Formatting/Renaming/Deleting Data Series 
•    Changing the Order of Data Series 
•    Adding Trend Line  , Display data on Secondary Axis
Module 2 ( 4 hrs)

Data Tools
•    Converting Text to Columns
•    Remove duplicates
•    Data Validation

Advanced Conditional formatting:
•    Highlight data on basis of cretin condition 
•    Add data bar
•    Trend lines  

LOOKUP Functions:
•    The VLOOKUP/HLOOKUP , XLOOKUP Functions   
•    Match, Index, Iferror

What if Analysis
•    Goal Seek
•    Data Table
•    Scenario Reports

Module 3 (4 hrs)

•    Creating  Formatting  Simple PivotTables 
•    Page Field in a PivotTable 
•    Formatting a PivotTable 
•    Creating/Modifying a PivotChart 
•    Insert Calculated Field (formulas)

Create 3 Professional Interactive Excel Dashboards from scratch
•    Create dashboard with Sparklines and Conditional Formatting
•    Heat Map Dashboard
•    Business Sales Dashborad

Overview of Macros

Excel Final Assignment


Instructor Profile


Ritu is an expert in Microsoft Office & Power BI with core developmental skills in MS-Excel, MS-Access, VBA, Advanced Excel, RDBMS, and all other areas of data management. She has also written a book on Advance Excel 2016.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

StepUpwards Training Requirement Form

Please complete this form so we can get back to you with a training proposal.

By clicking "Submit", you agree to our Terms of Use , Privacy Policy and Service Agreement

Individuals younger than 18 years of age, but of the required age for consent to use online services, as per applicable law in their country of residence may set up an account and enroll in appropriate courses through their parent or guardian. Individuals younger than the required age for consent to use online services may not use the Services offered by StepUpwards Platform. For more details, please refer to our Privacy Policy.

Related courses


Microsoft PowerPoint 2016


Ritu Arora

View Course

Advanced Excel


Ritu Arora

View Course

Master Excel - Beginner to Advanced


Ritu Agarwal

View Course