Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
Working knowledge of creating formulas and basic usage of Excel functions.
This course is suitable for users of Microsoft Office 2021 or 365.
Must read Things You Would Need to ensure you are properly equiped for this course.
Are you tired of grappling with complex data retrieval, date manipulation, and text handling tasks in Excel? Don't let confusion and intimidation hold you back – we have the perfect solution for you!
In today's fast-paced work environment, Excel proficiency is essential for managing multiple values and handling diverse data sets. Fear no more! Our 1-day Advanced Excel Functions Workshop is designed to equip you with the skills needed to conquer these challenges effortlessly.
Imagine confidently managing and tracking the number of workdays, considering holidays and weekends, without painful calculations or tedious reporting. Bid farewell to the frustration of dealing with disordered or unformatted raw data. With expert guidance, you'll master text-based data manipulation – replacing text, merging strings, extracting data portions, and splitting cell data like a seasoned pro, elevating your performance as a manager or project handler.
Our seasoned instructors will lead you through immersive, hands-on exercises, focusing on crucial Microsoft Excel function categories:
Step up to the demands of today's workplace challenges with our Advanced Excel Functions Workshop. Armed with new skills, you'll fearlessly tackle any data-related obstacle and take your capabilities to new heights.
Don't let data overwhelm you – conquer it with finesse in our 1-day program. Embrace a future of data mastery. Enroll today and unlock your Excel potential!
Ms Pauline Lee
Ms Ow Yeong Yin Leng
Qualified and Experienced to facilitate this course
Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.
Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.
Group discounts are also available. Request a quote from us.
No Exam! Ample hands on practice to master lessons taught.
Certificate of Attendance will be given subject to 90% attendance.
Local native speaking Trainers with more than 20 years of experience.
Microsoft Office 365 Excel Basic to Intermediate
Microsoft Office 365 Excel Advanced
Microsoft Office 365 Excel Data Cleaning for Data Analytics
Microsoft Office 365 Excel Power Query - Automating Data Extraction and Cleaning
Microsoft Office 365 Excel Pivot Table for Data Analysis and Analytics
Microsoft Office 365 Excel Table and Advanced Pivot Table Techniques for Faster Results
Microsoft Office Excel Proficiency for the Workplace
Microsoft Office Essential Advanced Excel Functions for the Workplace
Microsoft Office 365 Excel Macro and VBA Fast Track
Microsoft Office 365 Excel VBA Programming
Empowering the Enduser
Our dedication lies in equipping our learners with the tools to empower themselves. Recognizing the constant evolution of technology in the workplace, we understand the challenges and expectations they face. Bridging this gap for our learners is our motivation. We have faith in the potential of every individual and their determination to achieve success.
Select courses can be delivered in Mandarin on request basis via Zoom.