Mastering Advance Excel (MAE)
Mastering Advance Excel (MAE)
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 pmEligibility 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.
- 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
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.
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.
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.
- Pattern recognition
- Automotive excel formula generation
- AI Financial Analysis
- AI Staff allocation
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
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.
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.
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.