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
 
Batch Number & Starting Date
BATCH NUMBER 09
Will be notified soon
 
Course Duration & Times
12 Hours - 04 Sessions Every Saturdays 6.00 pm-9.00 pm
 
Eligibility Requirements
Anyone can apply

Completed 8+
Batches

PMI approved
contact hours

Internationally Valid
Certification

Benefits on having this course

Enhanced Career Opportunities:

CAPM certification enhances your project management credentials and can open up opportunities for career advancement.

Increased Earning Potential:

CAPM certification enhances your project management credentials and can open up opportunities for career advancement.

Improved Project Management Skills:

Preparing for and obtaining the PMP certification involves a deep dive into project management methodologies and best practices.

Networking Opportunities:

PMP certification connects you with a global community of project management professionals.

Introduction to MS Excel
  • 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.
Advanced Formulas and Functions
  • Utilizing array formulas for complex calculations
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH) for data retrieval
  • Statistical functions for engineering data analysis.
Advanced Data Analysis Techniques
  • Utilizing array formulas for complex calculations
  • Lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH) for data retrieval
  • Statistical functions for engineering data analysis.
Engineering Data Visualization
  • Creating informative dashboards for project tracking
  • Incorporating custom visuals and SmartArt graphics
  • Visualizing engineering data trends with Sparklines.
Scenario Analysis and What-If Modeling
  • Building scenario models for engineering projects
  • Performing sensitivity analysis for risk assessment
  • Goal Seek and Solver for optimization problems
Customizing Excel for Engineering Workflows
  • Personalizing the Ribbon and Quick Access Toolbar
  • Building custom templates for engineering reports
  • Incorporating add-ins for specialized engineering tasks
R1C1 Cell reference style

To prepare for the PMP (Project Management Professional) examination, practice sessions typically involve mock exams, sample questions, and test-taking strategies. These sessions help candidates become familiar with the exam format and assess their readiness.

Ratios on Cost benefit analysis (NPV, IRR and ROI)

To prepare for the PMP (Project Management Professional) examination, practice sessions typically involve mock exams, sample questions, and test-taking strategies. These sessions help candidates become familiar with the exam format and assess their readiness.

Use of Auditing tools for formulas

To prepare for the PMP (Project Management Professional) examination, practice sessions typically involve mock exams, sample questions, and test-taking strategies. These sessions help candidates become familiar with the exam format and assess their readiness.

AI tools in excel
  • Pattern recognition
  • Automotive excel formula generation
  • AI Financial Analysis
  • AI Staff allocation
How Can The PMP Certification Benefit My Career?

The PMP certification is highly regarded in the project management field and can enhance your career prospects. It demonstrates your knowledge and expertise in project management, increases your earning potential, and opens up opportunities for leadership roles in project management

What Docs The PMP Coursc Cover?

The PMP course covers various aspects of project management, including project initiation, planning, execution, monitoring and controlling, and project closure. It also covers knowledge areas such as scope management, time management, cost management, quality management, risk management, and communication management.

Who Should Take The PMP Course?

The PMP course is suitable for professionals who are involved in project management or aspire to be project managers. It is ideal for project managers, team leaders, consultants, and individuals responsible for managing projects of various sizes and complexities.

What Are The Prerequisites For The PMP Course?

To be eligible for the PMP course, you need to fulfill certain prerequisites set by PMI. You must have a secondary degree (high school diploma, associate’s degree, or global equivalent) with at least five years of project management experience, or a four-year degree (bachelor’s degree or global equivalent) with at least three years of project management experience.