Advanced MS Excel for Project Managers

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

Fee* : Rs. 1500 for PMI members, Rs. 1700 for non-members
Number of seats : 30
What to bring : Laptop with Microsoft excel ( preferably 2013) installed
* Fee is inclusive of buffet lunch and refreshments at the venue

Limited seats. Hurry!!!

Register Now:
https://www.yepdesk.com/advanced-microsoft-excel-for-project-managers

For more details, please contact

Jayakishore S.R.
VP Professional Development
PMI, Trivandrum, Kerala Chapter
+919447104461
vp-professionaldevelopment@pmikerala.org


Event Details
  • Days
    Hours
    Min
    Sec
  • Start Date
    February 3, 2018 9:00AM
  • End Date
    February 3, 2018 5:00PM
  • Location
    Trivandrum, INDIA
  • Venue
  • Organizer
    PMI
  • Category
  • Phone
  • Email
  • Address
    B’Hub, Mar Ivanios Vidya Nagar, Trivandrum