Microsoft Excel for the New Project Manager (PM)
4.0 (41 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.
1,513 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel for the New Project Manager (PM) to your Wishlist.

Add to Wishlist

Microsoft Excel for the New Project Manager (PM)

A basic course for project managers (new or PMP) on how to use Microsoft Excel 2010 effectively.
4.0 (41 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.
1,513 students enrolled
Created by Doug H
Last updated 9/2014
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Identify the user interface for Excel 2010
  • Describe how to work with data in worksheets
  • Recognize effective ways to present data
View Curriculum
Requirements
  • Microsoft Excel 2010 on Windows Operating System
Description

Welcome to the Excel 2010 for the New Project Manager course! This course is meant to be a short but information rich introduction to learn how to use Excel as a new project manager. And if you are an experienced project manager, you may also pick up some tips that could help with your individual projects, but think of it as a primer of Excel for Project Management.

You may be running projects that require something to help manage or present information and usually a common tool is Microsoft Excel. Though it may not have the features of Project Management specific software, Excel is robust enough to use for project management. However you may find that once you understand what Excel can do, you’ll find out it is a very powerful tool that will probably do the majority of what you want. You just need to figure out how to use it.

To really understand Excel you should probably start with the basics (and there is a lot to learn!). This course is a lecture only format that gives just enough information to get you started to feel comfortable using Excel to run projects.

This course will cover the following:

  • Explore the Excel 2010 User Interface
  • Understanding the Ribbon
  • A Look at the Backstage view
  • Quick Access Toolbar (QAT)
  • Workbook and Worksheet Basics
  • Primer to Cells, Columns and Rows
  • Exploring different views using Freeze Panes and Split Panes
  • How to Create Formulas and use Functions
  • Using Lists Filters
  • How the Table Feature Works
  • Basics of Charting
  • Formatting Charts
  • Using Styles and Text Formatting
  • Tips on Printing
  • Keyboard Shortcuts
  • How to Create a Gantt Chart
  • How to Create a Pareto Chart
  • How to Create a Timeline Chart

There are a lot of things you can do with Excel and this course should give you the tools to really understand how it works. By the end of the course you should feel familiar with using Excel and may also be able to create some charts that you may see in your work.

Who is the target audience?
  • For the new Project Manger that has a basic knowledge of Excel
  • For the experienced Project Manager that would like to refresh Excel skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 02:34:20
+
Excel Basics
7 Lectures 36:18

An overview of the course with the description of the intended audience and objectives. The outline of the course will be covered here.

Preview 02:21

This lecture briefly goes over the user interface so you can identify the basic parts of an Excel workbook/worksheet.

Preview 05:32

The Ribbon contains the majority of Excel commands to perform basic to complex tasks.

Preview 08:04

A quick overview of the QAT (Quick Access Toolbar). The QAT allows you to place frequently used commands in a quick to find area.

What is a QAT?
02:53

Explore the Backstage view in this video.

Look Backstage
06:59

An overview of managing worksheets and workbooks

Delve into Worksheets and Workbooks
07:01

A sample of some keyboard shortcuts for the commands in this Section

Keyboard Shortcuts
03:28
+
Working with Data
6 Lectures 54:08

The basics of managing cells, columns and rows.

Work with Cells, Columns and Rows
13:19

Explore the different ways you can view the worksheet.

Change Views
09:28

Basics on how to create formula and use Excel Functions.

Create Formulas and Use Functions
11:10

An overview of lists,sorting, filters and the table feature

Explore Lists, Filters and Tables
08:42

This lecture is an introduction into the different chart types available in Excel.

Charting Basics
04:59

A sample of some keyboard shortcuts for the commands in this Section

Keyboard Shortcuts
06:30
+
Making it Presentable
4 Lectures 35:21

Explore the multiple features to modify your charts.

Exploring Chart Options and Features
14:33

Covering the basics on how to modify and format the text in your worksheets.

Identify Styles and Formatting
10:03

An overview of some printing options.

Choose the Right Print Settings
06:00

A sample of some keyboard shortcuts for the commands in this Section

Keyboard Shortcuts
04:45
+
Examples
3 Lectures 28:00

A step by step example on how to create a basic Gantt chart.

Gantt Chart
09:21

A step by step example on how to create a Pareto chart.

Pareto Chart
09:17

A step by step example on how to create a Timeline (with Milestones) chart.

Timeline Chart
09:22
+
Summary
1 Lecture 00:33

Closing with the summary of what was learned. Thank you for coming this far and good luck!

Close
00:33
About the Instructor
Doug H
4.0 Average rating
41 Reviews
1,513 Students
1 Course
Business Analyst at Fortune 100 Company

I'm a big fan of data crunching, data analysis, effective communication and using a bit of psychology to tell a story.

My first introduction to spreadsheets was Excel 95 and I was hooked so I guess I'm a data crunching nerd. I was a casual user until I really needed to use it for data analysis ten years ago. The group I worked for was looking at product failures and trying to convince the engineering teams to change. It was easy...not! But that's when I discovered Pivot Tables and all those great look-up functions. I could plug in historical data, run it through Excel and make all these fancy charts. Then I actually got an engineering team to add a feature!

Of course it wasn't all data that convinced people to do things. The other side was communication; telling a good story and giving the WIIFM (What's in it for Me?). I've spent a lot of time putting together visual communications using PowerPoint so I guess you can say I'm well versed in that too. Powerpoint is a great tool to tell a story and can definitely influence without too much text (hint: high quality images).

Lastly I'm a fan of psychology, especially individual behavior and group dynamics. What makes people tick and how to influence for the greater good...I really like Malcolm Gladwell books.

When it comes down to it, I'm a believer in "winning friends and influencing people".