Microsoft Office Excel (Advanced Level)
The Microsoft Office Excel (Advanced Level) course in Singapore is a 2-day training programme designed for individuals who want to strengthen their Excel skills and work more efficiently with complex data. Participants will explore advanced Excel features, including data analysis, data visualisation, macro programming, and financial modelling.
Topics covered include pivot tables, charts, advanced formulas and functions, and conditional formatting. This course is ideal for professionals, business owners, and students who want to take their Excel skills to the next level and use Microsoft Excel more effectively in the workplace.
Duration
2 Days
Instructor
Gerard Cannon
Venue
Marina Bay Sands, Singapore
This 2-day Microsoft Office Excel (Advanced Level) course in Singapore is designed for individuals who want to build advanced Excel skills and use the software more effectively in professional settings. The course provides a strong understanding of Excel’s advanced features, including data analysis, data visualisation, macro programming, and financial modelling.
Participants will explore topics such as advanced pivot table techniques, dynamic chart creation, complex formulas and functions, and conditional formatting. This course is ideal for professionals, business owners, and students who want to improve their analytical skills, increase efficiency, and use Excel at a more advanced level in the workplace.
Course Syllabus
Advanced Data Analysis and Visualization
Techniques for complex data analysis
Advanced charting and graphing techniques
Utilizing Power Query for data transformation
Macros and VBA Programming
Introduction to macros and VBA programming
Automating tasks with macro recorder
Writing basic VBA code for custom functions
Financial Modeling Concepts
Principles of financial modeling in Excel
Building financial models for business analysis
Scenario planning and sensitivity analysis
Pivot Tables and Data Manipulation
Advanced pivot table techniques
Using slicers and timelines for interactive reports
Managing and summarizing large data sets with pivot tables
Advanced Charting Techniques
Designing complex charts (e.g., Waterfall, Gantt)
Interactive dashboard creation
Best practices in data visualization
Complex Functions and Formulas
Utilizing array formulas and functions
Advanced logical and statistical functions
Complex formula auditing and error checking
Conditional Formatting and Data Validation
Advanced conditional formatting to visualize data patterns
Data validation techniques for data integrity
Customizing conditional formatting with formulas
Integrating Excel with Other Tools
Linking Excel with external databases (e.g., SQL)
Data import and export best practices
Integrating Excel with other Microsoft Office applications
Key Learning Outcomes
- Mastering advanced data analysis techniques for complex problem-solving.
- Developing and utilizing macros for automation and efficiency.
- Crafting detailed financial models for insightful business analysis.
- Creating dynamic, advanced charts for impactful data presentation.
- Employing sophisticated functions and conditional formatting for in-depth data exploration.
Over 25,000+ professionals have
advanced their career through ISM.
of ISM graduates say our course helped them get a promotion.
said that their training helped them increase their salary.
of graduates want to study more of our courses.
Trusted by the GCC business community.
Legacy
Meets
Results.
Transforming the Middle East workforce through 25 years of strategic training.
Join the ranks of L’Oréal, Mercedes-Benz, and Emirates. We don't just deliver courses; we architect bespoke development strategies that align 25 years of international excellence with the specific demands of your organisation.