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