Microsoft Excel for Project Management

3m 37s 1. Section Overview 2m 46s 2. Set the Excel Table for Project Management 5m 42s 3. Exercise: Format Cell Numbering 4m 16s 4. Create a Clean and Concise Report by Formatting Numbers 3m 6s 5. Single-Line Accounting Underline 2m 3s 6. Section Close

2m 18s 1. Section Overview 2m 12s 2. Sparklines! Add Sparkle to your Reports and Dashboards 9m 42s 3. Adding Sparklines to a Range of Cells 2m 13s 4. Using Conditional Formatting in Microsoft Excel 10m 18s 5. Experimenting with Conditional Formatting in Microsoft Excel 2m 8s 6. Applying Top/Bottom Rules in Microsoft Excel 3m 49s 7. Exercise: Applying Top/Bottom Rules 2m 25s 8. Customize Project Reports by Utilizing Data Bars 6m 42s 9. Exercise: Experimenting with Conditional Formatting Data Bars 6m 27s 10. Exercise: Color Scales and Conditional Formatting in Microsoft Excel 2m 36s 11. Quickly Format Reports by Adding Icon Sets 5m 37s 12. Exercise: Conditional Format and Icon Sets in Microsoft Excel 2m 26s 13. Manipulating Icon Sets 5m 3s 14. Exercise: Customizing the Icon Set 2m 21s 15. Take Control in Microsoft Excel by Manually Applying Conditional Formatting 13m 10s 16. Exercise: Manually Create Conditional Formatting 1m 24s 17. Section Close

2m 45s 1. Section Overview 3m 27s 2. Build Your Reports and Dashboards by Building Charts 9m 40s 3. Working with Excel Charts 5m 43s 4. Exercise: Experiments with Microsoft Excel Charts 4m 5. Working With Chart Series 5m 51s 6. Exercise: Working with Series in Microsoft Excel 2m 13s 7. Format and Customize Charts 11m 16s 8. Exercise: Formatting Charts in Microsoft Excel 46s 9. Section Close

2m 24s 1. Section Overview 2m 46s 2. Working with Chart Fills and Borders 5m 7s 3. Exercise: Managing Fills and Borders in Microsoft Excel 2m 33s 4. Get Fancy! Format the Chart Background 2m 39s 5. Using Pictures as Charts 4m 43s 6. Exercise: Using Pictures in Charts 3m 53s 7. Charts Need Names - Sometimes 4m 55s 8. Working With Gantt Charts 12m 4s 9. Exercise: Creating a Microsoft Excel Gantt Chart 9m 51s 10. Configure Earned Value Management for Microsoft Excel 10m 11s 11. Building an Earned Value Management Worksheet in Microsoft Excel 1m 45s 12. Section Wrap

2m 3s 1. Section Overview 3m 1s 2. Secret Weapon: Microsoft Excel’s Camera Feature 11m 47s 3. Vroom! Vroom! Build a Project Speedometer 4m 1s 4. Experimenting with the Microsoft Excel Camera Feature 3m 20s 5. Make it Happen: Building Dashboards and Reports 5m 17s 6. Exploring the Project Charter and Project Scope within Microsoft Excel 3m 31s 7. Creating a Risk Log for Your Project Dashboard 4m 11s 8. Exercise: Creating a Risk Log in Microsoft Excel 1m 29s 9. Section Close 2m 45s 10. Course Wrap-Up