SYLLABUS Advance Excel + Dashboard
Essential Excel 18 Topics
Charts
Multicategory Chart
Static Transpose
Find Depreciation of an Asset
Logical Functions like IF, IF-Else
Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim
Lookup
Subtotal Function
Rank Function
Rand and Randbetween
Sumproduct
Choose
Format as table
Conditional formatting
Page setup & Print
Freeze Panes
Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,
Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions
Advance Excel 30 Topics
Concatenate Function
Logical Functions like Nested IF, Complex IF-ELSE-IF, IFERROR, AND & OR
Dynamic Transpose
Criteria Based Functions: Sumif and sumifs, Countif and Countifs, Averageif and Averageifs functions
Advance Filters
Absolute, Relative & Mixed Reference
Advance Conditional Formatting
Index, Match function
Data Validation
Data validation with Dependent List
PMT function
PPMT and IPMT Function
What if Analysis (Scenario, Goal seek, Data Table, Forecast)
Pivot Table
Consolidate data Sheets
Dsum, Dmax, Dmin & Daverage
Vlookup Function
Double Vlookup Function
Advance Vlookup with Max-Min, Vlookup with IfError, Vlookup with Validation, Intersheet Vlookup with Referencing
Hlookup Function
How to Export Sheet into PDF
Basic Macros
Advance Charts(Donut Chart, Speedometer Chart, Trend Arrows, Target vs Actual, Scatter chart, Thermometer Chart, Gantt chart with conditional Forma
Protect worksheet & Formulas
Advance Conditional Formatting with Form Control
Triple VLookup
VLookup & HLookup with Match Function
Solver Function
Dynamic Offset with Sum & Average Function
Forecast Sheet
Dashboard in Excel 10 Topics
Excel Dashboard Introduction
Data visualization in Excel Dashboard using charts
Interactive elements (form controls) into dashboard
Sales Dashboard from scratch
HR Dashboard from scratch
Single and Multiple slicer to filter the Pivot Table
Advance Pivot Charts connectivity with multiple slicer
Timeline for Pivot Charts using form control
Advance Charts (Multi category Charts, Donut Chart, Speedometer Chart, Thermometer Chart)
KPI(Key Performance Indicator) Dashboard
What you'll learn Advance Excel + Dashboard
- Suitable for beginners to advanced users ideal for users who learn faster when shown
- Become proficient with Mail Merge using Excel Spreadsheet
- Functions like PMT, Vlookup, Hlookup, Double vlookup, deleting duplicates
- Create Sales Dashboard
- Single and Multiple slicer to filter the Pivot Table
- Create HR Dashboard
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 51% Scholarship
-
Monday 27-May-2024 -
Wednesday 29-May-2024 -
Thursday 30-May-2024 -
Friday 31-May-2024
About Advance Excel + Dashboard Course in
At the end of the course, we will learn how to create a dashboard, and some more advanced points in the dashboard.This is gonna be a comprehensive course. We have just given a glimpse of what you will learn in this course. We are pretty sure you will enjoy this journey of mastering Excel with us.
Exam & Certification Advance Excel + Dashboard
An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.
Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.
![ISPL Academy Certificate Sample](images/certificate03.jpg)
Excel & Analytics Alumni
Frequently Asked Questions
What is the duration of course Advance Excel + Dashboard?
Advance Excel + Dashboard is a short term course of 2 months.
What is the fee of Advance Excel + Dashboard?
The fee of course Advance Excel + Dashboard is Rs.6600/-
What topics are covered in Advance Excel + Dashboard?
This course covers Essential Excel, Advance Excel, Dashboard in Excel
What is the mode of Training?
The course is available in both online & classroom modes at the training center in Dehradun.