phone call us Inspizone+65 8586 4485
Email us Inspizoneenquiry@inspizone.com
Send Enquiry
Chat with us InspizoneChat With Us
Advanced Excel Course Singapore

SkillsFuture Credit Eligible Training Center Advanced Excel Course

SkillsFuture Eligible
SDF

Skills Development Fund

Forecasting Data

Advanced Excel Course Singapore: Learn VLookup, Hlook up, Consolidation, Protecting Worksheet, Workbook, Basic Macros






Course Start Date


  • 05/04/2024 | 09:30 to 17:30
    Week Days
  • 20/04/2024 | 09:30 to 17:30
    Weekend
  • 21/04/2024 | 09:30 to 17:30
    Weekend
  • 17/04/2024 | 09:30 to 17:30
    Week Days
  • 26/04/2024 | 09:30 to 17:30
    Week Days
  • 18/05/2024 | 09:30 to 17:30
    Weekend
  • 19/05/2024 | 09:30 to 17:30
    Weekend
  • 08/05/2024 | 09:30 to 17:30
    Week Days
  • 17/05/2024 | 09:30 to 17:30
    Week Days
  • 29/05/2024 | 09:30 to 17:30
    Week Days
  • 15/06/2024 | 09:30 to 17:30
    Weekend
  • 16/06/2024 | 09:30 to 17:30
    Weekend
  • 07/06/2024 | 09:30 to 17:30
    Week Days
  • 21/06/2024 | 09:30 to 17:30
    Week Days
  • 14/07/2024 | 09:30 to 17:30
    Weekend
  • 03/07/2024 | 09:30 to 17:30
    Week Days
  • Schedule


    Day: 1 Day
    Duration: 7 Hours
    Timings: 9:30 AM - 5:30 PM

    10 Anson Road, 26-08A International Plaza, Singapore 079903

    Register Now

    Why Choose Us


    • SkillsFuture Credit Eligible
    • Expert Local Trainers
    • Hands-on Training by experts
    • Certificate of Achievement
    • Free Refresh Class within 6 Month

    Quick Register

    Who Should Attend This Advanced Excel Training Course Singapore


    Advanced excel training singapore is ideal for students who already have foundational knowledge and skills in Excel and wants to become an expert

    Course Completion Requirements:

    Minimum 75% attendance is required in order to complete the course and receive the course completion certificate

    Entry Requirements

    Above 16 years old

    High School Level English

    Basic internet & computer operation skills

    Learn Advanced Excel Course in Singapore


    About Course:  Microsoft Advanced Excel Course is a 1-day training course in Singapore covering Advanced Features, Functions and Formulas of Microsoft Excel.

    This Advanced Excel Training will be focusing on VLookup, Hlook up, Consolidation, Protecting Worksheet, Workbook, Basic Macros and many more tricks in Microsoft Excel.

    This is a hands-on Excel training where you will be working on live exercises of each topic.

    Target Student: Student should have Intermediate Excel knowledge.

    advanced excel course singapore

    Unsure if this course is suitable for you? Take this Quick test to help you decide.

    Grants available


    SkillsFuture Eligible

    SkillsFuture Credit: Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

    SDF

    Skills Development Fund

    SDF: Deductible of 2$/hours for S/PRs trainees under company sponsorship.

    How to claim Fund

    How to claim Fund from SkillsFuture Singapore .

    1-day Advanced Excel course outline


    Working With Multiple Worksheets And Workbooks

    • Use Links and External References
    • Use 3-D References
    • Consolidate Data

    Sharing And Protecting Workbooks

    • Collaborate on a Workbook
    • Protect Worksheets and Workbooks

    Using Lookup Functions And Formula Auditing

    • Use Lookup Functions
    • Trace Cells
    • Watch and Evaluate Formulas

    Automating Workbook Functionality

    • Apply Data Validation
    • Search for Invalid Data and Formulas with Errors
    • Work with Macros

    Forecasting Data

    • Determine Potential Outcomes using Data Tables
    • Determine Potential Outcomes using Scenarios
    • Use the Goal Seek Feature
    • Forecasting Data Trends

    Frequently Asked Questions (FAQs)


    What am I going to learn in the advanced excel course Singapore?

    In the advanced excel course, we focus more on practical things and cover advanced features, formulas, and functions of Excel. In the advanced excel course Singapore, students will get a chance to learn VLookup, Hlook up, Consolidation, Protecting Worksheet, Workbook, Basic Macros, and many more tricks in Microsoft Excel.

    Who can take the advanced excel course?

    The course is ideal for:

    • Analyst
    • Business professionals
    • Entrepreneur
    • Training professionals
    • Student

    Is there any prerequisite for joining this course?

    There’s no specific prerequisite for joining the course but students are expected to have intermediate knowledge of excel to ace the subject.

    What is the duration of advanced excel training?

    The advanced excel training is a 1-day program (7 hours) where you get hands-on training on advanced excel hacks.

    Why should I choose the advanced excel course Singapore?

    With industry experts who hold immense experience in the field of Excel, we design and curate top-notch courses that help students to brush their skills and make them industry ready. We believe that knowledge is passed on from people who have been in the channels, putting in long hours, and solving real problems with their skill set. We aim to boost you with the very best of what works in the industry and make you stand out from the competition.

    With us, you’ll get:

    • Expert local trainers
    • Hands-on training and doubt-solving sessions with experts
    • Certificate of achievement

    What's the curriculum of the advanced excel course?

    The curriculum of our advanced excel course goes like this:

    • Working with multiple worksheets and workbooks
    • Sharing and protecting workbooks
    • Creating sparklines and mapping data
    • Using lookup functions and formula auditing
    • Automating workbook functionality
    • Forecasting data

    Is it very difficult to learn and complete an advanced excel course?

    Learning something depends all on your mindset and how you’ve managed your resources. Everything takes time and practice. One can learn excel smoothly if they break the learning process and practice what they’ve been taught daily. It’s quite impossible to master the subject within a few days or months. To hone the subject and become an industry expert, you need to be patient, and super sincere, invest time and learn every bit of it. Practice indeed makes a man perfect, and if you practice daily, no subject is going to be tough on you.

    google logo Reviews of our students


    Sarah Lah
    Sarah Lah
    4 months ago

    Great excel course by Bee Hoon for 3 Days. Trainer was humorous and contextualised the info learnt in real life examples. Exercise files were easy to follow also.
    Arun Dixit
    Arun Dixit
    11 months ago

    I attended the excel course, our trainer Valene was really patient and well versed. The training environment was really good, I will definitely go again. Will recommend to my friends and family for sure.
    Wenyan Yeo (W)
    Cara Chan
    4 days ago

    Attended WORDPRESS WEBSITE CREATION COURSE on 25 Sep 2023. Really appreciate the training made simple for beginners like myself. The trainer Mr Abhinay gave clear explanations and repeated many times to make sure we understood. Understanding how Wordpress works enabled me to navigate my company website and make updates efficiently. Unfortunately, the plug-in used by my company website was not taught in the course; which is understandable given the many different types of plug-ins available.The staffs were helpful and understanding when I was unable to log-in my singpass for attendance. It was overall an enjoyable experience to me. Snacks and beverages at the pantry was a bonus, too! Thank you, Inspizone!
    Joanna
    Joanna
    10 months ago

    Thank you for the practicable courses. Lessons were conducted at a comfortable pace. Trainer Ms Mridula is knowledgeable, very helpful and encourages class participation to liven up the sessions. She also shared about how the tools can be applied in our work. Both intermediate and advanced excel courses exceeded my expectations. Thank you.
    Guido Sudero
    Guido Sudero
    11 months ago

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Avira Dixit
    Avira Dixit
    a year ago

    I attended their 3 days excel training. I must say this is one of the best training places here at Singapore. They provide full training materials, you dont even need to bring your own laptop. Their course content was appropriate and examples used for explanation were relatable. The instructor was very patient and cleared all our doubts. Highly recommend!!
    Leanie Lee
    Leanie Lee
    a year ago

    I have just completed my excel levels 1 & 2. Trainer Bee Hoon is great. Her training was clear, audible & practical. A professional trainer indeed. Initially I was having some difficulties in my enrolment, but both the administrators Emma & Huyen were very helpful, patient, accommodating & efficient in their service, making it a pleasant experience I have had with InspiZone. InspiZone Highly recommended.
    Wenyan Yeo (W)
    Wenyan Yeo (W)
    7 months ago

    Attended the MS Excel course (Beginner & Intermediate) on 25 & 26 Aug. Ms Koh Bee Hoon was the trainer for the above mentioned course. Ms Koh is very knowledgeable and patient, she makes sure everyone in the class understands the current topic before she moves on to the next. The lesson pace is very manageable too. After attending the course, I have learnt much more functions about MS Excel! Highly recommend this course to anyone who wish to learn more about MS Excel.
    Lucia
    Lucia
    a year ago

    I have attended their MICROSOFT OFFICE EXCEL 2016 – INTERMEDIATE & ADVANCED LEVELS training. The trainer Bee Hoon is knowledgeable, patient and made online training an enjoyable hands-on experience. I would recommend the course for anyone wanting practical training, and I hope that there will be more online classes in the future.
    J Quek
    J Quek
    2 years ago

    I am so glad that I had clicked on the site of Inspizone and decided to give a try on one of their courses, Master Excel Training. And I've got more than what I expected, I have done the course many years back but the trainers were never generous with their tips but Bee Hoon, a big "WOOW" she is very generous with the tips and know-how that I had never known before and she is very patient ...gosh! Fantastic trainer!! The Training Coordinator, Sophia, she was very helpful from the moment I send in my request and questions, she patiently guided me from registration, claiming my skill future till the approval and giving me the class schedule. A big thank you and great service! The school, wow!! I never have seen a school supplying such a well-stocked and premium snacks for students/trainees, the class welfare is really great and taken care of!! Thank you! I will definitely recommend Inspizone and I will keep a lookout for other courses that they have.
    Katherine Ang
    Katherine Ang
    a year ago

    I have researched on a few training centres before deciding on Inspizone. Very happy that I have chosen the right one! I have attended Microsoft Excel Intermediate & Advanced Class by Bee Hoon. She is super good, knowledgeable and clear with the online class. If you have any doubts she will also guide you patiently and ensure that you know how the functions work. If you are a beginner or you want to brush up your excel skills Bee Hoon will be my number one recommendation! 🙂 My training coordinator Emma has been very helpful towards my question too. Will definitely sign up for more courses with Inspizone!
    Patricia Tong
    Patricia Tong
    5 years ago

    Attended MS Excel 2013 Intermediate and Advanced levels. IT Trainer Ms Asha was patient and knowledgeable. Her lessons were conducted systematically. Additionally, their Project Coordinator Ms Huyen took efforts to text reminder a day before; kept the place neat and clean; and making sure refreshments were ready and adequate.
    alex koh ming
    alex koh ming
    3 years ago

    BEST EXCEL TRAINING
    Jacqueline Lee
    Jacqueline Lee
    2021-09-22

    Went for a accounting course, Steven was friendly and helpful
    Wenyan Yeo
    Guido Sudero
    2021-09-01

    The course was effective for my purpose, the Teacher was clear and professional and she covered all the various aspects in an extensive and careful way. Then, the follow up they do, sending the course material to all Students is also good. Indeed a good Excel course for a beginner.
    Ken Cheong
    THIRUMALA DEVI
    2021-09-15

    Here i attended two courses. The Teacher is more knowledgeable person. I attend here accounts and Corporate Tax Singapore courses. really ill recommend this institute.
    Josephine Low
    Lachu Gandhi
    2021-09-07

    Content of the course is appropriate. Trainer valene was very good and interactive. The place, course materials, the presentation and content of the material everything were clear and precise and she gave proper response to the queries raised. The place is well maintained too. Overall, a good experience and sure, I will recommend inspizone to my friends who are keen on upgrading themselves.
    shengwei tan
    shengwei tan
    2021-07-01

    Stella is a great lecturer, the lesson taught are well orderly manner for each day which preps in beforehand and learning better.
    Chiqui Ehong
    Grace CH Ong
    2021-06-11

    A very useful course with laptops provided and sample datasets for our training. Training was very well-paced and clear, helpful for learning. Trainer also was happy to go around assisting when needed and managed queries well for us. Happy to have participated in a course at Inspizone 🙂

    Related Courses