Regístrate ahora

Iniciar sesión

Contraseña perdida

Perdiste tu contraseña? Por favor, introduzca su dirección de correo electrónico. Recibirá un enlace y se creará una nueva contraseña por correo electrónico.

Añadir mensaje

Debe iniciar sesión para añadir notas .

Añadir pregunta

Debe iniciar sesión para hacer una pregunta.

Iniciar sesión

Regístrate ahora

Bienvenido a Scholarsark.com! Su registro le conceda el acceso a la utilización de más características de esta plataforma. Puede hacer preguntas, hacer contribuciones o proporcionar respuestas, ver los perfiles de otros usuarios y mucho más. Regístrate ahora!

MS Excel for Project Managers

MS Excel for Project Managers

Precio: $94.99

With about 5 horas de contenido, 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?

Con más de 40 lectures and about 5 horas de contenido, if you budget just 30 minutes a day, you can complete this course in approximately 3 semanas.

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.

Los candidatos deben estar familiarizados con Microsoft Azure y Microsoft

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

Para quién es este curso:

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

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

Acerca de arkadmin

Deja una respuesta