Pantone-01.png)
IT Literacy − Basic Microsoft Excel
ITE College Central
Short Courses
Information Technology
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.
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.
STEP* will be used to administer all ITE Continuing Education & Training (CET) courses starting from 1 April 2024 onwards. For first-time users of STEP, please register and sign in here.
*STEP – Skills Training & Enhancement Portal, the new one-stop learning portal to manage all courses and learning needs across the 5 polytechnics and ITE.
Want to find out more about our courses?
Related courses
IT Literacy − Basic Microsoft Word