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

Seed Training & Seed Career Logo

Microsoft Word 3 Levels

Learn to create professional documents, reports, and newsletters confidently by using efficient features such as forms and fields, text manipulation techniques, etc.

by Seed Training & Seed Career [Claim Listing ]
NextTech Learning Logo

Access 2016

The skills and knowledge acquired in Microsoft Access 2016 - Level 1 are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

by NextTech Learning [Claim Listing ]
Trainers Direct Logo

Microsoft Visio

Trainers Direct offers professional onsite Visio training courses for groups and individuals. Simplify complex information by creating professional Visio diagrams with our 1 day Visio Essentials course.

by Trainers Direct [Claim Listing ]
Mobile Mouse Logo

Microsoft PowerPoint Course

The Ultimate Microsoft PowerPoint Course in Perth. Discover our World Class Microsoft PowerPoint Training from Perth that teaches students how to correctly build and format PowerPoint Presentations and Templates with ease

by Mobile Mouse [Claim Listing ]
AMC Training Centre Logo

Microsoft Outlook

Outlook is a powerful business tool allowing you to send emails, plan and organise yours and other team member’s time in the calendar, keep on top of your work by scheduling tasks, and have all your contacts at your fingertips! Save time and increase your productivity by getting to really know th...

by AMC Training Centre [Claim Listing ]

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