Thanks for adding:

Proceed to Checkout

Continue browsing

X

Advanced Excel 2013

$170 Limited GST free
Advanced Excel 2013

<p>In this Advanced Excel course, you will continue to develop skills to design and develop complex spreadsheets using some of the more advanced features and tools such as: templates, data import and

...
$170 Limited GST free
Advanced Excel 2013

<p>In this Advanced Excel course, you will continue to develop skills to design and develop complex spreadsheets using some of the more advanced features and tools such as: templates, data import and

...

In this Advanced Excel course, you will continue to develop skills to design and develop complex spreadsheets using some of the more advanced features and tools such as: templates, data import and export, linked formulae, multipage documents, pivot tables, relative and absolute cell references, date functions, logical functions (such as lookup, if etc), simple and nested functions.


Please note: This training will be delivered in a computer room in a Microsoft Windows 10 environment – we do not provide Mac courses. Please make sure you select courses and enrol at the level appropriate to your skills and needs. NO REFUND and NO TRANSFER if you enrol in the wrong course.


PRE-REQUISITES
Completed Intermediate Excel or have the capability to develop intermediate level spreadsheets independently without support. This course is intended for people who already have good knowledge of Excel and want to develop advance skills in producing complex spreadsheets.


LEARNING PATHWAY
The learning pathway shall consist of face-to-face delivery of 6 hours involving class room demonstrations; discussions; practical tasks; group activities; Q & A and one-on-one support.


PLANNED LEARNING OUTCOMES
Upon the completion of this training, students will be able to:

  1. Prepare to develop spreadsheet – workstation ergonomics, tasks and specifications analysis; organisation requirements
  2. Develop a linked spreadsheet solution – spreadsheet design using software functions and formulae; link spreadsheets; format cells using data attributes, relative and absolute cell references; test and confirm formulae; including – multipage documents, pivot tables and split screen operations, date functions, logical functions, mathematical function, simple nested functions and statistical functions
  3. Automate and standardise spreadsheet operation – create, use and edit macros; develop, edit and use templates to ensure consistency of design layout;
  4. Use spreadsheets – enter, check and amend data; import and export data; preview, adjust and print; name and store spreadsheets
  5. Represent numerical data in graphic form – styles of graph, create graph with labels; save, view and print graph