About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Advanced Excel Dashboard Crash Course

Section 1: Introduction
0101 Introduction to Dashboard Course
Preview
0102 Introduction to 1st Dashboard
Preview
Practice Files
Section 2: 1st Dashboard using Pivot
0201 Understanding the Data
0202 Text Function
0203 Dynamic Data Create Table
Naming the dynamic data and using it in the function
Preparing 1st Pivot & updating data
Classic View & Filling blank with zero in Pivot
Create Chart for comparison from the Pivot
Create Trend Line from the Pivot
Creating Pie Chart from Slab Report from Pivot
Preparing Framework for Dashboard
Inserting Slicer using Chart
Customize Slicer Settings
Section 3: 2nd Dashboard using Functions
0301 Brief on 2nd Dashboard
0302 Importing Data from the Internet
0303 Converting Line Item into a Currency Table
0304 Calculation of Currency using INDEX & MATCH
0305 Creating Slabs using Vlookup True Parameter
0306 Creating Qtrs based on Financial or Calendar Selection
0307 Preparing the base by removing duplicates for Dashboard
0308 AverageIF for calculating Country Wise Salary
0309 Substituting ERROR with zero using IFERROR
0310 Introduction to Function INDIRECT Part 1 & 2
0311 Using Function INDIRECT to Retrieve AverageIF from relevant sheet
0312 Using Function CountIF with INDIRECT to calculate No. of Emp
0313 Calculating Contribution Country wise No Of Emp
0314 Using NameRange to simplify calculation
0315 Using NameRange with formula in 2nd Dashboard
0316 Introduction to Offset Function
0317 Offset Function in Excel
0318 Using Offset Function in Dashboard
0319 Use of MINIF in Dashboard
0320 Use of MAXIF in Dashboard
0321 Using Average to get Designation Wise Experience result
0322 Using MAXIF with multiple conditions
0323 Using MINIF with multiple conditions
0324 Dynamic Dropdown List
0325 Longitude and latitude with plotting data on dashboard
0326 Using REPT Function based on the percentage calculation
0327 Activation of Developer Tab and creating Scroll Bar
0328 Inserting Trend chart based on data
0329 Advance INDEX and MATCH with multiple references
0330 Inserting Spark Line
0331 Insert World Map into the chart
0332 Plotting Data on Map Chart
0333 Controlling Map Preview from dropdown
0334 Summarising 2nd Dashboard
Section 4: 3rd Dashboard using Functions $ Macros
0401 Brief on 3rd Dashboards
0402 Implementation of OFFSET for dynamic data
0403 Creating Trend Chart from 2 Pivot Table
0404 Modifying the Chart Settings for better view
0405 Using Macro recording for Trend Chart 01
0406 Using macro to update pivot based on the Job Type
0407 Triggering macro with any change in sheets
0408 Creating Name Range using shortcut
0409 Use of MAXIF and MINIF with single and multiple parameters
0410 Create chart to represent multiple parameters effectively 01
0411 Create chart to represent multiple parameters effectively 02
0412 Preparing data for Spiderweb chart and change the graph setting
0413 Using macro to Hide and Unhide working sheets
0414 Inserting Trend-line and formatting for better view
Conclusion
Conclusion of all 3 dashboard

Section 1: Introduction

Advanced Excel Dashboard Crash Course
By: Yoda Learning
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
We'll cover the following topics in this section:
 
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.