Certification training

Microsoft Excel for Project Management

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

58Lectures
4h 34m 31sDuration
Vendor
Microsoft Excel for Project Management course cover Best seller
certification training 58 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

6 sections, 58 lessons, and lecture-level duration details.

01 Course Overview 2m 54s
02 Section Overview 2m 27s
03 Comparing Reports and Dashboards 15m 29s
04 Section Close 1m 23s

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

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

01 Section Overview 2m 45s
02 Build Your Reports and Dashboards by Building Charts 3m 27s
03 Working with Excel Charts 9m 40s
04 Exercise: Experiments with Microsoft Excel Charts 5m 43s
05 Working With Chart Series 4m
06 Exercise: Working with Series in Microsoft Excel 5m 51s
07 Format and Customize Charts 2m 13s
08 Exercise: Formatting Charts in Microsoft Excel 11m 16s
09 Section Close 46s

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

01 Section Overview 2m 3s
02 Secret Weapon: Microsoft Excel’s Camera Feature 3m 1s
03 Vroom! Vroom! Build a Project Speedometer 11m 47s
04 Experimenting with the Microsoft Excel Camera Feature 4m 1s
05 Make it Happen: Building Dashboards and Reports 3m 20s
06 Exploring the Project Charter and Project Scope within Microsoft Excel 5m 17s
07 Creating a Risk Log for Your Project Dashboard 3m 31s
08 Exercise: Creating a Risk Log in Microsoft Excel 4m 11s
09 Section Close 1m 29s
10 Course Wrap-Up 2m 45s
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.