Microsoft Excel 3 Levels

by Seed Training & Seed Career Claim Listing

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.

$495

Contact the Institutes

Fill this form

Advertisement

Seed Training & Seed Career Logo

img Duration

3 Months

Course Details

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.

  • Melbourne Branch

    Suite 2, Level 1/16 Lakeside Dr, Melbourne

Check out more MS Excel courses in Australia

New Horizons Learning Centre Logo

Visio Training

Simplify complex information by creating professional, versatile diagrams in just a few clicks. Visio provides new features to help you and your team create diagrams and share data-linked diagrams with more ease.

by New Horizons Learning Centre [Claim Listing ]
Employment and Training Australia Logo

Microsoft Word

We tailor these programs to suit your needs. If you are an individual looking for basic to intermediate training in Microsoft Word, Excel or Outlook we can assist. If you are an organisation looking for basic to intermediate training for a group of people in Microsoft Word, Excel or Outlook we can ...

by Employment and Training Australia [Claim Listing ]
Class Training Logo

Word Course

This Course Is Delivered As A 1-day Hands-On, Face-To-Face Session

by Class Training [Claim Listing ]
Easy PC Traning Logo

Microsoft Word Essentials

Those who want to be able to produce short, simple documents quickly and easily using a wide range of formatting tools.

by Easy PC Traning [Claim Listing ]
WiseClick Training Logo

Introduction To Excel

This short Introduction to Excel session will give you the confidence to move around the Microsoft Excel 2010 software and understand the basics of formulas, calculations and layouts. You will be guided by a skilled and patient trainer in a one on one session.

by WiseClick Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy