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