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.
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
Please refer to the self eval sheet before signing up.
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…
Sutanu Ghosh, PMP, Certified ScrumMaster is a regular speaker at the Tools and Techniques Forum. He has served as a PMO as well as a hands-on PM on both SW and HW projects at many distinguished institutions in the Valley, including Bay Networks, Symbol Tech, Savi (Lockheed Martin) and NetApp. After graduating from Jadavpur University, Calcutta, 1986, he worked for Tata Motors, which ignited his passion for “Lean.” He has a MS from Arizona State in Mechanical Engineering (CAD), and has published in ASME on CAX tools.
Project Management Education Hours:
Earn 7 PDUs (Technical)
Meeting Leader: Sagar Amancherla
Program Agenda:
Please note the door will be locked at 8:25 AM, so plan to arrive early.
08:30 AM - Sign In and Networking
09:00 AM - Workshop Begins
12:00 PM - Lunch Break
12:45 PM - Workshop Resumes
5:00 PM – Adjourn
Food:
Continental Breakfast, Coffee, and Lunch will be provided.
Attendees should indicate whether they want a vegetarian meal during the registration.
Plan Ahead Registration:
Early Bird: PMISV member: $140 Non-PMISV member: $190
Regular: PMISV member: $190 Non-PMISV member: $240
At-the-Door Registration: No walk-ins allowed. Please register for the course online in advance
Cancellation Policy:
This event is a professional society meeting, held for the benefit of its members.
- Cancellation before Early Bird Registration Date: Full refund
- Cancellation between Early Bird Registration Date and Regular Registration Date: $30 cancellation fee; remaining amount refunded
- Cancellation after Regular Registration Date and Day before workshop (by 5:00 PM Pacific): 50% refund
Click here for Refund Request