Excel Pivot Table & Pivot Chart Automation for Project Management

Ways of Working

 

Description

This session will give you the tips, tricks and techniques you need to understand and leverage Excel Pivot Tables & Pivot Charts to help you automate your project management data analytics and reporting. It will also delve into:

  • The Golden rules for collecting & structuring data for analytics
  • How to create automatic project data summaries
  • Visualisation techniques for slicing tables, charts and graphs by different criteria, e.g. by Project, by resource or by period
  • Creating automatic project summaries on separate Excel sheets with details drill down.

Practical examples will be used to show PM professionals how they can apply Pivot Table & Pivot Chart Automation tips, tricks & techniques to their PM data analytics & reporting work. This training will help you: - save time in executing your data analytics and reporting work - reduce errors in your reporting and analytics work - get enhanced insights from your data using the latest Pivot Table & Pivot Chart reporting techniques

Date:

Jan 18, 2025 (Saturday)

Time:

9:00AM - 12:30PM

Virtual Event:

Meeting link will be shared after registration

Early bird price:

[deadline: Oct 26, 2024]

$99 member / $115 non-member

Regular price:

$115 member / $125 non-member 

All cancellations are subject to a minimum $10 fee if done during the early bird period. Cancellations after the early bird or event starts are subject to full charge to ensure the Chapter does not incur excessive expenses. All refunds will be issued after two credit card-billing cycles.

If you have any questions regarding the event, please send inquiries to profdev@pmisfbac.org.

PDU's:

3.5 

About the Speaker

 

 

Areef-Ali.jpeg

Areef Ali

Areef is a Microsoft-certified trainer, business productivity consultant and entrepreneur. He has over twenty-seven (27) years of diverse work experience. He is a member of ICATT and the ACCA. He worked as an auditor with a big four accounting firm and then served as a management reporting professional in the Energy sector.

He was appointed the Chief Accountant and then the Corporate Finance Head at a leading financial institution. In June 2006, Areef started his own training and consulting business. AAABS has facilitated training seminars & completed work automation projects for numerous organizations, both private and public sector in MS Excel work productivity techniques, Financial / business modelling, Power BI reporting, Management reporting automation, Audit & Fraud automation techniques and Dashboard development. He is a Microsoft certified trainer at the Expert level in Excel and is also a certified Power BI consultant/trainer. He has trained with, hosted and delivered public seminars with many world-renowned experts & professional bodies such as the ACFE, PMI San Francisco Bay Area Chapter, PMI Silicon Valley Chapter, PMI Dallas, ACCA & ICAB. In April 2017, Areef launched the “AA Success Centre” - a corporate retreat, meeting, training and events rental Centre. Areef’s aim and passion is to inspire individuals and organizations to find success.

 

 

Register for this event
Register for this event

Information

Type of category: Virtual Course/Training

Type of activity: Ways of Working, Business Acumen

Date: January 18th, 2025

Hour: 9:00AM to 12:30PM

Registration close date: January 16th, 2025 at 11:59PM

Early bird deadline: 4 January 2025 to 11:59PM

# of PDUs: 3.5

Price

Early bird member: $99.00

Early bird non member: $115.00

Members: $115.00

Non members and Guests: $125.00

Location