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

Centre for Continuing Education Logo

Microsoft Excel

This short course will extend your knowledge of Excel beyond Microsoft Excel: Level 1 and provide you with the skills and knowledge to produce more effective and productive workbooks. Learn essential functions as well as how to manage list data, cover formulas and function techniques, PivotTables, ...

by Centre for Continuing Education [Claim Listing ]
AMC Training Centre Logo

Microsoft Visio

Visualise, explore and effectively communicate through the use of diagrams, flow charts and drawings and create ‘real’ representation of your complex data that someone other then you can understand.

by AMC Training Centre [Claim Listing ]
Darwin Adult Short Courses Logo

MS Excel (Intermediate: The Next Step)

Step up your Excel game with our intermediate course, designed exclusively for experienced users who aim to streamline their workflow and harness the full power of Excel.

by Darwin Adult Short Courses [Claim Listing ]
Koenig Solutions Logo

MS-030 (Office 365 Administrator Certification Training)

Within organizations of any size, safety and security around users and data are of paramount importance. Without the right user access and configuration settings, sensitive information can be accessed undesirably, causing possible future concerns and data leaks

by Koenig Solutions [Claim Listing ]
CIT Solutions Logo

MS Excel Foundations (Beginner)

For students and professionals who wish to learn the beginning foundations of Excel and develop their skills with guidance and support from a highly skilled and experienced instructor.

by CIT Solutions [Claim Listing ]

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