McAfee-Secured Website

Course name Project Management Courses Microsoft Excel for Project Management: Microsoft Excel for Project Management

Microsoft Excel for Project Management Video Course

Microsoft Excel for Project Management Video Course is developed by Project Management Courses Professionals to help you pass the Microsoft Excel for Project Management exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass Microsoft Excel for Project Management exam.

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