Microsoft Excel for Project Management Video Course

Curriculum For This Course

• 1. Reports and Dashboards 4 Videos 00:22:13
  • Course Overview 02:54
  • Section Overview 02:27
  • Comparing Reports and Dashboards 15:29
  • Section Close 01:23
• 2. Fundamentals of Microsoft Excel for Project Management 6 Videos 00:21:29
  • Section Overview 03:37
  • Set the Excel Table for Project Management 02:46
  • Exercise: Format Cell Numbering 05:42
  • Create a Clean and Concise Report by Formatting Numbers 04:16
  • Single-Line Accounting Underline 03:06
  • Section Close 02:03
• 3. Formatting in Microsoft Excel to show Project Performance 17 Videos 01:20:49
  • Section Overview 02:18
  • Sparklines! Add Sparkle to your Reports and Dashboards 02:12
  • Adding Sparklines to a Range of Cells 09:42
  • Using Conditional Formatting in Microsoft Excel 02:13
  • Experimenting with Conditional Formatting in Microsoft Excel 10:18
  • Applying Top/Bottom Rules in Microsoft Excel 02:08
  • Exercise: Applying Top/Bottom Rules 03:49
  • Customize Project Reports by Utilizing Data Bars 02:25
  • Exercise: Experimenting with Conditional Formatting Data Bars 06:42
  • Exercise: Color Scales and Conditional Formatting in Microsoft Excel 06:27
  • Quickly Format Reports by Adding Icon Sets 02:36
  • Exercise: Conditional Format and Icon Sets in Microsoft Excel 05:37
  • Manipulating Icon Sets 02:26
  • Exercise: Customizing the Icon Set 05:03
  • Take Control in Microsoft Excel by Manually Applying Conditional Formatting 02:21
  • Exercise: Manually Create Conditional Formatting 13:10
  • Section Close 01:24
• 4. Creating Charts in Microsoft Excel for Performance Report and Controlling 9 Videos 00:45:40
  • Section Overview 02:45
  • Build Your Reports and Dashboards by Building Charts 03:27
  • Working with Excel Charts 09:40
  • Exercise: Experiments with Microsoft Excel Charts 05:43
  • Working With Chart Series 04:00
  • Exercise: Working with Series in Microsoft Excel 05:51
  • Format and Customize Charts 02:13
  • Exercise: Formatting Charts in Microsoft Excel 11:16
  • Section Close 00:46
• 5. Customizing Charts in Microsoft Excel for Project Management 12 Videos 01:02:49
  • Section Overview 02:24
  • Working with Chart Fills and Borders 02:46
  • Exercise: Managing Fills and Borders in Microsoft Excel 05:07
  • Get Fancy! Format the Chart Background 02:33
  • Using Pictures as Charts 02:39
  • Exercise: Using Pictures in Charts 04:43
  • Charts Need Names - Sometimes 03:53
  • Working With Gantt Charts 04:55
  • Exercise: Creating a Microsoft Excel Gantt Chart 12:04
  • Configure Earned Value Management for Microsoft Excel 09:51
  • Building an Earned Value Management Worksheet in Microsoft Excel 10:11
  • Section Wrap 01:45
• 6. Build a Custom Dashboard and Reports in Microsoft Excel 10 Videos 00:41:22
  • Section Overview 02:03
  • Secret Weapon: Microsoft Excel’s Camera Feature 03:01
  • Vroom! Vroom! Build a Project Speedometer 11:47
  • Experimenting with the Microsoft Excel Camera Feature 04:01
  • Make it Happen: Building Dashboards and Reports 03:20
  • Exploring the Project Charter and Project Scope within Microsoft Excel 05:17
  • Creating a Risk Log for Your Project Dashboard 03:31
  • Exercise: Creating a Risk Log in Microsoft Excel 04:11
  • Section Close 01:29
  • Course Wrap-Up 02:45