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 Dashboard Secrets - Create Awesome Excel Dashboard

Course Summary

Learn Dash-Boarding by creating 14 Live Excel Dashboards! Master advance Excel techniques by creating Dashboards


  • +

    Course Syllabus

    • Introduction
      • Brief Introduction on what you will learn
    • Create Scrolling Table
      • Exercise Files --- Download This First
      • Create a Scrolling Table -- Show data in Effective Format to the Viewers
    • Scrolling Chart and Dynamic Labels
      • Exercise Files -- Download This First
      • Create Scrolling Chart and use Dynamic Label -- Show chart in Effective manner
    • Highlight Selected Row or Column
      • Exercise Files -- Download this First
      • Highlight Selected row or column -- Make data easily view able
    • Create Awesome Excel Graphics
      • Exercise Files -- Download This first
      • Create Awesome Excel Graphics -- Make Dashboard Look Perfectly Designed
    • Dynamic Sales Dashboard Efficient use of check boxes
      • Exercise FIles -- Download This First
      • Dynamic Sales Dashboard -- Making things arranged properly
      • Dynamic Sales Dashboard -- Completing your dashboard
    • Comparative Dynamic Sales Dashboard -- Show off your Sales
      • Exercise Files -- Download This First
      • Comparative Dynamic Sales Dashboard and Combo box Tutorial
    • Income Expense Chart -- Express Incomes and Expenses in a Different way
      • Exercise Files -- Download This First
      • Income Expense Chart -- Express The Income and Expenses in the New Way
    • A Simple Dynamic Dashboard
      • Exercise Files -- Download This First
      • Simple Dynamic Dashboard
    • Roll Over Method -- A New Application of Hyperlink Function
      • Exercise Files -- Download This First
      • Roll Over Method Demonstration and a small Dashboard with Roll Over method
    • Spark lines -- In Cell Charts. A New way to show off Dashboard Skills
      • Exercise Files -- Download This First
      • Sparklines Explanation and a Small Dashboard using Sparklines
    • Interactive Dougnut Chart -- A Chart with some Formatting
      • Exercise Files -- Download this First
      • Interactive Doug nut Chart
    • Thermometer Dashboard with Check Boxes
      • Exercise Files -- Download this First
      • Thermometer Dashboard and Check boxes Explanation
    • 100 Block Chart or a Percentage Chart
      • Exercise Files -- Download these First
      • Block Percentage Chart
    • Create awesome Static Excel Dashboard.
      • Exercise Files -- Download these First
      • Create Static Excel Dashboard
    • Give a test to know how much you have learned
      • Final round quiz


Course Fee:
USD 19

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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