WhatsApp Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Office 365 Excel Advanced

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
 
OKEADV
Duration
 
14 Hours (2 Days)
Course Fee
 
$392.40 inclusive of GST
Funding
 
UTAP for NTUC Members
This Course is For
 
Anyone who needs to use the advanced functions of Office 365 Excel to perform basic data analysis and report generation.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Prerequisites

Learners who have attended our Microsoft Office 365 Excel Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Excel. This course is suitable for leaners of Microsoft Office 2019 or 2021.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.


Supercharge Your Office 365 Excel Skills for Maximum Workplace Efficiency!

Are you tired of being confined to basic data entry and formula usage in your Microsoft Office 365 Excel reports? Are you ready to take your productivity to the next level and meet the demands of the data-driven era? Look no further! Introducing our Microsoft Office 365 Excel Advanced course designed specifically for you.

By enrolling in our Microsoft Office 365 Excel Advanced course, you will unlock a world of possibilities and gain the power to:

  1. Save Time with Custom Templates: Learn how to create personalized templates that will revolutionize your reporting process and save you precious time.
  2. Master Advanced Formulas and Functions: Take your calculations to new heights by mastering advanced formulas and functions from Excel 365 that can handle complex conditions and scenarios effortlessly.
  3. Error Detection and Correction: Say goodbye to formula errors! Discover how to analyze and correct errors encountered in your Office 365 Excel formulas, ensuring accurate and reliable results.
  4. Data Integration Made Easy: Establish relationships between different Excel tables or worksheets, enabling seamless integration and consolidation of your data for comprehensive reporting.
  5. Streamline Data Consolidation: Say goodbye to manual data gathering! Learn how to consolidate data from multiple Excel worksheets into a single, comprehensive report effortlessly.
  6. Effortless Sorting and Filtering: Easily extract relevant data from vast spreadsheets using powerful sorting and filtering techniques, making your reporting process a breeze.
  7. Intelligent Data Highlighting: Automate the identification of critical information by applying customized rules to highlight data that meets specific conditions. Keep track of underperforming projects, overdue invoices, or struggling students effortlessly.
  8. Visualize Data Trends: Enhance your reports by adding captivating graphical visuals to showcase data trends, impressing your audience and adding a professional touch.
  9. Enhance Report Readability: Master the art of managing large reports with numerous columns and rows, making them more reader-friendly and easy to analyze.
  10. Advanced Data Analysis: Dive deep into data analysis with Office 365 Excel Pivot Tables and Charts, unlocking valuable insights and enabling you to create more complex and comprehensive reports.
  11. Harness the Power of AI in Office 365 Excel: Learn how to leverage the cutting-edge capabilities of AI in Excel to expedite data analysis, making your work faster and more efficient.
  12. Automate Repetitive Tasks: Record and automate mundane tasks, freeing up your time for more important and meaningful work.

In just two days, our comprehensive Office 365 Excel Advanced course will equip you with all the skills necessary to enhance your proficiency, accuracy, and productivity, ensuring you remain relevant in today's dynamic workplace.

Get ready for a hands-on learning experience, with plenty of practice opportunities using real workplace examples. Don't miss out on this incredible opportunity to supercharge your Office 365 Excel skills. Enroll today and unlock your full potential!


Our Friendly Trainer

Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

  • More than 20 years of training experience
  • Native speaking Trainers
  • ACTA Certified
  • Microsoft Certified
  • ITE Certified

Special Request

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.


Reviews

Thanks a lot Pauline for the two day course and being very clear with good pace throughout the training!
- Jia Hui (SPF)

The demos are clear and examples given for practice are usable in work environment
- William Lee (Nikon Singapore)

The trainer able to respond to my questions swiftly and she is able to cover all the syllabus well and understandable.
- Danial (SPF)

Grateful for Kendra's patience in going through the steps, sometimes even requiring her to repeat a few times.
- Nura Hamzah (SPS)

Definitely help me in my work to be more productive and efficient. Thank you Pauline for sharing useful tips in this course.
- Cheryl (Nikon Singapore)


No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

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.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
WhatsApp Us
Online Enquiry: Click here
Locate Us: Click here

Facebook