Excel For Project Managers

Learn Advanced Excel Tools & Techniques and Increase Efficiency of your Project Management Activities.
3.8 (5 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
88 students enrolled
$50
Take This Course
  • Lectures 69
  • Contents Video: 19 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

Master Excel Tools & Techniques and Become the Most Efficient Project Manager in town.

Most of the Project Managers spend a lot of time in interpreting project data, project tracking, reporting and manpower planning. This 18+ hour program will help project managers and business analysts save a substantial amount of time in their project management activities, learn better solutions to their existing problems and help them plan more effectively.

Top Reasons to Join "Excel for Project Manager" Training:

  • Required for Planning, Estimation, Budgeting, Tracking and Reporting
  • Learn systematically to forecast time and cost to complete a project
  • Learn how to create effective Dashboards
  • Learn how to implement scenario analysis
  • Create models based on Earned Value Management
  • Learn Advanced concepts like Monte Carlo Simulation

This course includes:

  • Exclusive video recordings on how to construct effective & efficient models
  • Download complete course material for future reference
  • Real Life Case Studies
  • 24 X 7 access to Discussion Forums
  • One-to-One Doubt Clearing Sessions for all Participants

Website: http://www.edupristine.com/ca/courses/excel-for-project-managers/

Facebook:https://www.facebook.com/edupristine

Twitter:https://twitter.com/edupristine

Blogs:http://www.edupristine.com/blog/

Sample Models: Click to Download http://www.edupristine.com/ca/downloads/excel-for-project-managers/

Category: Education

What are the requirements?

  • Basic Excel knowledge is required before attending this course

What am I going to get from this course?

  • To make you efficient in project management using excel

What is the target audience?

  • Project Managers, Business Managers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
05:15

This video contains course introduction.

Section 2: Basics of Finance
17:46

This video contains understanding FSS.

26:27

This video contains understanding PL.

13:59

This video contains accenture-PL.

17:20

This video contains Income-Statement-Rev-Recognition.

14:32

This video contains understanding-BS.

13:42

This video contains accenture-BS.

19:15

This video contains Cash-Flow-Statement.

13:26

This video contains profitability.

13:04

This video contains Optional-Depreciation.

Section 3: Planning and Estimation
16:00

This video contains Planning-Context.

15:45

This video contains Excel-Shortcuts.

04:09

This video contains Excel-Shortcuts-2007.

13:30

This video contains Excel-Referencing.

09:22

This video contains Excel-Custom Formatting.

18:49

This video contains EMI-Model.

15:42

This video contains Business-Model.

11:24

This video contains Steps-Creating-Bottomup-Model.

22:49

This video contains understanding-business-situation.

23:19

This video contains Creating-Layout.

22:46

This video contains Building-Assumptions.

Section 4: Bottom’s up Planning
19:01

This video contains Revenue-Buildup.

10:24

This video contains Manpower-Cost.

09:54

This video contains Travel-Cost.

16:13

This video contains Cost-Buildup.

14:49

This video contains Recoverable-Costs.

16:09

This video contains Projecting-PL.

27:11

This video contains Projecting-CFS.

Section 5: Important Tools for Analysis
16:13

This video contains understanding-Break-even-analysis.

10:41

This video contains Case-BreakEven.

24:25

This video contains BreakEven.

29:37

This video contains BreakEven-Taxes.

27:13

This video contains Breakeven-Dashboard.

19:02

This video contains BreakEven-Synergy.

23:03

This video contains Time-Value-Money.

28:00

This video contains NPV-IRR.

Section 6: Tracking and Reporting Project Status
20:15

This video contains Flexible-Model-Reporting-I.

11:39

This video contains Flexible-Model-Reporting-II.

18:00

This video contains Excel-DataTables.

12:43

This video contains Flexible-Model-Reporting-III.

10:34

This video contains Project-Data-Analysis-Filters.

09:10

This video contains Project-Data-Analysis-Sumif.

14:06

This video contains Project-Data-Analysis-Pivot-Tables.

15:03

This video contains Lookup-functions-Consolidated-reporting-Vlookup.

19:33

This video contains lookup-functions-Consolidated-reporting-Index-Match-I.

19:57

This video contains lookup-functions-Consolidated-reporting-Index-Match-II.

Section 7: Earned Value Management
23:30

This video contains understanding-EVM.

16:51

This video contains EVM-Case-Study.

18:14

This video contains EVM-Building-Assumptions.

20:08

This video contains EVM-Modelling-EV-Variances-Indices.

Section 8: Cost and Time Forcasting
28:40

This video contains Estimate-At-Completion.

18:07

This video contains Cumulative-EVM.

08:44

This video contains EV-Equal-PV.

07:06

This video contains Uniform-Work-Distribution.

15:22

This video contains EVM-Status-Dashboard.

10:45

This video contains Dashboard-EVM.

16:20

This video contains Reporting-Bottoms-Up-Planning-Model.

14:24

This video contains Reporting-Status-Gantt-Chart.

12:38

This video contains Reporting-Scenario-Analysis.

Section 9: Bonus Tutorial on Monte Carlo Simulation
13:56

This video contains Introduction-MCS.

14:06

This video contains Reporting-Generating-Consolidated-Reports.

12:26

This video contains understanding-Case-MCS.

14:57

This video contains Macros-Introduction.

14:13

This video contains Macros-Charting.

15:58

This video contains understanding-VBA-I.

17:15

This video contains understanding-VBA-II.

13:01

This video contains understanding-VBA-III.

16:37

This video contains MCS-Estimating-Time-Multiple-Tasks-Setting-Up-Model.

21:54

This video contains MCS-Estimating-Time-Multiple-Tasks-Implementation.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

EduPristine Inc, Leading International Finance Training Provider

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, EduPristine is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, Operational Risk Modeling etc. It was founded by industry professionals who have worked in the area of investment banking and private equity in organizations such as Goldman Sachs, Crisil - A Standard & Poors Company, Standard Chartered and Accenture. EduPristine has conducted corporate training for various leading corporations and colleges like JP Morgan, Bank of America, Ernst & Young, Accenture, HSBC, IIM C, NUS Singapore etc. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Ready to start learning?
Take This Course