IT Literacy − Basic Microsoft Excel
Course Details Anchor Navigation
Overview
Type of course
Short Courses
Campus where course is offered
ITE College Central
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.
Fee for this course can be paid using SkillsFuture Credits. Visit www.skillsfuture.gov.sg/credit for more information.
More Details / Apply
Explore other Info-Communication, Computing & Networking courses
*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.
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.
Want to find out more about our courses?