Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

Office ProductivityMicrosoftExcel

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.
Rating: 4.5 out of 54.5 (90 ratings)
1,759 students
Created by Doug H
Last updated 9/2014
English
English [Auto]

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

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

Instructor

Doug H
Business Analyst at Fortune 100 Company
Doug H
  • 4.2 Instructor Rating
  • 94 Reviews
  • 1,780 Students
  • 2 Courses

            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.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.