AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Excel Optimising

Courses


Excel Optimising

Length: 1 Day    Cost: $410 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreJulAugSepOct
Auckland--
23
15
--
Hamilton--
14
--
31
Christchurch--
11
--
04
Wellington--
01
--
02

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


About this Course

This course is designed for the advanced Excel user and is focused on two areas. One is to use Excel itself more efficiently. The other is to improve the actual performance of workbooks

Our aim is to improve and extend on the skills you already have as well as to provide you with a basis to re-evaluate existing projects.

We will introduce a significant timesaving feature, which is the ability to add some basic automation to your work.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.



Prerequisites

We recommend that students:

First complete our Essential Skills and Timesaving courses,

OR have:

A thorough understanding of formulae.

A thorough understanding of using Excel’s common functions such as Average, Maximum, Count, IF, and so forth.

The knowledge to create and use range names.

A high level of overall knowledge of, and comfort with, Excel

At Course Completion

We work with some of the more advanced features of tools and methods covered in the previous Excel courses. We discuss ways to optimise Excel’s performance when working with large datasets and use the Record Macro functionality to automate repetitive tasks.

Course Outline


  • Sharing a Workbook
  • Selecting the Correct Chart and Data
  • Editing Charts
  • Understanding Series
  • Trendlines and Error Bars
  • Using Formulae in Conditional Formatting
  • Using Formulae in Data Validation
  • Using Formulae in Names
  • Recording Macros
  • Basic Editing of Macros
  • Using Range Names
  • Relative/Absolute Mode
  • Recording AutoSum for a Varying Range
  • Creating Macro Buttons
  • Optimising Workbook Performance

 Print this page