MS Excel for Project Managers
How to Develop MS Excel project artifacts to help manage your projects
Description
With about 5 hours of content, this is the most comprehensive course on how to leverage MS Excel to develop project artifacts that can help you manage projects.
Gain step-by-step instruction on how to develop various project management artifacts leveraging MS Excel - from the Action Item Document to leveraging pivot tables to generate project financial analysis.
Information gathered is from specific past job experience - this is not a theory course but a course to teach you specific step-by-step procedures to leverage MS Excel to develop project management artifacts.
Leverage real-world examples to increase your knowledge of MS Excel as we work through actual artifacts that you will leverage during your project management career.
Each section ends with a project to help reinforce the knowledge attained. Step-by-step documentation is attached to help you build your own project artifact leveraging MS Excel.
Bonus Project: Build your own Gantt Chart timeline tracker in MS Excel - You will be taken step-by-step to produce your own Gantt chart where you can track the progress of project tasks visually.
How long will it take?
With over 40 lectures and about 5 hours of content, if you budget just 30 minutes a day, you can complete this course in approximately 3 weeks.
Is it for me?
This course is for you if you want to learn step-by-step how to leverage MS Excel to help you manage your day to day project management tasks. The skills you learn here can be applied to real-world projects.
What if I don't understand a topic?
As you move through the course, I will provide prompts where you can reach out to me on my website with questions or feedback. I will PERSONALLY get back to you to answer any questions you may have.
What you’ll learn
How to create your own Gantt chart project task tracker in MS Excel.
Linking MS Excel data to MS PowerPoint to develop robust status report presentations.
Pivot Tables and Charting of Project financial data.
Mathematical functions such as Sum, Avg, IRR, or NPV and how to use them to analyze which project to undertake.
Cell Referencing across multiple worksheets to help you consolidate data into one sheet.
Data validation and Conditional Formatting to help your users avoid entering invalid data into your sheets.
Lookup functions such as VLOOKUP AND INDEX MATCH to find data nested within data tables.
Techniques to help you enter data quickly into your spreadsheets.
Font & Border alignment, cell merging, number formats, the format painter, and tab colors/themes.
Analytical functions such as SumIf, If, Or, IfError, and CountIf to analyze data that only meets certain conditions.
Who this course is for:
Project Managers who want to leverage MS Excel to develop robust project artifacts
Anyone who wants to develop robust analytical tools in MS Excel to analyze data.
Senior Managers who want to better understand the project metrics.
PMO Analysts who want to understand the financial performance of projects.
The "accidental" project or program manager who wants to understand how to leverage artifacts to do their jobs better.
What You Will Learn!
- How to leverage MS Excel to develop Project Management artifacts.
- Using MS Excel in your everyday Project Management role
Who Should Attend!
- Project Managers looking to leverage MS Excel to help manage their projects.