WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login

Excel Dashboard Training

This Online Excel Dashboard Training is a bundle of excel 9+ courses with 45+ hours of video tutorials and Lifetime Access.

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

BESTSELLER
4.7 (726 ratings)

 

1

Microsoft Excel 2016

2

Microsoft Excel Dashboard Training

3

Creating a Sales Dashboard using Microsoft Excel

4

HR Dashboards & Analytics – Beginners

5

HR Dashboard & Analytics – Advanced

+

View All Courses & Projects

Offer ends in: Only seats are left with this price


TAKE THIS BUNDLE
Offer

* One Time Payment & Get Lifetime Access
Home » Excel Dashboard Training

What you get in this Excel Dashboard Training?

Online Classes
Technical Support
Mobile App Access
Case Studies
Download Curriculum

About Excel Dashboard Training

CoursesNo. of Hours
Microsoft Excel 20169h 14m
Project - Microsoft Excel Dashboard Training6h 6m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Project - Sales Productivity Dashboard6h 57m
Project - Advanced Sales Productivity Dashboard7h 17m
Project - Creating Interactive Dashboards using VBA2h 25m
Project - Interactive Dashboards using Microsoft Excel VBA2h 4m

Course Online Excel Dashboard Training Course
Deal This is a 9+ Excel Training course bundle. You will get access to all 9+ Excel courses at once.
Hours 45+ Video Hours
Core Coverage Create interactive excel dashboards such as for Sales Productivity, Human Resource (HR) analytics
Excel Templates Included? Excel templates that were used are provided as a download
Course Validity Lifetime Access. You can view the Excel Dashboard Training any number of times
Eligibility No eligibility as such. You should have keen interest in learning Excel
Pre-Requisites None.
What do you get? Certificate of Excellence for each of the 9 courses
Certification Type Course Completion Certificates
Verifiable Certificates? Yes, these are verifiable certificates. This means that you will be provided with a unique URL/Link which you can include in your resume/LinkedIn profile for online verification.
Type of Training Video Course – Self-Paced Learning
Software Required Excel (Windows)
System Requirement 1 GB RAM or higher
Other Requirement Speaker / Headphone

Excel Dashboard Training Course 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 formatting, IF function in excel, COUNTIF, 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

Excel Dashboard Training Certification of Completion


 Excel-Dashboard-Training-Course

Pre-requisites

  • Willingness to do this course: As we mentioned, this Excel Dashboard Training course isn’t for everybody. If you want to learn how to create dashboards and manage a lot of data, this is the perfect course for you. That’s why it’s imperative that you are willing and committed to doing this course, otherwise, you won’t be able to extract the best value.
  • Basic knowledge of MS Excel: This is not a must, but if you have a fundamental knowledge of MS Excel, it would definitely help in learning this entire course.

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.

Excel Dashboard Course Online – FAQs


Why should I do this Excel Dashboard Training?

If you look at the course curriculum, you would know that there’s no such course in the market. And if you’re interested in creating the dashboards, this is most imperative for your professional life.

I don’t handle data, my job is more or less administrative. Should I do this Excel Dashboard Training course?

The choice is up to you. If you handle administration, this course will help you learn MS Excel and also how to create dashboards. As a result, you would be able to manage your errands well and have KPIs ready for training the juniors/new-comers.

Demo Videos


  • Employee Demographics Filter

    Employee Demographics Filter

    02.47
  • DataBase Creation

    DataBase Creation

    05.22
  • Introduction to Basic of VBA

    Introduction to Basic of VBA

    10.04

Career Benefits

  • You will be way ahead than your peers: This course would help you get ahead of the majority since it will teach you skills that rarely anyone has. As a result, this Excel Dashboard Training course will help you do things rarely anyone can do.
  • You will directly benefit the organization: As a result of this training, you would be able to directly add value to your organization. And you will turn out to be an amazing contributor which will indirectly provide you raise/promotion.

Excel Dashboard Course Reviews/Testimonials


Excel Dashboard Course Review 1

Brune KICHETA

Great Course
The course was very informative, well explained and straightforward and quite easy to replicate. I will definitely be using what I have learned. It really amazes me all that can be done with excel, I am Looking forward to practising what I have learned and learning even more. Only negative, he spends too long on formatting (to my liking).

Linked

 

Excel Dashboard Course Review 2

Nana Osei Tutu Bonsu

How to Build an Excel Dashboard
Tutorial is very practical and easy to understand. The course structure is well prepared and well organised such that it is very comprehensive. I personally found the session on adding Slicer very useful and insightful as I was previously unaware that feature existed on MS excel. Looking forward to more unveiling tutorials such as this.

Linked

 

Excel Dashboard Course Review 3

Din Kwang Tih

Creating Sales Dashboard in Excel
The course includes how to create sales dashboard, charts, pivot table, pivot chart using Microsoft Excel. Key attributes of a dash board and diagram tools of a dashboard including representation of data also discussed. It also demonstrate how to create and use Slicers to enhance the dash boards.

Linked

 

Excel Dashboard Course Review 4

Connie Lee

Informative Excel Dashboard Training
Thank you for this informative class on Excel Dashboard. I really enjoyed your class and learned a lot. I had to stop the video several times to write things down, because key moments went by quickly. I would like further information as I am working on a nationwide campaign fro No Statute of Limitations in each state, and I working on a dashboard for this. I need to set up data, ambassadors from each state, and representatives the petitioners can reach out to. Any recommendations?

Linked

 

Excel Dashboard Course Review 5

John Cortenbach

Creating Sales Dashboard Using MS Excel
Excellent course -learned a number of good techniques working with pivot tables and pivot charts, including formatting options that have been nagging me for years! Also discovered slicers which will prove useful on the many dashboards we’ll retrofit in the coming months. All in all a way to spend my morning. Highly recommended!

Linked

 

Excel Dashboard Course Review 6

Christoffer Alejandro Neil Meng Hui Ng

Dashboard with excel
This course models the data after HR data but the technique is usable across various business functions. The explanations is clear and concise, covering various methods using the basic excel functions, macros and Vba. At the end of the course there is a short presentations on excel shortcuts and micro soft access.

Linked

 

0 Shares
Share
Tweet
Share
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on


Take this Bundle
Book Your One Instructor : One Learner Free Class
CoursesNo. of Hours
Microsoft Excel 20169h 14m
Project - Microsoft Excel Dashboard Training6h 6m
Project - Creating Sales Dashboard using Microsoft Excel1h 35m
Project - HR Dashboard using Excel6h 5m
Project - Advanced HR Dashboard7h 8m
Project - Sales Productivity Dashboard6h 57m
Project - Advanced Sales Productivity Dashboard7h 17m
Project - Creating Interactive Dashboards using VBA2h 25m
Project - Interactive Dashboards using Microsoft Excel VBA2h 4m
TAKE THIS BUNDLE
OFFER FOR YOU

*Offer is valid only for next 20 min

Leaving so soon?

Get Additional 10% OFF on



Take this Bundle
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

Coursera IPO Financial Model & Valuation Free Download