Thanks for adding:

Proceed to Checkout

Continue browsing

X

Intermediate Excel 2013

$165 Limited GST free
Intermediate Excel 2013

<p>In this Intermediate Excel 2013 course, you will learn to plan and design complex spreadsheets by using some of the more advanced functions in Excel, including: formatting and reformatting,

...
$165 Limited GST free
Intermediate Excel 2013

<p>In this Intermediate Excel 2013 course, you will learn to plan and design complex spreadsheets by using some of the more advanced functions in Excel, including: formatting and reformatting,

...

In this Intermediate Excel 2013 course, you will learn to plan and design complex spreadsheets by using some of the more advanced functions in Excel, including: formatting and reformatting, formulae, functions, headers & footers, headings & labels, data import and export, auto functions and page layouts. This course is intended for people who have completed a Level 1 course in spreadsheet, or someone who has knowledge of the basic functions of Excel who seeks to know more of Excel at intermediate level, who are responsible for designing and working with spreadsheets under minimal supervision.


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 Excel for Beginners or have good knowledge of Excel at beginners level.


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. Select and prepare resources: ergonomics, WHS at workstation, energy conservation
  2. Plan spreadsheet design: Design spreadsheet to meet organisational needs; readability and appearance; style and layout
  3. Create spreadsheet: data according to design and layout; use functions to format – including: headers and footers, headings and labels, import and export data, multi-page documents and split screen operation; use automatic functions such as auto date, auto correct, auto format, auto text and default settings
  4. Produce simple charts: select chart types and designs; create charts and modify charts
  5. Finalise spreadsheets: Preview, adjust and print; name and store spreadsheet