Excel For Project Managers
3.5 (4 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.
89 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel For Project Managers to your Wishlist.

Add to Wishlist

Excel For Project Managers

Learn Advanced Excel Tools & Techniques and Increase Efficiency of your Project Management Activities.
3.5 (4 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.
89 students enrolled
Created by EduPristine Inc
Last updated 8/2013
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 19 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To make you efficient in project management using excel
View Curriculum
Requirements
  • Basic Excel knowledge is required before attending this 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


Who is the target audience?
  • Project Managers, Business Managers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
69 Lectures
18:56:28
+
Course Introduction
1 Lecture 05:15

This video contains course introduction.

Preview 05:15
+
Basics of Finance
9 Lectures 02:29:31

This video contains understanding FSS.

Preview 17:46

This video contains understanding PL.

Understanding-PL
26:27

This video contains accenture-PL.

Accenture-PL
13:59

This video contains Income-Statement-Rev-Recognition.

Income-Statement-Rev-Recognition
17:20

This video contains understanding-BS.

Understanding-BS
14:32

This video contains accenture-BS.

Accenture-BS
13:42

This video contains Cash-Flow-Statement.

Cash-Flow-Statement
19:15

This video contains profitability.

Profitability
13:26

This video contains Optional-Depreciation.

Optional-Depreciation
13:04
+
Planning and Estimation
11 Lectures 02:53:35

This video contains Planning-Context.

Planning-Context
16:00

This video contains Excel-Shortcuts.

Excel-Shortcuts
15:45

This video contains Excel-Shortcuts-2007.

Excel-Shortcuts-2007
04:09

This video contains Excel-Referencing.

Excel-Referencing
13:30

This video contains Excel-Custom Formatting.

Excel-Custom Formatting
09:22

This video contains EMI-Model.

EMI-Model
18:49

This video contains Business-Model.

Business-Model
15:42

This video contains Steps-Creating-Bottomup-Model.

Steps-Creating-Bottomup-Model
11:24

This video contains understanding-business-situation.

Understanding-Business-Situation
22:49

This video contains Creating-Layout.

Creating-Layout
23:19

This video contains Building-Assumptions.

Building-Assumptions
22:46
+
Bottom’s up Planning
7 Lectures 01:53:41

This video contains Revenue-Buildup.

Revenue-Buildup
19:01

This video contains Manpower-Cost.

Manpower-Cost
10:24

This video contains Travel-Cost.

Travel-Cost
09:54

This video contains Cost-Buildup.

Cost-Buildup
16:13

This video contains Recoverable-Costs.

Recoverable-Costs
14:49

This video contains Projecting-PL.

Projecting-PL
16:09

This video contains Projecting-CFS.

Projecting-CFS
27:11
+
Important Tools for Analysis
8 Lectures 02:58:14

This video contains understanding-Break-even-analysis.

Understanding-Break-even-analysis
16:13

This video contains Case-BreakEven.

Case-BreakEven
10:41

This video contains BreakEven.

BreakEven
24:25

This video contains BreakEven-Taxes.

BreakEven-Taxes
29:37

This video contains Breakeven-Dashboard.

Breakeven-Dashboard
27:13

This video contains BreakEven-Synergy.

BreakEven-Synergy
19:02

This video contains Time-Value-Money.

Time-Value-Money
23:03

This video contains NPV-IRR.

NPV-IRR
28:00
+
Tracking and Reporting Project Status
10 Lectures 02:31:00

This video contains Flexible-Model-Reporting-I.

Flexible-Model-Reporting-I
20:15

This video contains Flexible-Model-Reporting-II.

Flexible-Model-Reporting-II
11:39

This video contains Excel-DataTables.

Excel-DataTables
18:00

This video contains Flexible-Model-Reporting-III.

Flexible-Model-Reporting-III
12:43

This video contains Project-Data-Analysis-Filters.

Project-Data-Analysis-Filters
10:34

This video contains Project-Data-Analysis-Sumif.

Project-Data-Analysis-Sumif
09:10

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

Project-Data-Analysis-Pivot-Tables
14:06

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

Lookup-functions-Consolidated-reporting-Vlookup
15:03

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

Lookup-functions-Consolidated-reporting-Index-Match-I
19:33

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

Lookup-functions-Consolidated-reporting-Index-Match-II
19:57
+
Earned Value Management
4 Lectures 01:18:43

This video contains understanding-EVM.

Understanding-EVM
23:30

This video contains EVM-Case-Study.

EVM-Case-Study
16:51

This video contains EVM-Building-Assumptions.

EVM-Building-Assumptions
18:14

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

EVM-Modelling-EV-Variances-Indices
20:08
+
Cost and Time Forcasting
9 Lectures 02:12:06

This video contains Estimate-At-Completion.

Estimate-At-Completion
28:40

This video contains Cumulative-EVM.

Cumulative-EVM
18:07

This video contains EV-Equal-PV.

EV-Equal-PV
08:44

This video contains Uniform-Work-Distribution.

Uniform-Work-Distribution
07:06

This video contains EVM-Status-Dashboard.

EVM-Status-Dashboard
15:22

This video contains Dashboard-EVM.

Dashboard-EVM
10:45

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

Reporting-Bottoms-Up-Planning-Model
16:20

This video contains Reporting-Status-Gantt-Chart.

Reporting-Status-Gantt-Chart
14:24

This video contains Reporting-Scenario-Analysis.

Reporting-Scenario-Analysis
12:38
+
Bonus Tutorial on Monte Carlo Simulation
10 Lectures 02:34:23

This video contains Introduction-MCS.

Introduction-MCS
13:56

This video contains Reporting-Generating-Consolidated-Reports.

Reporting-Generating-Consolidated-Reports
14:06

This video contains understanding-Case-MCS.

Understanding-Case-MCS
12:26

This video contains Macros-Introduction.

Macros-Introduction
14:57

This video contains Macros-Charting.

Macros-Charting
14:13

This video contains understanding-VBA-I.

Understanding-VBA-I
15:58

This video contains understanding-VBA-II.

Understanding-VBA-II
17:15

This video contains understanding-VBA-III.

Understanding-VBA-III
13:01

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

MCS-Estimating-Time-Multiple-Tasks-Setting-Up-Model
16:37

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

MCS-Estimating-Time-Multiple-Tasks-Implementation
21:54
About the Instructor
EduPristine Inc
3.3 Average rating
63 Reviews
818 Students
18 Courses
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.