Calendar

Let’s face it – Microsoft Excel is one of the many choices a project manager makes, and its usage far overruns all others, including Microsoft 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-San Francisco Bay Area Chapter brings you a rare opportunity to learn this tool hands-on from the experts at an affordable price point.

1. Importing and exporting data
2. Formatting data, and extracting “parts of the data”
3. Lookups
4. Conditional Arithmetic
5. Duplicates 
6. Pivot Tables and Pivot Charts
7. Resources: Details and Types
8. Error Checking and Boundary Conditions
9. Data Visualization
10. Demonstration of Tableau (if time permits)
11. And much more…

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

PDU's:

7 PDUs (Technical: 5, Leadership: 1, Strategic: 1)

Event Agenda:

12:30 PM – 1:00 PM     Lunch (Bring your own)

  1:00 PM – 4:45 PM    Workshop

ABOUT THE SPEAKER:

Sutanu Ghosh, PMP, PMI-ACP, MCTS has served as a PMO as well as a hands-on Project Mnager on both Software and Hardware 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 an MS from Arizona State in CAD/CAM and has published on CAX tools. 

Cancellation and No-Show Policy:

If you have made a reservation and find that you will be unable to attend, please send an email to Khaled Turkmani vpprofdev@pmisfbac.org and cancel your ticket as early as possible.  All cancellations are subject to a minimum $30.00 fee if done at least 10 days before the event.  Cancellations after October 28, 2019, are subject to full charge to ensure the Chapter does not incur excessive expenses.