Excel for Project Management

Excel for Project Management

1h 42mIntermediate2024-07-29

Authors

Jordan Goldmeier

Jordan Goldmeier

Author, Entrepreneur, and Keynote Speaker

Course details

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.

Skills covered

Project Management SkillsSpreadsheetsMicrosoft ExcelPersonaProject ManagementBusiness Software and ToolsMicrosoft

Concepts

Introduction

  • Effective project management in Excel
  • Why use Excel for project management

Project Tracking in Excel

  • Keep your data organized with Excel tables
  • Track and identify project metadata
  • Conditional formatting to track trends and risks
  • Capturing high-level summaries with pivot tables

Data Visualization for Communicating Project Status

  • High level descriptive statistics
  • Progress charts
  • In-cell bar charts
  • KPIs and performance

Gantt Charts to Visualize a Portfolio of Projects

  • What is a Gantt chart
  • How to create a Gantt chart in Excel
  • Testing different scenarios on a Gantt chart

Calculating Earned Value Management in Excel

  • Applying EVM to understand project progress and success
  • Creating an EVM calculator in Excel

Putting It All Together - Creating a Project Management Dashboard

  • Becoming acquainted with the data
  • Calculating the required data and key metrics to measure
  • Creating the layout for the dashboard
  • Creating the Gantt chart
  • Scenario analysis in Excel

Conclusion

  • Managing your own success for the future
40,000 Toman