Table of Content
 

 

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

 

Apply for certification

https://www.vskills.in/certification/Project-Management/Excel-for-Project-Managers