IT Literacy − Basic Microsoft Excel

Course duration: 7 hours

Boost your productivity by learning the essentials of Microsoft Excel. This beginner course will give you the skills to work confidently with spreadsheets, from creating and formatting workbooks to using formulas and functions. At the end of the course, you will be able to organise and analyse data. 

What you'll learn

Understanding Excel workbooks

• Create, save and open Excel workbooks

• Share your workbooks with others

Working with cells and sheets

• Learn cell basics and how to modify columns, rows and cells

• Format cells and understand number formats

• Work with multiple worksheets

• Use Find & Replace and spelling check

• Set up your page layout and prepare for printing

Formulas and functions

• Create and use formulas

• Understand relative and absolute cell references

• Use basic Excel functions

Working with data

• Sort and filter data

• Create tables, charts and pivot tables

• Learn how to use VLOOKUP for data analysis

Entry requirements

Participants should be able to use the computer, mouse and keyboard and are familiar with Windows environment.

Fees

Fee for this course can be paid using SkillsFuture Credits.

Want to find out more about our courses?

Connect With Us!

Related courses

IT Literacy − Basic Microsoft Word

IT Literacy − Basic Microsoft Powerpoint

IT Literacy − Google Drive Apps (Basic)