Excel for Project Managers

WEEK-1

• Understanding-FSS
• Understanding-PL
• Accenture-PL
• Income Statement Rev Recognition
• Understanding-BS
• Accenture-BS
• Cash-Flow-Statement
• Profitability
• Optional-Depreciation

WEEK-2

• Planning-Context
• Excel-Shortcuts – I
• Excel-Shortcuts- II
• Excel-Referencing
• Excel-Custom Formatting
• EMI-Model
• Business-Model
• Steps Creating Bottom up Model
• Understanding Business Situation
• Creating Layout
• Building Assumptions

WEEK-3

• Revenue Buildup
• Manpower Cost
• Travel Cost
• Cost Buildup
• Recoverable Costs
• Projecting PL
• Projecting CFS

WEEK-4

• Understanding Breakeven Analysis
• Case Breakeven
• Breakeven
• Breakeven Taxes
• Breakeven Dashboard
• Breakeven Synergy
• Time Value Money
• NPV-IRR

WEEK-5

• Flexible Model Reporting I
• Flexible Model Reporting II
• Flexible-Model-Reporting-III
• Excel Data Tables
• Project Data Analysis Filters
• Project Data Analysis Sumif
• Project Data Analysis Pivot Tables
• Lookup functions Consolidated reporting Vlookup
• Lookup functions Consolidated reporting Index Match I
• Lookup functions Consolidated reporting Index Match II

WEEK-6

• Understanding EVM
• EVM Case Study
• EVM Building Assumptions
• EVM Modeling EV Variances Indices

WEEK-7

• Estimate At Completion
• Cumulative EVM
• EV Equal
• Uniform Work Distribution
• EVM Status Dashboard
• Dashboard EVM
• Reporting Bottoms Up Planning Model
• Reporting Status Gantt Chart
• Reporting Scenario Analysis
• Reporting Generating Consolidated Reports

WEEK-8

• Introduction MCS
• Understanding Case MCS
• Macros Introduction
• Macros Charting
• Understanding VBA I
• Understanding VBA II
• Understanding VBA III
• MCS-Estimating Time Multiple Tasks-Setting Up Model
• MCS-Estimating Time Multiple Tasks Implementation