Excel for Project Management

with Ivan Vaptsarov
4.8/5
(55)

Master Excel for project management: Work with important documents such as trackers, logs, risk logs, project schedules, Gantt charts, and budgets

1 hour of content 282 students

Please note that this course is available only to subscribers who have reached level 9

What you get:

  • 1 hour of content
  • 10 Downloadable resources
  • Interactive exercises
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Excel for Project Management

A course by Ivan Vaptsarov

Please note that this course is available only to subscribers who have reached level 9

What you get:

  • 1 hour of content
  • 10 Downloadable resources
  • Interactive exercises
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Please note that this course is available only to subscribers who have reached level 9

What you get:

  • 1 hour of content
  • 10 Downloadable resources
  • Interactive exercises
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Improve your project management skills to lead and deliver complex professional projects
  • Create essential project management documents in Excel
  • Apply project management theory in practice
  • Improve your Excel skills by working on real-life practical examples
  • Download professional project management templates ready for immediate application in your current and future job roles
  • Develop key business skills including budgeting, project delivery, and cost management

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

The course teaches you how to create and maintain some of the key project artifacts. The most convenient way to keep a good grip on important events is with the help of tables. So, it is only logical to use the most popular program for organizing and manipulating data for that purpose – Microsoft Excel. In this course, we cover the key aspects of using Excel for project management. You will learn how to create the five most important project management documents — work trackers, logs (from project diary to RAIDD), risk logs, project schedules and Gantt charts, and budgets.

Curriculum

  • 1. Tracker
    4 Lessons 24 Min

    A project manager must have a good idea of the progress of every activity and whether it is on track with the initial planning. This is where the tracker document comes in. In this section, we explain what that is and how to use it.

    Intro
    4 min
    Tracker - high-level overview
    8 min
    Tracker - standard tasks
    7 min
    Tracker - steps status
    5 min
  • 2. Actions log
    6 Lessons 24 Min

    Another useful Excel tool for project management is the log document. This is where important events are recorded (logged). Once logged, people can obtain information about them– their purpose, who is involved, any next steps, the due date, etc.

    Actions log
    5 min
    Actions, Issues, Dependencies Log
    4 min
    RAIDD log
    4 min
    RAIDD log structures
    5 min
    Risks log
    3 min
    Logs outro
    3 min
  • 3. Project schedule
    3 Lessons 12 Min

    Next, we will examine how to create and use project schedules and Gantt charts in Excel. Both are essential for project managers.

    Project schedule
    5 min
    Gantt chart (months)
    3 min
    Gantt chart (weeks)
    4 min
  • 4. Budget
    4 Lessons 17 Min

    The final group of Microsoft Excel documents we will create together is related to budget and cost management. Here, the ultimate goal of the project manager is to have a realistic budget and a process to track the actual spending against this budget.

    Budget simple table
    3 min
    Budget time and materials 1
    4 min
    Budget time and materials 2
    4 min
    Formatting tips & tricks
    6 min
  • 5. Conclusions
    1 Lesson 2 Min

    The Excel templates created in this course are essential to all projects. They are the bridge between project management theory and the real-life activities the manager performs. The course on Excel for project management ends with an outline of the limitations of the program and some alternative solutions.

    Conclusions
    2 min

Topics

TheoryBusiness fundamentalsProject ManagementExcel

Tools & Technologies

excel

Course Requirements

  • You need to complete the Project Management course before taking this training
  • You need basic Excel skills to take the course

Who Should Take This Course?

Level of difficulty: Beginner

  • Individuals who want to improve their project management skills

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Ivan Vaptsarov

Ivan Vaptsarov

Project Manager at AIG

3 Courses

411 Reviews

3139 Students

Ivan is a PMP-certified project manager who holds a Bachelor’s degree in Business Administration and Management and a Master’s in Accounting and Financial Management from Bocconi University in Milan, Italy. He started his career as a consultant with Tefen Management Consulting. At Tefen, Ivan worked on multiple supply chain optimization and process excellence projects in the Oil & Gas and Pharma industries. In 2013, he joined AIG’s EMEA Project Management and Strategy team. As part of that unit, Ivan executed the company’s strategy in EMEA by establishing two shared service organizations covering a total of 700+ positions and 17+ countries. What is more, Ivan is a passionate project management educator. He has delivered live business trainings to multiple corporate clients and individuals and has been a guest lecturer in several universities. He has also delivered consulting services in project management.

What Our Learners Say

24.09.2024
Wonderful course for the Project Management Professionals. I highly recommend this course for the budding Project Leads and as a refresher for the experienced Project Managers.
16.09.2024

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.