Build Automated Sales Dashboard with Excel

Training Outline:

The dashboard is used as the most powerful decision-making tool globally. Visualize, Track, Analyze and make the Perfect Decision for your business. The main purpose of a KPI or Business dashboard is to provide a comprehensive snapshot of performance, that enables you to visualize by a large amount of detail without using too many drill-downs. A Sales Dashboard would help the company to not only expedite the Sales Performance but also to understand the market and bring in innovation to create a new market & enhance the market capability of the existing market.

Learning Outcome / Training Outline:

1. Understanding Dashboard Architecture
2. Understand the Sales Analytics & KPIs used Globally
3. Learn about Excel Power BI Tool
4. Use Excel Power BI for Shaping & Normalizing Data Source
5. Data Viz with Pivot, Charts, Number Format & Conditional Format
6. Build Animation in Slicers to Animate Dashboard
7. Use Macro to Animate the Dashboard Visualization
8. Prepare Animated Dashboard on Real Life Case
9. Bonus Tips for Dashboard

Target Audience:

1. Senior Sales Leaders
2. Sales Managers maintaining a team
3. Specialists working with Data and Analytics

Training Deliverables:

1. Exercise Files for practice
2. Full Video recording of the training
3. Certificate of Participation

Pre-requisites to Participate:

1. 1. Should have intermediate knowledge about Excel.
   2. Use Microsoft Office 2016 or higher. Office 365 is the best

Note:

• After completing every lesson click on the “COMPLETE” button the go to the next lesson.
• Must set up your first name, last name, and display name from settings of your profile for your certificate.
• don’t click on the “FINISH COURSE” button.
• If you click on the “FINISH COURSE” button then the course will be finished and a Certificate will be generated.
• More details: https://thrivingskill.com/faqs/

Instructor:

Md. Mehanazuddin Rupom

Course and Training of this Instructor:

• Business Reporting with PivotTables
• Advance Excel Functions & Tools
• HR Analytics & Dashboard with Excel
• Tips & Tricks of Modern Dashboard
• Bring Data to Life Excel Dashboard
• Use Excel Like a Pro!
• PivotTable Basic to Pro
• Increase Office Productivity with MS Excel Lookup Series
• Power up Excel Report with Power Pivot & Power Query
• HR Analysis & Dashboard with Excel
• Essentials of Excel Business Intelligence Tool
• Automate HR Dashboard & Reporting with Excel
• Advance Excel for Sales & Marketing Professional