Microsoft Excel 3 levels
current icon CURRENT
online icon Online
Start Anytime
Industry Recognised
Workplace Simulation
Price: $495
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

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

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.

TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Download Course Brochure