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 Dashboards & Reports For Dummies

Course Summary

Take Excel to the Next Level with this Guide to Advanced Dashboards and Reporting


  • +

    Course Syllabus

    • Dashboard modeling Fundamentals
      • Building Effective Models
      • Using Lookup Formulas in your Dashboard
    • Building Basic Dashboard Components
      • Table Formatting Best Practices
      • Using Sparklines to Visualize Trends
      • Effective Number Formatting for Dashboards
      • Adding Visualizations with Number Formatting
      • Adding Visualizations with Conditional Formatting
      • Customizing Pivot Table Reports
      • Using the Pivot Table Show As Functionality
    • Charting Tips and Tricks
      • Chart Labeling Tricks
      • Create a Directional Trend Chart
      • Using a Pivot Table to Create Frequency Distribution Reports
      • Emphasizing Top Values in a Chart
      • Creating a Thermometer Chart
      • Creating a Bullet Graph
    • Advanced Reporting Techniques
      • Helping Users with Macros
      • Creating Navigation with Macros
      • Using Check Boxes to Create an Interactive Menu
      • Using Option Buttons to Create an Interactive Menu
      • Understanding Pivot Table Slicers
      • Create an Interactive Interface with Pivot Table Slicers
    • Working with the Outside World
      • Importing Access Data into your Dashboard Models
      • Importing SQL Server Data into your Dashboard Models
      • Protecting your Workbooks
      • Sharing Workbooks with OneDrive
    • Ten Jobs For Excel Gurus
      • Ten Jobs For Excel Gurus
    • eBook Excel Dashboards and Reporting For Dummies, 2nd Edition
      • eBook Excel Dashboards and Reporting For Dummies, 2nd edition


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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