MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Excel 2013 - Excel Dashboard

Course Summary

Learn to Create Dynamic, Interactive and User friendly Excel Dashboards with the help of various excel tools

  • +

    Course Syllabus

    • Introduction to Excel Dashbord
      • Introduction to Dashboard
      • Concepts of Excel Dashboard
    • Excel Functions
      • Vlookup
      • Hlookup and Sum product
      • Hlookup and Sum product Continues
      • Choose Function
      • Lookups Without Solution (DOWNLOAD)
      • Lookups With Solution (DOWNLOAD)
    • Creating Basic Charts
      • 3D Charts
      • Area and Bar Chart
      • Combination Charts
      • Different Typs
      • Types of Charts Without Solution (DOWNLOAD)
      • Types of Charts With Solution (DOWNLOAD)
    • Learning Pivot Table, Pivot Chart and Slicer
      • Pivot Table
      • Pivot Chart and Slicer
      • Pivot Charts and Slicer New Without Solution (DOWNLOAD)
      • Pivot Charts and Slicer New With Solution (DOWNLOAD)
    • Using Form Controls
      • Checkbox
      • Check and Scroll 1
      • Scroll Chart
      • Check and Scroll Without Solution (DOWNLOAD)
      • Check and Scroll With Solution (DOWNLOAD)
    • Basic Macros
      • Basic Macro Part 1
      • Macro Example Without Solution (DOWNLOAD)
      • Macro Example With Solution (DOWNLOAD)
    • Assigning Macros to Buttons to Navigate and Dashboard
      • Basic Macro Part 2
      • Macro Navigation
      • Dashboard End
      • Macro chart Example and Navigation Without Solution (DOWNLOAD)
      • Macro Chart Example With solution (DOWNLOAD)
      • Macro Navigation With Solution (DOWNLOAD)

Course Fee:
USD 39

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top