Project - Microsoft Excel Dashboard Training
Project - Microsoft Excel Dashboard Training
Lectures -55
Duration -5.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
These dashboards help to maintain huge chunks of data and also to convert dashboard data into user-friendly visuals. These online tutorials are indeed self-paced and one can easily make way and learn to create dashboards and business intelligence and understand the importance of data trending and create valuable data visualizations.
The training includes the following information:
INTRODUCTION – This section is about the introduction to excel dashboards and the designing of dashboards.
MANAGING DATA – here we are going to learn about database management, types of errors and data consolidation.
CHARTS– This section on charts will help you learn overview of charts, creation, linkage and formatting of charts and preparation of customized charts.
FILTERS – Under filters you will see using filters and working with advanced filters.
PIVOT TABLES – in this section you will learn preparation of Pivot tables, Pivot Layout, Design and Formatting, Advanced Pivots and MIS using Pivots
CUSTOMIZATION – Here you will learn Grouping and Ungrouping, Consolidations, Dashboard Alerts, KPI and KRA Management, Hyperlinks and Tab Designing.
DASHBOARD MACROS – Under Macros you will learn Macro Filters, Presentation view Macros, Data Updating Macros and Linking Microsoft Access.
SUMMARY – Finally you will look at the Dashboard Hints and Tricks, Excel Shortcuts and Final Dashboard Presentation.
Target Customers:
- Commerce students
- Students from the business administration
- Working professionals who go through the hectic working schedule of same repetitive work every day
Prerequisites
- Basic knowledge of excel tools and functions
- Passion to learn and apply
![Project - Microsoft Excel Dashboard Training Project - Microsoft Excel Dashboard Training](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13979/course_13979_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction to Excel Dashboard Training 01:17 01:17
Syllabus
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Creation
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Formula and Formatting
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Types of Filters
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Graph and Formatting
18 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Demographics
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Compensation Button
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Import Access and Export Access
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conclusion
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Corporate Bridge Consultancy Private Limited](https://www.tutorialspoint.com/assets/profiles/555285/profile/200_81015-1692449117.jpg)
Corporate Bridge Consultancy Private Limited
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)