MS Excel Sales Dashboard

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.

12

 1h 3m | 13 Videos | 69382 Views |   All Levels| English[Auto-generated]

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 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.

• • 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 education background and work experience required

Back to top ▴