Advanced Microsoft Excel 2021 in Singapore

Become a Pro at Microsoft Excel and start creating efficient worksheets with ease

  • Utilize your SkillsFuture Credit and Avail UTAP Support
  • Live, instructor-led online classes
  • Real-life projects to help you Master Excel 2021
  • Hands-on exercises to supplement classroom learning
  • Work with advanced formulas to create statistical analysis
  • Go from basic to advanced concepts in Excel 2021

What You Will Learn

Make Work Look Easy With Microsoft Excel 2021

Microsoft Excel remains to be the most popular spreadsheet application on this planet and has a ton of benefits for anyone who knows how to use it. It is an incredibly flexible and versatile tool that excels at simple analytics and helps people make sense of numbers. 

Microsoft Excel is easy to use and can perform a wide range of functions, such as identifying trends, organizing data, performing calculations, sorting and cleaning data, and much more. If you want to go beyond the basics of Excel and master the core statistical tasks that will help you as a student or business professional, this Advanced MS Excel 2021 course is for you. 

Our Microsoft Excel 2021 is geared to endow you with practical learning through real-life projects and hands-on exercises that will leave you with immediately demonstratable skills. Go from basic to advanced concepts in Excel 2021 and showcase your analytical talents at your workplace 

Utilise Your SkillsFuture Credit and Claim UTAP Support

Talk to a Course Counsellor

Get Additional Course Fee Support Up to $500 under UTAP  

The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with the objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member, then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).

For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)  

Advanced Microsoft Excel 2021

Individuals
  • Course Fee (Before GST)
  • GST (Full Course Fee, 9%)
  • Course Fee + GST

Unfunded Course Fee with GST

  • Singapore Citizens & Permanent Residents

    (39 years and below)

  • $600.00
  • $54.00
  • $654.00
$654.00
  • Singapore Citizens & Permanent Residents

    (40 years and above)

  • $600.00
  • $54.00
  • $654.00
$654.00
* Note:
  1. UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
  2. UTAP support amount to be paid to training provider first and claimed after end of class by learner.
  3. Singaporeans aged 25 and above can use their SkillsFuture Credit (SFC) to pay. For more details, visit www.skillsfuture.gov.sg/credit.

Advanced Microsoft Excel 2021

Individuals

  • Singapore Citizens & Permanent Residents

    (39 years and below)

  • Course Fee (Before GST)

    $600.00
  • GST (Full Course Fee, 9%)

    $54.00
  • Course Fee + GST

    $654.00
  • Unfunded Course Fee with GST

    $654.00
  • Singapore Citizens & Permanent Residents

    (40 years and above)

  • Course Fee (Before GST)

    $600.00
  • GST (Full Course Fee, 9%)

    $54.00
  • Course Fee + GST

    $654.00
  • Unfunded Course Fee with GST

    $654.00
* Note:
  1. UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
  2. UTAP support amount to be paid to training provider first and claimed after end of class by learner.
  3. Singaporeans aged 25 and above can use their SkillsFuture Credit (SFC) to pay. For more details, visit www.skillsfuture.gov.sg/credit.

Steps to Apply to Claim SFC and Avail UTAP

NTUC Union Members can enjoy 50% unfunded course fee support up to $500 under UTAP. 
Not sure how to get started with applying for UTAP support and claiming SFC? Just follow these simple steps: 


Step 1: Get enrolled
- Enroll into our Advanced Excel Training. 

Step 2: Apply for the SFC claim
- Check out KnowledgeHut’s upcoming schedules and select a workshop on a date convenient to you. An invoice will be issued to you with the fee breakdown.
- Follow this step-by-step process in the MySkillsFuture portal:
a. Login to the MySkillsFuture portal, select the course you’re enrolling into and enter course date and schedule
b. Enter the course fee payable by you (including GST) and enter the amount of credit to claim
c. Upload your invoice and click ‘Submit’
For more details on SkillsFuture Credit and the various approved skills-related courses, visit www.skillsfuture.gov.sg/credit

Step 3: Apply for the UTAP Support 
- Log in to your U Portal account to submit your UTAP application upon completion of the course. 

Step 4: Enjoy your course 
-  Utilize your SFC credits, UTAP support, and skill up! 

Need help with checking your funding eligibility?

Prerequisites
  • There are no prerequisites to attending this course. 
  • Basic knowledge of MS Excel will be helpful. 

Who Should Attend This Course

  • Students
  • Graduates
  • Freshers
  • Professionals
  • Business Analysts
  • Data Analysts
  • Statistics Specialists

The KnowledgeHut Edge

Brilliant Track Record

KnowledgeHut has empowered over 350,000 professionals with skills and certifications in various domains 

Learn from Industry Experts

Interact and engage with certified instructors with a wealth of industry experience and a mastery of the subject 

Advanced Curriculum

Learn from the latest, most up-to-date curriculum, designed with industry needs in focus 

Hands-On Training

Learn with the help of practical individual and group exercises, quizzes, and activities 

Strengthen Foundations

Learn concepts from scratch by learning through step-by-step guidance and detailed feedback 

Continual Learning Support

Choose from monthly webinars, e-books, tutorials and more to strengthen your learning 

Build Excel Proficiency Across Teams

Strengthen your organization’s Excel skills! Aid your team members in maximizing efficiency and gaining critical insights from data. Establish a team of Excel 2021 experts and drive profitability. 

  • Custom Training Solutions 
  • Experiential Learning 
  • Learn by Doing Approach 
  • Immediately Applicable Skills 
  • 500+ Clients
  • Accenture
  • Amazon
  • Capgemini
  • Coca-Cola
  • Cognizant
  • Honeywell
  • HP
  • PWC
  • Huawei
  • IBM
  • JP Morgan
  • Nokia
  • Philips
  • Qualcomm
  • Sony
Talk to our Course Advisor

Curriculum

Topics

  • What are Rows, Cells, and Column
  • Customizing Excel Quick Access Toolbar
  • Common Excel Shortcuts
  • Different Types of Data Types
  • Moving the Cells to Different Position
  • Understand the Menu and Toolbars
  • Use of Function Box
  • Use of Cell Reference and Cell Edits
  • Use of Name Box and Range

Topics

  • Understand the Formatting Techniques
  • Data Type Formatting
  • Formatting Techniques on Rows and Columns
  • Conditional Formatting

Topics

  • Text Functions
  • Date Functions
  • Basic Excel Formulas

Topics

  • Understanding Lists as a Table and Database
  • Sorting Lists
  • Filters
  • Grouping and Outlining Data

Topics

  • Inserting Images in Excel
  • Inserting Shapes in Excel
  • Working with SmartArt

Topics

  • SUM Function
  • AVERAGE Function
  • PRODUCT Function
  • MIN Function
  • MAX Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
  • COUNTIF Function
  • SUMIF(): Adding Only the Cells You Specify
  • COUNTIFS() and SUMIFS(): Counting and Summing
  • IF Function
  • AND Function
  • OR Function

Topics

  • VLOOKUP With Exact Match
  • INDEX and MATCH vs VLOOKUP
  • VLOOKUP With Approximate Match
  • Format as Table
  • Data Model Tool
  • Slicer in Pivot Table

Topics

  • Using Predefined Templates
  • Creating Custom Templates
  • Creating Macros
  • VBA Modules
  • Visual Basic Editor
  • VBA Coding and Scripting

Topics

  • Text to Columns
  • Remove Duplicates
  • Data Validation
  • Find and Replace
  • Data Entry Form

Topics

  • Calculated Fields in Pivot Table
  • Grouping Data with Pivot Table
  • GetPivotData
  • Group and Ungroup 

Topics

  • What-If Analysis: Goal Seek
  • What-If Analysis: Data Table
  • What-If Analysis: Scenario Manager
  • Auditing Formulas

Topics

  • Format as Table
  • Data Model Tool
  • Formatting Pivot
  • Value Fields Setting

Topics

  • Sparklines as Mini Charts
  • Column Chart and Bar Chart
  • Line Chart
  • Pie Chart
  • Area Chart
  • Combo Charts
  • Speedometer Chart
  • PivotChart
  • Creation of Interactive Dashboard
  • Presentation of Final Results

Topics

  • Activation of Data Analysis ToolPak Add-in
  • Descriptive Statistics
  • Histogram
  • Correlation
  • Linear Regression
  • Explanation of Regression Output
  • Muliple Linear Regression
  • Probability
  • Z-scores
  • Download the Results of Statistical Analysis
  • Time Series Analysis in Excel

reviews on our popular courses

Review image

KnowledgeHut's Agile Excellence Master's Program is a game-changer for Agile professionals. The program opened up new career opportunities and increased my earning potential. The practical skills gained improved my job performance. I highly recommend this program to advance your Agile career.

Aiden Gorgio

Project Manager
Attended Agile Excellence Masters Program workshop in June 2023
Review image

KnowledgeHut's Project Management Masters Program offers a clear path for career advancement. The certifications and global relevance of project management skills make it valuable across industries. The program has equipped me with the necessary expertise and boosted my confidence. Job security and growth opportunities are undeniable!

Noah Carter

Project Coordinator
Attended Project Management Masters Certification Program workshop in June 2023
Review image

This 2-day training session helped me widen my knowledge of Scrum methodologies and Agile principles. Everything was well-organized, though it was an online session. My trainer explained the concepts with real-life examples and ensured every participant was on the same page. I highly recommend this course to everyone who wants to become a Certified Scrum Master. Kudos to the team efforts behind this!

Akshay patole

User
Attended Certified ScrumMaster (CSM)® workshop in August 2022
Review image

You can go from nothing to simply get a grip on the everything as you proceed to begin executing immediately. I know this from direct experience! 

Amanda H

Senior Front-End Developer
Attended Full-Stack Development Bootcamp workshop in July 2022
Review image

The learning methodology put it all together for me. I ended up attempting projects I’ve never done before and never thought I could.

Matt Davis

Senior Developer
Attended Full-Stack Development Bootcamp workshop in July 2022
Review image

Knowledgehut is the best training institution. The advanced concepts and tasks during the course given by the trainer helped me to step up in my career. He used to ask for feedback every time and clear all the doubts.

Issy Basseri

Database Administrator
Attended PMP® Certification workshop in January 2020
Review image

I am glad to have attended KnowledgeHut's training program. Really I should thank my friend for referring me here. I was impressed with the trainer who explained advanced concepts thoroughly and with relevant examples. Everything was well organized. I would definitely refer some of their courses to my peers as well.

Rubetta Pai

Front End Developer
Attended PMP® Certification workshop in May 2020
Review image

It is always great to talk about Knowledgehut. I liked the way they supported me until I got certified. I would like to extend my appreciation for the support given throughout the training. My trainer was very knowledgeable and I liked the way of teaching. My special thanks to the trainer for his dedication and patience.

Ellsworth Bock

Senior System Architect
Attended Certified ScrumMaster (CSM)® workshop in February 2020

Have More Questions?

Advanced Microsoft Excel 2021 Course in Singapore

The national personification of Singapore is the Merlion and just like its mascot, the country too embodies diverse characteristics?that of a business leader, futuristic city with sci-fi architecture, mouth-watering delicacies, wide open spaces and an enviable waterfront. From being a fishing village to dominating Asia?s markets, Singapore has come a long way. The skyline today is dominated by skyscrapers that house some of the world?s most renowned companies including CISCO, OCBC, GE, Dell, Microsoft and top companies in the shipping, finance, oil-refining, and engineering sectors. Among its distinctions include being one of the world?s busiest port, top oil-refining centre, the largest oil-rig producer, ship repair services, and according to the World Bank one of the easiest places to do business. And if you think Singapore is all about work then you should know that it is also the world's second largest casino gambling market. Professionals who wish to thrive in their career would find that they can do well here, with certifications such as PRINCE2, PMP, PMI-ACP, CSM, CEH, CSPO, Scrum & Agile, MS courses and others. Note: Please note that the actual venue may change according to convenience, and will be communicated after the registration.