Microsoft Excel 2019

What Skillset do you wish to acquire?

Microsoft Excel Course Singapore

Course Overview

Microsoft Excel Course in Singapore trains learners in the basic concept of spreadsheets and demonstrates the ability to use a spreadsheet application.

Through this Microsoft office training, learners will understand and be able to accomplish tasks associated with developing, formatting, modifying, and using a spreadsheet and standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts. Microsoft Excel 2019 will be used in this training.

This course is Skillsfuture eligible.

Course Synopsis & Objectives

On completion of this Microsoft office Excel course,  each learner will be able to:

  • Work with spreadsheets and save them in different file formats;
  • Choose built-in options such as the Help function within the application to enhance productivity;
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data;
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets;
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas;
  • Format numbers and text content in a spreadsheet;
  • Choose, create and format charts to communicate information meaningfully;
  • Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets;

Course Title

Workplace Productivity using Excel

Course Outline

Course Outline

1. Overview of Module

2. Getting Started

  • Features and uses of a spreadsheet application
  • Start and exit spreadsheet application
  • Create a workbook
  • Open and close a workbook
  • Switch between workbooks
  • Save a workbook
  • The Excel Screen
  • Display Toolbar/Ribbons
  • Use magnification/zoom
  • Set basic options/preferences
  • Use Help function

3. Insert Data and Select Cells

  • Enter text, numbers and date
  • Move around a worksheet
  • Cell selection techniques

4. Edit and Sort Data

  • Edit cell contents
  • Use Undo and Redo commands
  • Use Find and Replace commands
  • Sort data

5. Copy, Move and Delete Cell Contents

  • Use copy/cut and paste
  • Using Clipboard
  • Paste Special

6. Rows and Columns

  • Insert and delete rows and columns
  • Insert and delete cell
  • Modify column width and row heights
  • Freeze and unfreeze rows and column

7. Worksheets

  • Turn on/off display of gridlines
  • Switching between worksheets
  • Select worksheets
  • Insert and delete worksheets
  • Copy, move and rename worksheets

8. Formulas

  • Create formula (Add, Subtract, Multiply, Divide)
  • Using mathematical operators (=, -, *, /)
  • Enter a formula
  • Use cell references in formula

9. Functions

  • Using Functions
  • Use AutoSum
  • Use AVERAGE, COUNT, MAX, MIN, COUNTA and ROUND functions
  • Use Logical function
  • Relative and absolute referencing
  • Display and print formulas
  • Common error messages in formula

10. Formatting

  • Format number and text
  • Using Format Painter

11. Charts

  • Create a chart
  • Move, re-size and delete a chart
  • Edit a chart

12. Worksheet Setup

  • Use the Spell-check command
  • Adjust page options
  • Add Header and Footer
  • Change sheet display options

13. Printing

  • Preview a worksheet
  • Use basic print options
  • Set print area

Who Should Attend This Microsoft Excel Course Course

This course is intended for learners with little or no knowledge of using a spreadsheet application. For more advanced excel course, please visit the Advanced Excel course

Certification

Participants who fulfil all requirements will be certified with a Statement of Attainment (SOA) issued by the SkillsFuture Singapore (SSG).

Assumed Skills

The learner must be able to:

  • operate a Personal Computer, use keyboard and mouse
  • read, write, speak and understand English (Work Place Literacy Level 4 – lower secondary level)

Visit this page for more Microsoft Office courses in Singapore.

Course Feature

Course Feature

Course Provider: Associates Consulting Pte Ltd.
UEN: 200006697N
Course Reference Number: TGS-2023038568
Mode Of Training: Classroom
Funding Validity Period: 27 Sep 2023 – 26 Sep 2025

Microsoft Excel Course Singapore

FULL COURSE FEE$453.60
Singaporean 40 yrs and above$159.60
Singaporean 21-39 yrs / PR$243.60
Duration2 Days

Available in: English

Book Class Now!

Contact Us On Whatsapp

Contact Us Now On Whatsapp
+65 6255 5584

Coursemology
4.9
Based on 87 reviews
powered by Google
Tee AhwenwenTee Ahwenwen
08:50 26 Feb 23
Ms Ashley Shirley wong is a nice and cheerful teacher thanks for today 26feb23 thank you I am wenyi is teachable teacher and i understand everything and enjoying your lesson so much 😊 really appreciate that.
Ben HanBen Han
18:30 03 Jan 23
Coursemology provides a wide range of massage courses with flexible training schedules..Sales manager , Rachel Lip, assisted me quickly and positively with both my course enquiries as well as the registration of my chosen massage course in a fuss free manner..So for my friends out there...If you are looking to enrol for serious massage courses..Coursemology is your recommended choice...RegardsBen Han
Devaghi ATDevaghi AT
00:35 15 Aug 22
The trainers were very Knowledgeable n conducted the session to participants understanding. Friendly n approachable. Motivational approach during practicals. I benefited from Course. Tq, trainers.
Mohd IqbalMohd Iqbal
09:58 24 May 22
My Food and Hygiene course here was superb! Instructor is very helpful to ensure you understand the importance of Cleanliness and Safety in the kitchen. I highly recommend Coursemology.
MattMatt
02:58 12 May 22
Attended the Food Hygiene course at vision exchange. The course sign up and payment process was fast and simple. The instructor was fun and engaging and helpful. Highly recommend this place if you want to get your food hygiene cert.
Joey GanJoey Gan
09:29 24 Apr 22
My sister and I had many questions about the different courses. The staff present including the boss Mr Wee were very patient and friendly to help us. The centre at Toa Payoh was also easy to get to and centre facilities were kept clean and tidy. We have a very good experience.
ting siongting siong
06:05 19 Apr 22
The trainer is patient and able to explain food hygiene and safety concept clearly. She demonstrated the hand cleaning techniques, share industry practices and safety standards with participants.A good training indeed.
js_loader

Coursemology is an online course directory, listing short courses in Singapore to provide information on WSQ courses and SkillsFuture Subsidy to corporates and individuals. We do course listing for training providers in Singapore to improve your employability via skills upgrading and job skills upskilling through skills development courses.

About Us

Training Locations

Olympus Learning Academy

Blk 190 Toa Payoh Lorong 6, #02-514
Singapore 310190

2 Venture Drive Vision Exchange, #07-23 Singapore 608526

NTUC Income Tampines Junction, 300 Tampines Avenue 5 (Opposite Our Tampines Hub) #07-05 Singapore 529653

Mon to Sun : 8:30am to 6:00pm
Closed on Public Holidays