Microsoft Excel for Project Management Certification Video Training Course
The complete solution to prepare for for your exam with Microsoft Excel for Project Management certification video training course. The Microsoft Excel for Project Management certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Project Management Courses Microsoft Excel for Project Management exam dumps, study guide & practice test questions and answers.
Microsoft Excel for Project Management Certification Video Training Course Exam Curriculum
Reports and Dashboards
Fundamentals of Microsoft Excel for Project Management
Formatting in Microsoft Excel to show Project Performance
Creating Charts in Microsoft Excel for Performance Report and Controlling
Customizing Charts in Microsoft Excel for Project Management
Build a Custom Dashboard and Reports in Microsoft Excel
Reports and Dashboards
-
02:54
1. Course Overview
-
02:27
2. Section Overview
-
15:29
3. Comparing Reports and Dashboards
-
01:23
4. Section Close
Fundamentals of Microsoft Excel for Project Management
-
03:37
1. Section Overview
-
02:46
2. Set the Excel Table for Project Management
-
05:42
3. Exercise: Format Cell Numbering
-
04:16
4. Create a Clean and Concise Report by Formatting Numbers
-
03:06
5. Single-Line Accounting Underline
-
02:03
6. Section Close
Formatting in Microsoft Excel to show Project Performance
-
02:18
1. Section Overview
-
02:12
2. Sparklines! Add Sparkle to your Reports and Dashboards
-
09:42
3. Adding Sparklines to a Range of Cells
-
02:13
4. Using Conditional Formatting in Microsoft Excel
-
10:18
5. Experimenting with Conditional Formatting in Microsoft Excel
-
02:08
6. Applying Top/Bottom Rules in Microsoft Excel
-
03:49
7. Exercise: Applying Top/Bottom Rules
-
02:25
8. Customize Project Reports by Utilizing Data Bars
-
06:42
9. Exercise: Experimenting with Conditional Formatting Data Bars
-
06:27
10. Exercise: Color Scales and Conditional Formatting in Microsoft Excel
-
02:36
11. Quickly Format Reports by Adding Icon Sets
-
05:37
12. Exercise: Conditional Format and Icon Sets in Microsoft Excel
-
02:26
13. Manipulating Icon Sets
-
05:03
14. Exercise: Customizing the Icon Set
-
02:21
15. Take Control in Microsoft Excel by Manually Applying Conditional Formatting
-
13:10
16. Exercise: Manually Create Conditional Formatting
-
01:24
17. Section Close
Creating Charts in Microsoft Excel for Performance Report and Controlling
-
02:45
1. Section Overview
-
03:27
2. Build Your Reports and Dashboards by Building Charts
-
09:40
3. Working with Excel Charts
-
05:43
4. Exercise: Experiments with Microsoft Excel Charts
-
04:00
5. Working With Chart Series
-
05:51
6. Exercise: Working with Series in Microsoft Excel
-
02:13
7. Format and Customize Charts
-
11:16
8. Exercise: Formatting Charts in Microsoft Excel
-
00:46
9. Section Close
Customizing Charts in Microsoft Excel for Project Management
-
02:24
1. Section Overview
-
02:46
2. Working with Chart Fills and Borders
-
05:07
3. Exercise: Managing Fills and Borders in Microsoft Excel
-
02:33
4. Get Fancy! Format the Chart Background
-
02:39
5. Using Pictures as Charts
-
04:43
6. Exercise: Using Pictures in Charts
-
03:53
7. Charts Need Names - Sometimes
-
04:55
8. Working With Gantt Charts
-
12:04
9. Exercise: Creating a Microsoft Excel Gantt Chart
-
09:51
10. Configure Earned Value Management for Microsoft Excel
-
10:11
11. Building an Earned Value Management Worksheet in Microsoft Excel
-
01:45
12. Section Wrap
Build a Custom Dashboard and Reports in Microsoft Excel
-
02:03
1. Section Overview
-
03:01
2. Secret Weapon: Microsoft Excel’s Camera Feature
-
11:47
3. Vroom! Vroom! Build a Project Speedometer
-
04:01
4. Experimenting with the Microsoft Excel Camera Feature
-
03:20
5. Make it Happen: Building Dashboards and Reports
-
05:17
6. Exploring the Project Charter and Project Scope within Microsoft Excel
-
03:31
7. Creating a Risk Log for Your Project Dashboard
-
04:11
8. Exercise: Creating a Risk Log in Microsoft Excel
-
01:29
9. Section Close
-
02:45
10. Course Wrap-Up
About Microsoft Excel for Project Management Certification Video Training Course
Microsoft Excel for Project Management certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Do you think that Excel functions are limited to mathematical, text, and statistical tasks? That’s not true. Microsoft Excel can be useful in defining the project charter, communication, and developing the project scope. Would you like to learn how Excel can be effectively used in project management? This video course is designed for this purpose.
There are 6 parts containing 58 lectures in total. You can go straight to the point and start with reports and dashboards. Then, you will learn Excel fundamentals for project management. 17 subtopics are related to the theme about formatting in Excel to show project performance. You will learn how to use conditional formatting, add sparklines to a range of cells, and manipulate Icon Sets. After that part, you will learn how to create charts for performance report and controlling. The lectures of this section include working with charts in Excel, operating with chart series, formatting and customizing charts, and etc. The training teaches thoroughly how to customize charts for project management. Hence, you will know how to work with chart fills and borders, use pictures as charts, create a Gantt Chart in Microsoft Excel, and so on. The training also covers custom dashboard and reports building.
The sections involve not only theory but also exercises related to each topic. The course will be useful for project managers and team members who are responsible for reporting. It is recommended that you already have enough knowledge for working in Excel. The training is full of tips and tricks. It is detailed but easy to understand and interactive.
Prepaway's Microsoft Excel for Project Management video training course for passing certification exams is the only solution which you need.
Pass Project Management Courses Microsoft Excel for Project Management Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
