Microsoft Office Excel (Intermediate Level)
The Microsoft Office Excel (Intermediate Level) course in Singapore is a 2-day training programme designed for individuals who already have a basic understanding of Microsoft Excel and want to improve their skills. Participants will learn how to use intermediate Excel features, including data analysis, data visualisation, formulas, and functions.
Duration
2 Days
Instructor
Gerard Cannon
Venue
Marina Bay Sands, Singapore
Looking for Microsoft Excel training in Singapore? Our 2-day Intermediate Excel course is designed for learners who already know the basics and want to work faster and more effectively.
This 2-day Microsoft Excel Intermediate course in Singapore is designed for individuals who are familiar with the basics of Microsoft Excel and want to build on their existing skills. The course explores intermediate Excel features, with a focus on data analysis, data visualisation, and more advanced formulas and functions. Key topics include conditional formatting, chart creation, pivot tables, and working efficiently with larger data sets.
This corporate Microsoft Excel training is ideal for professionals, business owners, and students who use Excel for reporting, analysis, and business decision-making.
Course Syllabus
Advanced Data Analysis Techniques
Utilizing advanced filter options
Exploring data analysis tools
Performing what-if analysis
Conditional Formatting and Data Validation
Applying conditional formatting to data sets
Customizing rules for dynamic data displays
Using data validation for improved data integrity
Mastering Functions and Formulas
Exploring logical functions (IF, AND, OR)
Utilizing lookup functions (VLOOKUP, HLOOKUP)
Working with date and time functions
Pivot Tables and Pivot Charting
Creating and customizing pivot tables
Analyzing data with pivot charts
Advanced pivot table techniques, such as grouping and calculated fields
Effective Charting and Data Visualization
Designing advanced charts (e.g., Combo charts, Histogram)
Utilizing Sparklines for in-cell visualization
Best practices for effective data presentation
Managing Large Data Sets
Techniques for handling and analyzing large volumes of data
Introduction to data consolidation
Efficient data sorting and filtering strategies
Data Import and Export
Importing data from external sources
Exporting data to other formats
Linking and consolidating data across multiple workbooks
Advanced Excel Tips and Tricks
Keyboard shortcuts and productivity tips
Troubleshooting common Excel issues
Customizing the Excel environment for individual preferences
Key Learning Outcomes
- Harnessing advanced data analysis techniques for better decision-making.
- Crafting dynamic reports and visualizations using pivot tables and charts.
- Utilizing complex functions and formulas for in-depth data manipulation.
- Employing conditional formatting to highlight critical data insights.
- Managing and analyzing large data sets with efficiency and accuracy.
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.