Excel for Project Management

Focused View

Jordan Goldmeier

1:41:48

0 View

01 - Introduction

01 - Effective project management in Excel.mp4

00:43

02 - Why use Excel for project management.mp4

02:21

02 - 1. Project Tracking in Excel

01 - Keep your data organized with Excel tables.mp4

03:00

02 - Track and identify project metadata.mp4

03:47

03 - Conditional formatting to track trends and risks.mp4

06:06

04 - Capturing high-level summaries with pivot tables.mp4

02:45

03 - 2. Data Visualization for Communicating Project Status

01 - High level descriptive statistics.mp4

03:25

02 - Progress charts.mp4

06:25

03 - In-cell bar charts.mp4

04:04

04 - KPIs and performance.mp4

10:46

04 - 3. Gantt Charts to Visualize a Portfolio of Projects

01 - What is a Gantt chart.mp4

01:12

02 - How to create a Gantt chart in Excel.mp4

12:17

03 - Testing different scenarios on a Gantt chart.mp4

08:00

05 - 4. Calculating Earned Value Management in Excel

01 - Applying EVM to understand project progress and success.mp4

02:25

02 - Creating an EVM calculator in Excel.mp4

04:35

06 - 5. Putting It All Together Creating a Project Management Dashboard

01 - Becoming acquainted with the data.mp4

02:05

02 - Calculating the required data and key metrics to measure.mp4

01:27

03 - Creating the layout for the dashboard.mp4

06:22

04 - Creating the Gantt chart.mp4

08:34

05 - Scenario analysis in Excel.mp4

09:34

07 - Conclusion

01 - Managing your own success for the future.mp4

01:55

Description

Excel is a powerful tool for managing projects, but it’s easy to be scared off by its hundreds of different formulas and functions. Many project managers barely scratch the surface of what Excel can really do. In this course, author and entrepreneur Jordan Goldmeier shows you how to track your projects in Excel easily and effectively. Learn the best way to set up your spreadsheet to visualize project progress, success, and even failures. Find out how to measure what's most important for projects and how to use that data to inform future decision making. By the end of the course, you'll know the best Excel features, tools, and functions to manage your projects.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Project Management

Jordan Goldmeier

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.