Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel for the New Project Manager (PM)
Rating: 4.4 out of 5(93 ratings)
1,777 students

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.
Created byDoug H
Last updated 8/2016
English

What you'll learn

  • Identify the user interface for Excel 2010
  • Describe how to work with data in worksheets
  • Recognize effective ways to present data

Course content

5 sections • 21 lectures • 2h 34m total length

  • Overview2:21

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

  • Explore the User Interface5:32

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

  • Unwrap the Ribbon8:04

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

  • What is a QAT?2:53

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

  • Look Backstage6:59

    Explore the Backstage view in this video.

  • Delve into Worksheets and Workbooks7:01

    An overview of managing worksheets and workbooks

  • Keyboard Shortcuts3:28

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

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 this course is for:

  • For the new Project Manger that has a basic knowledge of Excel
  • For the experienced Project Manager that would like to refresh Excel skills

Report abuse