4.9 Upto 2 Month
English / हिंदी में सीखें

Advance Excel + Dashboard

By participating in this Microsoft Excel Data Analysis and Dashboard course you'll gain the widely sought-after skills necessary to effectively analyze large sets of data.

Rs.8500 67% off Rs.25500

Free Excel & Analytics Demo Class Complimentary class with Certificate

Duration

Advance Excel + Dashboard is upto 2 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

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

  • 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

  • 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 67% Scholarship

  • Friday 01-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekdays

  • Monday 04-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekdays

  • Tuesday 05-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekdays

  • Wednesday 06-Nov-2024

    Upto 2 Month

    Classroom / Online

    Weekdays

About Advance Excel + Dashboard Course in

In this course, you will learn Microsoft Excel from beginners’ level to advanced level with dashboards. We  have designed this course very carefully to teach you all the important aspects of MS Excel in a step by step and an easy to understand approach.
Upon completion of this course, your Excel skill will surely shoot up to a whole different level. And You can implement this valuable skill to develop your business or in pursuing your career.

We will start from the very beginning, Firstly we  will learn the fundamentals of MS Excel. that is, how to open excel, about excel’s startup screen, excel’s interface, Then we will take a deep dive about formatting in Excel, the basic functions and formulas, like, SUM, AVERAGE, MIN, MAX, and many more. We will also cover in detail about all types of cell references with comprehensive examples. When learning about logical functions, we will see how to nest functions. Moving on we will learn some of the advanced functions in excel such as advanced conditional formatting, some advanced techniques in data validation, VLOOKUP, HLOOKUP and many more.

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

Excel & Analytics Alumni

Frequently Asked Questions

Advance Excel + Dashboard is a short term course of 2 months.

The fee of course Advance Excel + Dashboard is Rs.6600/-

This course covers Essential Excel, Advance Excel, Dashboard in Excel

The course is available in both online & classroom modes at the training center in Dehradun.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner