Excel Advanced Dashboard Development
Microsoft Excel offers lots of dashboard creation tools and techniques, making it easier than ever to gather data and use the data to create Powerful Reports, Scorecards, and Dashboards.
You probably know that to create awesome Excel Dashboard reports requires a thorough knowledge of many Microsoft Excel techniques, but also principles of good Visual Design, and learning this practical knowledge takes a significant investment of time.
If you have been looking for a course to teach you how to create your very own awesome dashboards in Excel, then this is the perfect course for you. This course will teach you how to create amazing interactive Dashboards in Microsoft Excel. They’ll wow your boss and take your career to the next level.
I invite you to my Excel Advanced Dashboard Development Training where you are going to learn to develop impressive Excel Dashboards.
This is a comprehensive training that covers Dashboard Design Principles, Basic and Advance Charting techniques, Interactive Excel Form Controls, Score Cards, Data Analysis and Publishing and much more.
INITIAL WARMUP
🟢 Introduction to Excel Dashboard
🟢 Dashboard Capabilities in Excel
🟢 Dashboard Primer - An Introductory Guide
BEFORE YOU START
🟢 Understanding Dashboard Terminology
🟢 Blueprint of your Excel Dashboard Project
🟢 Important Keyboard Shortcuts
🟢 Quick Time-Saving Tips for Dashboard Development
🟢 Proper Dashboard Framework & Flow
🟢 Excel Dashboard Project Questionnaire
UNDERSTANDING DASHBOARD SOURCE DATA
🟢 Understanding Your Source Data
🟢 Connecting Excel Workbook
🟢 Connecting Microsoft Access
🟢 Connecting Text / Data / CSV File
🟢 Connecting SQL Server
🟢 Integrating Multiple Sources
🟢 Maintaining Dynamic Source Data using Excel Table
DASHBOARD DESIGN TOOLBOX
🟢 Excel Shapes
🟢 Excel Text Box
🟢 Custom Color Themes
🟢 Icons & PNG Images
🟢 Cut-Out People (New)
🟢 Custom Fonts
🟢 Add-Ins - Colorizer
🟢 Excel Camera Tool
🟢 CF Data Bars, Icon Sets
🟢 HYPERLINKS - Basic & Advanced
🟢 Concrete Design tools for Better Excel Dashboard
EXCEL DASHBOARD FORMULA TOOLBOX
🟢 VLOOKUP for Basic Lookups
🟢 INDEX & MATCH for Complex Lookups
🟢 OFFSET for Dynamic Range
🟢 LARGE & SMALL for Top / Bottom
🟢 SUMIFS, COUNTIFS for conditional calculation
🟢 CHOOSE for Flexibility
🟢 INDIRECT for Dynamic Range
🟢 ROW & COLUMN for Indexing
🟢 VLOOKUP with CHOOSE for Complex Lookups
🟢 IFERROR to Handle Errors
🟢 ISNA to return NULL
🟢 DYNAMIC ARRAYS (New)
🟢 Name Manager for Flexible Ranges
FILTER BASED REPORT DESIGN
🟢 Introduction to Custom Views
🟢 Creating Custom Views
🟢 TASK: Report Design using Custom Views - Macro
WORKING ON BASIC CHARTING TECHNIQUES
🟢 Chart Overview
🟢 Elements of Chart
🟢 Excel Chart Basics
🟢 When to Use Which Chart
🟢 Mixing Multiple Charts
🟢 Working on Chart Effects
🟢 Using Dynamic Data for Excel Charts
CREATING INLINE CHARTS
🟢 Creating Inline Column Chart
🟢 Creating Inline Line Chart
🟢 Creating Inline Win-Loss Chart
🟢 Create Inline Bar Chart
🟢 Create Inline Pie Charts
FORM CONTROLS FOR INTERACTIVE EXCEL DASHBOARDS
🟢 Introduction to Form Controls
🟢 ActiveX vs Form Controls
🟢 Combo Box for creating dropdown list
🟢 Check Box for implementing Check / Uncheck
🟢 Spin Button for moving Up & Down
🟢 Option Button to Choose One Option Only
🟢 Scroll Bar to create a scrolling control
🟢 TASK: Controlling Conditional Formatting
🟢 TASK: Create Scrollable Table
🟢 TASK: Mix controls to Create Dynamic Dashboard
🟢 TASK: Dependent Dropdown to Create Dynamic Report
DASHBOARD USING PIVOT TABLES
🟢 Working with Pivot Tables
🟢 Pivot Charts in Excel Dashboards
🟢 Working with Slicer & Timeline
🟢 Dynamic Excel Comments with Slicer Selection
🟢 TASK: Top & Bottom Performers Dashboard
🟢 Creating Custom Slicer Themes
🟢 Conditional Formatting in Pivot Tables
🟢 Automatically Refresh Pivot Table - Macro
🟢 GETPIVOTDATA for fetching Data from Pivot Tables
🟢 Development of Dynamic Dashboard using Pivot Table
CUSTOMIZE CHARTS USING SMART TECHNIQUES
🟢 Creating Dial Chart
🟢 Creating Speedometer Chart
🟢 Creating Thermometer Chart
🟢 Creating Battery Chart
🟢 Creating Traffic Chart
🟢 Creating Star Rating Chart
🟢 Creating Project Timeline Chart
CONNECTING THE DOTS
🟢 Creating Scrollable Column Chart
🟢 Automate Trendline in Charts
🟢 Creating Smart Image Lookup
🟢 Creating Dynamic Charts using Slicers
🟢 Creating Clickable Table Report - Macro
GEARING UP THE INSPIRATION
🟢 Creating Dynamic Score Cards on Selection - Macro
🟢 Using Conditional Formatting in Charts
🟢 Creating Dynamic MAX-MIN Charts
🟢 Creating Interactive Dashboards using Hyperlink
🟢 Creating Interactive Dashboard using Range Selection - Macro
PROJECT - CREATING SALES / EMPLOYEE DASHBOARD
✅ Choose the Dashboard
✅ Identifying KPIs
✅ Blueprint of your Excel Dashboard Project
✅ Spreadsheet Setup
✅ Setup of Raw Data Sheet
✅ Setup of Excel Calculation Sheet
✅ Create Grid Based Home Page
✅ Create Smart Navigation
✅ Identify Charts
✅ Integrate Scrolling Table
✅ Clickable Score Cards
✅ Setup a Combo Box to Easy Selection
✅ Integrate Conditional Text in Table / Charts
✅ Show Top 3 & Bottom 3 Performers
✅ Use Option Button to Toggle
✅ Use Check Box to Control Series Visibility
✅ Use Image Lookup
✅ Use Speedometer Chart
✅ Use Traffic Chart
✅ Use Conditional Formatting Icons
By the time you are done, you'll have great confidence on developing advanced & impressive dashboards.
I have designed this course based on my 15+ Years of experience in Excel Dashboard Development. This is highly beneficial from freshers to experienced professionals.
As it is a certification course, therefore participants will get the Course Completion Certificate (Soft Copy) after the training.
My brief profile:
An MCA Professional and a Microsoft Certified Microsoft Office Specialist working as a Chief Mentor and currently heading Future in Hands. I worked with the Top corporates like Mphasis, Motherson Group with 15+ years of industry exposure. I have received several Best Trainer Awards from corporates for Microsoft Office based workshops. I facilitated 98000+ professionals from 500+ companies like Taj Group, ICAI, British Council, BSI, NIIT, IndiaMart, MetLife, Mahindra and lots more from Executive level to Sr. Management. Learners says my sessions are like magic shows.
You can also refer to my LinkedIn profile.
So, if you are serious about being a master in Excel Dashboards, then you should not miss this Masterclass training. Eventually, your BOSS will become your FAN.
In case of any queries, please contact Me @ +918744007662.
See you at the training!