Excel Dashboard Training

Excel Dashboard Training

Course Details

  • Modules :                                                                                                     6
  • Projects :                                                                                                   10
  • Eligibility :                                                                                       HSC/SSC
  • Learning Mode :                                                           Online / Classroom
Enroll Now


ONLINE COURSE


CLASSROOM COURSE

INTRODUCTION

Doing this course will help you become the master of creating and managing data that are very useful for any organization. You would learn how to create interactive dashboards such as for Sales Productivity, Human Resource (HR) analytics.

CURRICULUM

This course isn’t for everybody. You may not find value in this Excel Dashboard Training if you’re not the target audience. We made this course for professionals and students who would need to manage data on a daily basis to make their life easier.

Hop on and see what’s in store for you in this Excel Dashboard Training course –

Sr. No. Course Name Total Duration Course Description
1 Microsoft Excel 2016 9 This is the first module of this Excel Dashboard Training. We will start with a brief overview. Then, we will teach you how you should get started. Then, we will take a case study and show you how MS Excel works. We will talk about data entry, how you can populate the case study in MS Excel, how to do calculations, how to use formulas, and how to use formatting. You will also learn how to format table formats, how to update a calculation, how to use percentages & absolute references, conditional formattingIF function in excelCOUNTIF, SUMIF function, graphs & charts, Pie Chart, etc. Then, we will also teach you how you can use sorts, filter function, pivot table, freeze & split, how to present, how to print, how to use shortcuts, and the common errors. We will finally close this module with useful excel functions, data functions, what-if-analysis, arrays, advanced charts, etc. This is overall a very comprehensive module on MS Excel 2016. You need to watch 84 videos to cover the whole module.
2 Microsoft Excel Dashboard Training 6 This is the second module of this Excel Dashboard Training course. You will learn about the creation of excel dashboard, how to use formulas and formatting. You will also understand the types of filters, graph & formatting in excel, demographics, how to create the compensation button, and import access & export access. You need to watch 55 videos in total to cover the module.
3 Creating a Sales Dashboard using Microsoft Excel  1 As we always do, at the beginning we will give you a brief overview of the excel dashboard. Then, we will go in detail about what an excel dashboard is, how to create a pivot table, pivot chart in excel, and slicer in excel. This entire module will need you to watch 13 videos in total.
4 HR Dashboards & Analytics – Beginners 5 In this module, you will learn the basics of HR Analytics. First, we will start with a reference file that will offer you a brief about the creation of HR dashboard & analytics. Then, gradually, you will learn about data introduction, index & tab designing, employee front face, the pivot data list, MOM headcount, departmental & location analysis, tenure wise analysis, age-wise analysis, employee demo & quality circles, timesheet late marks analysis, full & final analysis, training analysis, job rating analysis, HR update, and lastly a summary of all that you learn. You need to watch 42 videos in total to cover this module.
5 HR Dashboard & Analytics – Advanced 8 In this module, we will also start with a brief overview of the advanced HR dashboard & analytics. Then, we will talk about data introduction, data index, page layout, HC analysis, data & animated macro chart, predictive attrition, Vlookup analysis, BGV analysis, leave analysis & grouping data, Bradford factor, FNF analysis & exit analysis, learning & development analysis, goal seek & payroll analysis, employee profile, HR update & HR update calendar, and finally the conclusion. You need to watch 62 videos in total to cover the entire module.
6 Sales Productivity Dashboards – Beginners Training 6 In this module, you will start with a brief overview of sales productivity dashboard. Then, we will talk about database creation, formatting, index, business analysis, zone state, consolidation, tenure, age group, CAGR, moving average, standard deviation, exit analysis, growth ratios & scenarios, etc. You will also learn about advanced filter & hyperlinks. This entire module will need you to watch 49 videos.
7 Sales Productivity Dashboards – Advanced Training 7 This module is the advanced version of the previous module. You will learn about data formulas, formatting, macro, sigma analysis, budget, pivot table & chart, consolidation & trend analysis, Monte-Carlo simulation, null matrix, active vis-a-vis, inactive analysis, histogram & regression analysis, rank & percentile & descriptive statistics, index & headers, etc. This entire module will need you to watch 59 videos in total.
8 Creative Interactive Dashboards using VBA 2 In this module, you will learn about raw data, how to use them, how to add buttons, how to hyperlink buttons and savings workbook. You will also learn what are sales by product, what are sales by region, and what is a scroll bar. This entire module will need you to watch 22 videos in total.
9 Interactive Dashboards using Microsoft Excel VBA 2 This is the last module of this Excel Dashboard Training. In this module, we will first give you an overview of the interactive dashboard of VBA Books. Then, we will go in detail on quality check dashboard and login compliance dashboard. This entire module will need you to watch 12 videos in total.
  Total Duration 45+ Hours

TARGET AUDIENCE

  • Students: If you have just completed graduation or under-graduation, this Excel Dashboard Training is perfect for you. This will prepare you for future employment and help you stay ahead of the competition.
  • Professionals: If you’re a professional that handles data most of the time, this course is right for you. You can be in HR or in marketing or in finance. You would be able to benefit from this Excel Dashboard Training course.

Alert: You are not allowed to copy content or view source !!