Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Webinar - MS Excel: Data Management Tips and Tricks for PMPs

PMI-SFBAC Professional Development Team

Tuesday, July 26, 2016 from 7:00 PM to 8:00 PM (PDT)

Ticket Information

Type Remaining End Quantity
Member 20 Tickets Ended Free  
Not a member / interested   more info 86 Tickets Ended Free  

Who's Going

Loading your connections...

Share Webinar - MS Excel: Data Management Tips and Tricks for PMPs

Event Details

EVENT DESCRIPTION:

Let’s face it – Microsoft Excel is the choice of many a project manager, and its usage far overruns all others, including MS Project. It is the only tool that is acceptable to Finance and other peripheral functions.

Being a part of “Office”, we tend to be self-taught, and consequently, end up frustrated.

So why not learn about some useful tips and tricks through common scenarios?

The material for this class is derived from the common yet significant “use cases” and mistakes that instructors have observed in their careers.

PMI-SF BAC brings you a rare opportunity to learn this tool hands-on from the experts at an affordable price point.

Who Should Attend This Workshop:

  • Those who are self-taught; those who have been frustrated by MS Excel beyond colors and type-faces in “Formatting” 
  • Those who wish to understand more about how MS Excel handles data
  • Those who are unfamiliar with reporting project status and risks using traffic lights and weighted score cards.
  • Those who wish to know more about using Excel as a formidable tool in Engineering Operations
  • Those who are unfamiliar with the details regarding the interface of Excel and MS Project
  • Those who wish to know about the next step - Tableau

 

What You Will Learn

  • Importing and exporting data
  • Formatting data, and extracting “parts of the data”
  • Lookups
  • Conditional Arithmetic
  • Duplicates 
  • Pivot Tables and Pivot Charts
  • Resources: Details and Types
  • Error Checking and Boundary Conditions
  • Data Visualization
  • Introduction to Tableau
  • And much more…

PDUs: 1

 

ABOUT THE INSTRUCTORS:

Sutanu Ghosh, PMP, PMI-ACP, MCTS has served as a PMO as well as a hands-on PM on both SW and HW projects at many distinguished institutions in Silicon Valley for over 20 years, including Bay Networks, Symbol, Lockheed Martin, NetApp and VMware. After graduating in Mechanical Engineering, he worked for Tata Motors, which ignited his passion for “Lean.” He has a MS from Arizona State in CAD/CAM, and has published on CAX tools

 

Kum Tham

Master of Science, UC Berkeley
Over 30 years in Software Technology industry
Director of R & D Analytics at VMware Inc.
Speaker at 2014 Tableau Customer Conference on R & D Analytics in SDLC

 

Webinar registration information will be sent to you upon Eventbrite registration.

Have questions about Webinar - MS Excel: Data Management Tips and Tricks for PMPs? Contact PMI-SFBAC Professional Development Team

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.