Username:  Password:   Remember me   Forgot Password?  
Events
Current Events
Past Events

Member Attendees (1)
4604148
Guest Attendees (0)
No Attendees.
Details of the event: Advanced MS-Excel for Project Managers-Hands On Workshop At Kochi
21 Apr 2018
09:00 AM
Time: April 21, 2018 from 09:00 a.m. to 05:00 p.m.
Location: Travancore Court, Pallimukku, Ernakulam, Kerala, India
Street: 
City/Town: 
Contact Email: training@pmikerala.org
Contact Phone: 
Website: 
Organized By: PMI Kerala Chapter
Latest Activity: > 3 months ago
Fee:  0.00
Maximum capacity: 30
Open: 29
 
Description
ADVANCED MICROSOFT EXCEL®  FOR PROJECT MANAGERS

Date: 21-April-18 (Saturday)

Time: 9AM-5PM

Version : MS-Excel 2013

Venue: Hotel Travancore Court, Warriam Road, Eranakulam

Fee* : Rs. 1800 for PMI members, Rs. 2000 for non-members

Number of seats : 30

PDUs for credential holders : 7

Objective: Will go through basic and advanced topics in MS Excel with project managers to know how to use it and walk through with samples.

What to bring : Laptop with Microsoft excel ( preferably 2013) installed

* Fee is inclusive of taxes and buffet lunch and refreshments at the venue

 

TOPICS COVERED


BASICS

A quick review of

cell and worksheet management,

basic formulas,

shortcuts etc.

 

ADVANCED

Creating and running Macros

Advanced Formulas - Logical/Statistical/Date& time functions

V and H lookup functions

Formatting - Advanced and custom

List - Sorting/Filtering/Custom List

Tables - Formatting and data management

Data Models - Creating/Pivot tables and data imports

Data Analyzing - Pivoting and analyzing

Data visualizing - Charts/Pareto/Changing Chart style

 
Documents
No Event documents
Event Photos