Microsoft Excel 3 levels - Seed Training and Seed Career

ABOUT THE COURSE

Offered in Beginner, Intermediate and Advanced levels. 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.

UNITS

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

UPON COMPLETION

This course is eligible for CPD hours. Upon successful completion of all the required units of this course, students will receive a certificate of completion.

CAREER OPPORTUNITIES

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

DURATION

Up to 3 months per module

Up to 12 months per package

ASSESSMENTS

Case studies

ENTRY REQUIREMENTS

There are no formal education entry requirements.

EQUIPMENT NEEDED

A computer with internet and web browser access
Word/text processing, spreadsheet, and presentation software installed (e.g. Microsoft Office)
PDF reader

OTHER RELEVANT COURSES/PATHWAY

Microsoft PowerPoint 3 levels

Microsoft Word 3 levels

Business English

Internship Placement

FEE INFORMATION

Fees must be paid within 5 days of receiving the confirmation of enrolment and invoice for the enrolment fee.
Seed Training Group may cancel enrolment or discontinue training if fees are not paid as required.
Both direct deposit and credit card are accepted.

*Please refer to the Student Information Handbook for further details regarding Fees & Refund Policy and Procedure.