Do you think that Excel functions are limited to mathematical, text, and statistical tasks? That’s not true. Microsoft Excel can be useful in defining the project charter, communication, and developing the project scope. Would you like to learn how Excel can be effectively used in project management? This video course is designed for this purpose.
There are 6 parts containing 58 lectures in total. You can go straight to the point and start with reports and dashboards. Then, you will learn Excel fundamentals for project management. 17 subtopics are related to the theme about formatting in Excel to show project performance. You will learn how to use conditional formatting, add sparklines to a range of cells, and manipulate Icon Sets. After that part, you will learn how to create charts for performance report and controlling. The lectures of this section include working with charts in Excel, operating with chart series, formatting and customizing charts, and etc. The training teaches thoroughly how to customize charts for project management. Hence, you will know how to work with chart fills and borders, use pictures as charts, create a Gantt Chart in Microsoft Excel, and so on. The training also covers custom dashboard and reports building.
The sections involve not only theory but also exercises related to each topic. The course will be useful for project managers and team members who are responsible for reporting. It is recommended that you already have enough knowledge for working in Excel. The training is full of tips and tricks. It is detailed but easy to understand and interactive.
Get 100% Real Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
30 Days Free Updates, Instant Download!