Excel Formulas for PM data analytics and Reporting automation

Ways of Working

 

Description

This session will give you the tips, tricks and techniques you need to leverage Excel formulas to help you automate your project management data analytics and reporting.

This intensive "hands on" session will cover using PM examples:

  • Shortcut tips, tricks & techniques writing formulas & nested calculations
  • Using conditional formulas to summarise activities / project expenditure data
  • Cross Linking project data in different sheets / files using the xlookup formula
  • Using dynamic array formulas to summarise and analyse data

Date:

Jan 11, 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 Power Skills                                                                        

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 11th, 2025

Hour: 9:00AM to 12:30PM

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

Early bird deadline: 28 December 2024 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