Advanced PROJECT Analytics

This is a two-in-one course that will teach you to how master EXCEL and Microsoft PROJECT for effective Project Management.

In this course, you will learn how to unlock and leverage the power of Excel in analyzing data for projects, and Microsoft Project to plan, schedule, track, manage and report projects professionally.

EXCEL OUTLINE
 The Excel Window
 Getting and Transforming Project Data
 Formulas and Functions 1,2 & 3
 Flash Fill
 Series and Iterations
 Conditional Formatting with formulas
 Data Validation
 Quick Analysis
 Statiscal Analysis
 Pivot Tables and Pivot Charts
 Sparklines
 Charts and Slicers
 Gannt Chart in Excel
 What If Analysis
 Managing large worksheets
 Workbook, Sheet and Cell Protection
 Printing

PROJECT OUTLINE
 Project Window and Overview
Working with Gannt Charts
 Creating and Loading Resources
 Creating and Calculating Project Cost
 Understanding & entering Percent Complete for a Project
 Following Critical Path in a Project
 Budgeting a Project
 Loading Materials
 Creating Milestone and Timeline
 Tracking Progress in a Project
 Working with Baselines
 Creating and Customizing Project Calendars.
 Task and Team Planning
 Creating Dashboards
 Importing resources from Excel
 Project Presentation using PowerPoint
 Performing basic Project window tasks