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
What are the prerequisites for this course?
- Basic knowledge of excel tools and functions
- Passion to learn and apply
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
Creation
2 Lectures
Formula and Formatting
2 Lectures
Types of Filters
7 Lectures
Graph and Formatting
18 Lectures
Demographics
8 Lectures
Compensation Button
8 Lectures
Import Access and Export Access
7 Lectures
Conclusion
1 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now