Excel - Smarter Excel

$170 Limited GST free
Excel - Smarter Excel

Take your Microsoft Excel skills to the next level and increase your efficiency and productivity at work. Gain confidence as you expand your knowledge of this software in a small and personalised

...
$150 Limited GST free
Excel - Smarter Excel

Take your Microsoft Excel skills to the next level and increase your efficiency and productivity at work. Gain confidence as you expand your knowledge of this software in a small and personalised

...

If there isn't a class to suit you, please the waiting list.

Take your Microsoft Excel skills to the next level and increase your efficiency and productivity at work. Gain confidence as you expand your knowledge of this software in a small and personalised class. A course for the competent excel user who would like to understand and use the smarter features of Excel 2013.


IN THIS COURSE YOU WILL LEARN

  1. An overview of relative referencing and absolute referencing
  2. How to link multipage documents
  3. How to write VLOOKUP formulas and IF statements
  4. How to protect data
  5. How to use the subtotal function including date, logical, mathematical, simple nesting and statistical functions
  6. How to create pivot tables and pivot charts and split screen operations
  7. How to use the solver function
  8. How to record macros and work with recorded macros
  9. Develop a linked spreadsheet solution – spreadsheet design using software functions and formulae and format cells using data attributes
  10. Develop, edit and use templates to ensure consistency of design layout;
  11. Use spreadsheets – enter, check and amend data; import and export data; preview, adjust and print; name and store spreadsheets
  12. Represent numerical data in graphic form – styles of graph, create graph with labels; save, view and print graph


Please note: This training will be delivered on Personal Computers in our computer room with a Microsoft Windows 10 environment. We do not provide Mac computers but you’re welcome to grab your MacBook and come along, however the tutor will not be able to solve technical problems in class. If you wish to BYO laptop, please make sure it is fully charged.


PRE-REQUISITES
Assumes a basic understanding of the internet as well as basic knowledge of personal computers and the Windows operating system. This course is intended for people who have completed an Intermediate Excel course OR have the capability to develop intermediate level spreadsheet skills independently without support. This course is intended for people who have a 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 involving class room demonstrations; discussions; practical tasks; group activities; Q & A and one-on-one support.

Related Courses