Procons Academy

Mastering Advance Excel (MAE)

Mastering Advance Excel (MAE)

Unlock the best potential of Microsoft Excel in your endeavors with our comprehensive workshop. This course is designed to empower people with the essential skills needed for efficient data management, analysis, and decision-making. Beyond a basic introduction, participants will delve into the practical applications of Excel in routine tasks, discovering how this powerful tool can significantly enhance work efficiency and reliability. Moreover, participants will gain proficiency in spreadsheet management, data analysis, and visualization. The course will cover fundamental Excel functions, tables, and charts, providing hands-on experience to enhance efficiency of routine activities. 
 
 

Course Details

Lecturer and Instructors

- K. D. Jeyaraj
Assistant General Manager / Senior Planning Engineer Pro Consultancy International M.Sc. in Project Management (Cardiff), B.Sc. (Hons) in Civil Engineering

- L.P. Sachi Randima
Senior Quantity Surveyor / Contract Administrator Pro Consultancy International M.Sc. Construction Law & Dispute Resolution (University of Moratuwa), B.Sc. Hons. Quantity Surveying and Construction Management, HND in Quantity Surveying

Course Duration & Times

12 Hours - 04 Sessions

Every Saturdays 6.00 pm-9.00 pm

Batch Number & Starting Date

BATCH NUMBER 09
Will be notified soon

Eligibility Requirements

Anyone can apply

PMI Authorized Training Partner in sri lanka

Frequently Asked Questions

Related Downloads

Course Content

Advance Excel Workshop
  • Navigating the Excel interface for efficient work.
  • Creating and managing workbooks with a focus on routine engineering documentation.
  • Basic formatting and data entry techniques for clarity and readability.
  • Utilizing array formulas for complex calculations
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH) for data retrieval
  • Statistical functions for engineering data analysis.
  • Utilizing array formulas for complex calculations
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH) for data retrieval
  • Statistical functions for engineering data analysis.
  • Creating informative dashboards for project tracking
  • Incorporating custom visuals and SmartArt graphics
  • Visualizing engineering data trends with Sparklines.
  • Building scenario models for engineering projects
  • Performing sensitivity analysis for risk assessment
  • Goal Seek and Solver for optimization problems
  • Personalizing the Ribbon and Quick Access Toolbar
  • Building custom templates for engineering reports
  • Incorporating add-ins for specialized engineering tasks
  • Pattern recognition
  • Automotive excel formula generation
  • AI Financial Analysis
  • AI Staff allocation

Completed 8+ Batches

Internationally Valid Certification

23 PMI approved contact hours

Benefits on having a CAPM

Career Advancement:

PMP certification is globally recognized and respected, making certified professionals more attractive to employers.

Global Recognition:

CAPM is a globally recognized certification, which means your skills and knowledge are recognized and valued internationally.

Professional Credibility:

Earning CAPM certification demonstrates your commitment to the project management profession and your dedication to building a strong foundation.

Access to PMI Resources:

As a CAPM credential holder, you gain access to resources provided by the Project Management Institute (PMI).