Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | VTT | Size: 5.31 GB | Duration: 10h 17m
What you'll learn
How to add interactivity to your Excel reports
Roll over effect
Create over 10 Amazing Interactive Non-Standard Charts in Microsoft Excel
Build Interactive Dashboard Reports with Buttons and Drop Down Menus
Requirements
This course was recorded with Excel 2013, but it's compatible also with Excel 2007, 2010 and 2019.
Only basic prior experience in Excel or spreadsheets is required to get the most out of this Excel course
Description
In this Excel Dashboard Training Course you learn how to create amazing dashboards. It covers all the dashboard basics and advanced concepts. It also has detailed videos where I will show you how to create a dashboard from scratch (such as a sales pipeline dashboard, or a performance dashboard).
The following topics are covered in this Dashboard Course:
· Introduction to Excel Dashboards - Preview
· Using Camera Tool For Excel Dashboards - Preview
· Excel Tables in Dashboards - Preview
· Using Custom Number Formatting
· Using Symbols in Excel Dashboards
· Conditional Formatting for Dashboards (How to Use + Advanced Examples)
· Using Sparklines in Excel Dashboards---In cell charts (miniature charts)
· Getting the data ready for Excel Dashboards
· Useful Excel Dashboard Formulas
· Excel Interactive Controls (Scrollbar, Spin Button, Checkbox, Combobox)
· Introduction to Excel Charting
· Creating the Right Excel Chart
· Interactive Charts Examples (Dynamic Charts)
· Creating Bullet Chart in Excel
· 10 Advanced Excel Charts for Dashboards
· Roll Over Effect in Excel Charts (Advanced Concept)
· VBA Toolkit for Dashboards (VBA Macro Examples)
· Creating a Human Resource (HR) Training Dashboard
· Call Centre Performance Dashboard in Excel
· Creating a Sales Pipeline Management Dashboard in Excel
· Creating a Pivot table Dashboard with Slicers in Excel (in 15 minutes)
Who this course is for:
Everyone who wants to master Excel Dashboards
Business Professionals
You'd like to learn how to create interactive reports
You'd like to improve the design of your existing Excel reports
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
