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
Courses List
- Project Management Professionals (PMP)®
- Agile Workshop and Practical Project Management with JIRA
- Project Planning using Microsoft project
- Project planning and scheduling using Primavera P6
- Project Data Analysis and Visualization using Power BI
- Civil, Mechanical & Electrical Drawing Preparation & Management using AutoCAD
- Advanced Certificate Course on Project Planning
- Automation With Python
- PMI Disciplined Agile Scrum Master (DASM)
- Tableau For Data Analysis
Frequently Asked Questions
Related Downloads
Course Content
- 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