Microsoft Excel for the New Project Manager (PM)

Learn Excel 2010 for Project Management: A Quick Start Guide

This course provides a concise yet comprehensive introduction to using Microsoft Excel effectively for project management. Whether you're a new project manager or an experienced professional looking to enhance your toolkit, this course will equip you with the fundamental skills to leverage Excel's power.

Many projects benefit from organized information and clear presentation, and Excel is a widely accessible tool for this purpose. While not a dedicated project management software, Excel offers surprising robustness and can handle a significant portion of your project needs. This course will demystify Excel and show you how to unlock its potential.

We'll start with the essentials, building a solid foundation for your project management Excel skills. This lecture-based course focuses on practical application, giving you the knowledge to confidently manage and present project data.

Here's what you'll learn:

• Excel 2010 User Interface: Get familiar with the Excel 2010 interface.
• Understanding the Ribbon: Navigate and utilize the various features within the Excel Ribbon.
• Backstage View & Quick Access Toolbar (QAT): Efficiently manage files and access frequently used commands.
• Workbook & Worksheet Basics: Master the fundamentals of Excel worksheets – cells, columns, and rows.
• View Options: Utilize Freeze Panes and Split Panes for enhanced data viewing.
• Formulas & Functions: Learn to create and apply formulas and functions for data calculations.
• Working with Lists & Filters: Organize and analyze data using Excel lists and filters.
• The Table Feature: Understand and utilize the Table feature for structured data management.
• Basic Charting: Create effective charts to visualize project data.
• Chart Formatting: Customize your charts with styles and text formatting.
• Printing Tips: Optimize your Excel worksheets for professional printing.
• Keyboard Shortcuts: Boost your efficiency with essential Excel keyboard shortcuts.
• Gantt Charts: Create visual timelines with Excel Gantt Charts to track project schedules.
• Pareto Charts: Identify key factors with Excel Pareto Charts.
• Timeline Charts: Visualize project milestones with Excel Timeline Charts.

By the end of this course, you'll have a strong understanding of Excel's capabilities and be able to create insightful charts for your projects. Gain the skills to effectively manage and present project information using Excel 2010.