S'inscrire maintenant

S'identifier

Mot de passe perdu

Mot de passe perdu? S'il vous plaît entrer votre adresse e-mail. Vous recevrez un lien et créez un nouveau mot de passe par e-mail.

Ajouter un enregistrement

Vous devez vous connecter pour ajouter après .

Ajouter une question

Vous devez vous connecter pour poser une question.

S'identifier

S'inscrire maintenant

Bienvenue sur Scholarsark.com! Votre inscription vous donnera accès à l'utilisation de plus de fonctionnalités de cette plate-forme. Vous pouvez poser des questions, apporter des contributions ou de fournir des réponses, Voir les profils d'autres utilisateurs et bien plus encore. inscrire maintenant!

MS Excel for Project Managers

MS Excel for Project Managers

Prix: $94.99

With about 5 heures de contenu, 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 Excelfrom 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 ExcelYou 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?

Avec plus de 40 lectures and about 5 heures de contenu, if you budget just 30 votre état d'esprit, you can complete this course in approximately 3 semaines.

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.

Ce que vous apprendrez

  • 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, Si, Ou, IfError, and CountIf to analyze data that only meets certain conditions.

A qui s'adresse ce cours:

  • 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.

  • le “accidentalproject or program manager who wants to understand how to leverage artifacts to do their jobs better.

Laisser une réponse