Park Avenue Presentations

Project Management using Microsoft Excel

Duration: 90 minutes

Speaker: Melissa Esquibel

 

 

Webinar Description

There’s hardly a profession today that doesn’t involve some level of project management. However, if you do not have access to a project management application like Microsoft Project, Microsoft Excel is an excellent alternative. Applying accepted project management practices and a robust tool like Excel can help keep you and your project team on track. Why Excel? Well, when you think about it had the two major components required for a project management tool: List management and date formulas. It is easily customizable and easy to protect to ensure that only prescribed changes can be made by others.

In this webinar we’ll cover…

•    The do’s and don’ts of building lists to optimize the full set of Excel tools available
•    Project management principles for constructing a good task list
•    Project management templates available from Microsoft and how to customize them
•    The fundamentals of Excel time & date math
•    Employing Excel data visualization techniques to report progress and flag exceptions

Attend this webinar and you will learn how to use:

•    Conditional formatting
•    Time & date math Functions
•    Table formatting
•    Filtering
•    Charts & graphs
•    Using and saving templates
•    Worksheet protection to control changes

 

Logistics

This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.