Take Your Analytical Skills To The Next Level and Boost Your Career
Want to experience tracking your expenses, visualizing data, or recording employee headcount with ease, the Microsoft Excel Training will enable you do this like a pro! This course will help strengthen your Excel Fundamentals and take you from basics to advanced concepts. You will receive hands-on practical learning through exercises & projects.
Enhance your understanding of Microsoft Excel and make analysis look easy. You will work on rows, cells, columns, drop-down lists, filters, pivot tables, and much more. By the end of this course, you will have job-ready skills that you can confidently showcase at your workplace.
Data is all around us, and finding a way to manage it and extract valuable insights from it has become the major goal of organizations around the world. Skilled employees who can analyze the data quickly and efficiently are in high demand for their analytical skills and earn an average annual net salary of $70K-$77K.
Who Should Attend This Course
- Students
- Professionals
- Anyone who wants to advance their Excel skills
The KnowledgeHut Edge
Brilliant Track Record
KnowledgeHut has empowered over 350,000 professionals with certifications in various domains.
Industry-Relevant Curriculum
Learn from the most up-to-date curriculum designed keeping industry needs and the latest technologies in mind.
Work-Like Experiences
Gain real-world experiences through projects and build a job-ready portfolio worthy of top companies.
Learn from Industry Experts
Engage with certified instructors with a wealth of industry experience and mastery over the subject.
Purpose-Based Learning
Go beyond theoretical or practical knowledge and understand the ‘what’, ‘why’, and ‘how’ of things.
Continual Learning Support
Strengthen your learning with self-paced videos, hands-on exercises, assignments, recall quizzes, and more.
Curriculum
Learning Objectives:
Discover various basic features of MS Excel that are related to design, data access, and functions. You will be able to understand the concepts with the help of appropriate demonstrations.
Topics
- What are Rows, Cells, and Columns?
- 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
Learning Objectives:
MS Excel provides various options for formatting the data. You will learn to implement various formatting options, which help you segregate and present the data clearly. Also, you can apply conditional formatting options and create your own style of formatting.
Topics
- Understand the Formatting Techniques
- Data Type Formatting
- Formatting Techniques on Rows and Columns
- Conditional Formatting
Learning Objectives:
Since MS Excel is a software that helps you deal with large amounts of data, there are various basic and advanced formulas/functions related to text, date, and Maths. You will learn to apply them and handle enormous data manipulations, quickly.
Topics
- Text Functions
- Date Functions
- Basic Excel Formulas
Learning Objectives:
MS Excel helps you perform real-time analysis with statistics available in various fields. You will be able to calculate the statistical indicators, such as Mean, Mode, Median, Standard Deviation, Variance, and Interquartile Range.
Topics
- Measure of Central Tendency
- Measure of Spread
Learning Objectives:
Describe some more advanced concepts of MS Excel and implement them to enhance your data presentation.
Topics
- Dependent Drop-down Lists
- Filters in Excel
- Pivot Tables
Learning Objectives:
For the final capstone project, you will interpret the given dataset, and perform various tasks based on the concepts that you learned throughout the course.
Topics
- Interpret a given dataset and perform various tasks
What You Will Learn
1. Introduction
Get a detailed understanding of rows, cells, columns, and various data types and learn about different tabs
2. Cell References
Learn how to use cell references in a formula, and how to create a reference of one or more cells in Excel
3. Formatting in Excel
Learn how to implement various formatting options for font, alignment, numbers, dates, and more
4. Functions
Apply conditional formatting and understand basic and advanced functions related to different data types
5. Measures of Spread
Understand the measure of spread and learn how to calculate the variance, standard deviation, and IQR
6. Working with Data Sets
Learn how to calculate the mean, median, and mode of a data set and interpret these value
Prerequisites
There are no prerequisites for this course.
Utilise your SkillsFuture Credit And Claim UTAP Support
Talk to a Course CounsellorGet 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)
|
Microsoft Excel |
||
| 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)
- $500.00
- $45.00
- $545.00
-
Singapore Citizens & Permanent Residents
(40 years and above)
- $500.00
- $45.00
- $545.00
* Note:
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount to be paid to training provider first and claimed after end of class by learner.
- Singaporeans aged 25 and above can use their SkillsFuture Credit (SFC) to pay. For more details, visit www.skillsfuture.gov.sg/credit.
Microsoft Excel
Individuals
-
Singapore Citizens & Permanent Residents
(39 years and below)
-
Course Fee (Before GST)
$500.00 -
GST (Full Course Fee, 9%)
$45.00 -
Course Fee + GST
$545.00 -
Unfunded Course Fee with GST
$545.00
-
Singapore Citizens & Permanent Residents
(40 years and above)
-
Course Fee (Before GST)
$500.00 -
GST (Full Course Fee, 9%)
$45.00 -
Course Fee + GST
$545.00 -
Unfunded Course Fee with GST
$545.00
* Note:
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount to be paid to training provider first and claimed after end of class by learner.
- 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 Microsoft 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?
reviews on our popular courses
Excellent program! Well-structured, knowledgeable trainers, and great job assistance. Highly recommended for a rewarding AWS career!
Samantha Johnson
DevOps Engineers
Highly recommended! Well-rounded curriculum, experienced trainers, and game-changing job assistance. Secured a job as an AWS Developer. Excited about my career prospects. Thanks, KnowledgeHut!
Sara Wilson
AWS Developer
The learning methodology put it all together for me. I ended up attempting projects I’ve never done before and never thought I could.Â
Lea Kirsten
Senior Developer
5 stars, What a totally awesome Data Science bootcamp! I tried learning on my own through text books and online material, but it was such a struggle as I had no one to clear my doubts. Knowledgehut has brought out a totally different and interactive, comprehensive, logical systematic approach to the subject that made it super fun to learn. Love all your courses(This is my fifth!).
Neil Radia
Enterprise Sales Executive
The learn by doing and work-like approach throughout the bootcamp resonated well. It was indeed a work-like experience.Â
Matt Connely
Full Stack Engineer
KnowldgeHut's training session included everything that had been promised. The trainer was very knowledgeable and the practical sessions covered every topic. World class training from a world class institue.
Prisca Bock
Cloud Consultant
This is a great course to invest in. The trainers are experienced, conduct the sessions with enthusiasm and ensure that participants are well prepared for the industry. I would like to thank my trainer for his guidance.
Barton Fonseka
Information Security Analyst.
I am really happy with the trainer because the training session went beyond my expectations. Trainer has got in-depth knowledge and excellent communication skills. This training has actually prepared me for my future projects.