Reports and Dashboards
  • Course Overview
  • Section Overview
  • Comparing Reports and Dashboards
  • Section Close
Fundamentals of Microsoft Excel for Project Management
  • Section Overview
  • Set the Excel Table for Project Management
  • Exercise: Format Cell Numbering
  • Create a Clean and Concise Report by Formatting Numbers
  • Single-Line Accounting Underline
  • Section Close
Formatting in Microsoft Excel to show Project Performance
  • Section Overview
  • Sparklines! Add Sparkle to your Reports and Dashboards
  • Adding Sparklines to a Range of Cells
  • Using Conditional Formatting in Microsoft Excel
  • Experimenting with Conditional Formatting in Microsoft Excel
  • Applying Top/Bottom Rules in Microsoft Excel
  • Exercise: Applying Top/Bottom Rules
  • Customize Project Reports by Utilizing Data Bars
  • Exercise: Experimenting with Conditional Formatting Data Bars
  • Exercise: Color Scales and Conditional Formatting in Microsoft Excel
  • Quickly Format Reports by Adding Icon Sets
  • Exercise: Conditional Format and Icon Sets in Microsoft Excel
  • Manipulating Icon Sets
  • Exercise: Customizing the Icon Set
  • Take Control in Microsoft Excel by Manually Applying Conditional Formatting
  • Exercise: Manually Create Conditional Formatting
  • Section Close
Creating Charts in Microsoft Excel for Performance Reporting
  • Section Overview
  • Build Your Reports and Dashboards by Building Charts
  • Working with Excel Charts
  • Exercise: Experiments with Microsoft Excel Charts
  • Working With Chart Series
  • Exercise: Working with Series in Microsoft Excel
  • Format and Customize Charts
  • Exercise: Formatting Charts in Microsoft Excel
  • Section Close
Customizing Charts in Microsoft Excel for Project Management
  • Section Overview
  • Working with Chart Fills and Borders
  • Exercise: Managing Fills and Borders in Microsoft Excel
  • Get Fancy! Format the Chart Background
  • Using Pictures as Charts
  • Exercise: Using Pictures in Charts
  • Charts Need Names - Sometimes
  • Working With Gantt Charts
  • Exercise: Creating a Microsoft Excel Gantt Chart
  • Configure Earned Value Management for Microsoft Excel
  • Building an Earned Value Management Worksheet in Microsoft Excel
  • Section Wrap
Build a Custom Dashboard and Reports in Microsoft Excel
  • Section Overview
  • Secret Weapon: Microsoft Excel’s Camera Feature
  • Vroom! Vroom! Build a Project Speedometer
  • Experimenting with the Microsoft Excel Camera Feature
  • Make it Happen: Building Dashboards and Reports
  • Exploring the Project Charter and Project Scope within Microsoft Excel
  • Creating a Risk Log for Your Project Dashboard
  • Exercise: Creating a Risk Log in Microsoft Excel
  • Section Close
  • Course Wrap-Up