Course curriculum

  • 1

    Reports and Dashboards

  • 2

    Fundamentals of Microsoft Excel for Project Management

    • Section Open

    • All Course Files - Windows Zip

    • Set the Table

    • Format Numbering

    • Create a Report

      FREE PREVIEW
    • Single Line Accounting Underline

    • Section Close

  • 3

    Formatting in Microsoft Excel to show Project Performance

    • Section Open

    • Sparklines

      FREE PREVIEW
    • More sparklines

    • Conditional formatting

    • Conditional Formatting Experiments

    • Top-Bottom Rules

    • Assignment: Top Bottom Rules

    • Customize Reports

    • Assignment: Conditional Formatting

    • Using Icon Sets

    • Format With Icons

      FREE PREVIEW
    • Customize Your Icons

    • Manually Create Formats

    • Using Color Scales

    • Take Control of Your Reports

    • Format Reports Fast

    • Section Close

  • 4

    Creating Charts in Microsoft Excel for Performance Reporting

    • Section Open

    • Build Reports

    • Excel Charts

    • Assignment: Experiment with Charts

    • Utilize Chart Series

    • Work With Series

    • Format and Customize Charts

    • Assignment: Format Charts

    • Section Close

  • 5

    Customizing Charts in Microsoft Excel for Project Management

    • Section Open

    • Chart Fills and Borders

    • Assignment: Managing Fills and Borders

    • Fancy Backgrounds

    • Picture Charts

      FREE PREVIEW
    • Assignment: Picture Charts

    • Name Charts

    • Gantt Charts

    • Assignment: Create a Gantt Chart

    • Earned Value Management

    • Assignment: Try EVM

    • Section Close

  • 6

    Build a Custom Dashboard and Reports in Microsoft Excel

    • Section Open

    • Secret! Excel Camera

    • Assignment: Camera Feature

    • Speedometer Chart

    • Build a Dashboard

    • Project Charter and Excel

    • Create a Risk Log

    • Assignment Risk Log

    • Section Close

    • Course wrap