WANT TO FIND OUT MORE?

Download a Free Course Guide Now!

ABOUT THE COURSES

Microsoft Excel

Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application.

This course uses Microsoft Excel 2013.

Module 1 BEGINNER LEVEL

• Getting started with Excel
• Excel selection techniques
• Manipulating rows and columns
• Manipulating cells and cell content
• Sorting a cell range
• Excel worksheets
• Freezing row and column titles within Excel
• Font, number and alignment formatting within Excel
• Excel formulas
• Functions and charts
• Customising Excel

Module 2 INTERMEDIATE LEVEL

• Excel setup and viewing options
• Excel functions and formulas
• Excel time and date functions
• Excel mathematical, logical and statistical functions
• Excel financial, lookup, and database functions
• Excel named ranges
• Excel ell and range formatting
• Advanced worksheet manipulation within Excel
• Excel templates
• Paste special options within Excel
• Proofing and printing

Module 3 ADVANCED LEVEL

• Excel pivot and input tables
• Excel charts and hyperlinks
• Linking within Excel
• Embedding within Excel
• Importing text files into Excel
• Sorting, filtering and totaling data within Excel
• Tracking and reviewing changes in Excel
• Excel scenarios
• Validating within Excel
• Auditing techniques in Excel
• Macros within Excel
• Excel passwords and security issues

What is the course duration?

• Up to 3 months per module
• Up to 12 months per package

What is the price of the course?

• $165 per level

What are the assessments?

• Case studies

Is there any entry requirements?

• No formal education entry requirements.

What can I get after completing the course?

• Upon successful completion of all the required units of this course, students will receive a certificate of completion.

What are the career outcomes of the course?

• Microsoft Excel is an essential skill required in any professional positions.

Download a Free Course Guide Now!

Students can bundle Microsoft Excel course