The main course objective of this online training is to deliver the knowledge of advanced options that a user can apply to create a dashboard without using any coding or intense programming.
Creating Sales Dashboard Using MS Excel:
The course is an online course. It being one of the most interesting usage of excel you might be excited to learn to create excel dashboards.
The main course objective of this online is to deliver the knowledge of advanced options that a user can apply to create a dashboard without using any coding or intense programming.
- Dashboard overview
- Explain, train & create the Dashboard report.
- Analyzing the data.
- PIVOT Tables
- Pivot Charts
- Slicers
- Explaining how a Slicer can be used to compare data displayed on multiple charts
- Protection
- How to protect data from editing/manipulating or deleting
Target Customers:
- Commerce students
- Students from the business administration
- Working professionals who go through the hectic working schedule of same repetitive work every day
Pre-Requisites:
- Basic knowledge of using spreadsheets/Excel
- The course is fit for anyone who has the urge to learn applications of excel
- No specific background and work experience require
For any query give a miss call:
08587999769
Section 1 Introduction
1 Introduction to Excel DashBord
Section 2 Excel DashBord
2 Common Things and Dashboard Overview
3 Format Data and Excel Version
Section 3 Pivot Table
4 Introduction of Pivot Table
5 Pivot Table
6 Pivot Table Continues
Section 4 Pivot Chart
7 Pivot Chart
8 Pivot Chart Continues
9 Format Data Labels
10 Adding Data Labels
Section 5 Slicer
11 Insert Slicer
12 Insert Slicer Continues
13 Format Slicer
Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.
Mail us at: [email protected] with below details to receive your certificate:
- Name
- Course Name
- Date of Completion
- Address
