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

Courses


Excel Timesaving Features

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

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreJulAugSepOct
Auckland
31
09
18
28
08
19
30
09
30
Hamilton--
24
29
17
Christchurch--
15
19
18
Wellington
25
08
24
13
29
13
31

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 current users of Microsoft Office Excel who have already mastered the fundamentals covered in our Excel: Essential Skills course.

Our aim is to provide you with the necessary skills to produce well-designed spreadsheets. We will introduce many timesaving features using quick keys and short cuts.

In this course we cover features such as:

  • Reducing the amount of typing by grouping worksheets together.
  • Using formula that evaluate a condition and perform the appropriate calculation.
  • Naming cells to minimize errors in formulae and to remove the need to redo these formulae when you add or remove rows or columns of data.
  • Creating customised number and date formats.
  • Database utilities to quickly generate sub totals, filter lists, and create reports for subtotalling categories from a list.
  • File and data protection to avoid accidental corruption.

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.

This course in conjunction with Excel Essential Skills covers the material examined in the MOS Excel Core Examination.



Prerequisites

Have a thorough understanding of the different shapes of the mouse pointer in Excel.

Have a thorough understanding of formulae including AutoSum, absolutes references, and creating percentages for categories, all of which are covered in our Excel Essential Skills course.

Are able to AutoFill and use the mouse to drag and drop, copy and move.

At Course Completion

This course concentrates on introducing attendees to some of the more productive tools and time saving features of the program. It focuses on how to build accurate spreadsheets that survive changes without errors.

Course Outline


  • Arranging Windows
  • Splitting Panes
  • Hiding Workbooks
  • Best Use of Multiple Worksheets
  • Linking Spreadsheets
  • Naming Cells
  • Conditional Functions
  • Information Functions
  • Financial Functions
  • Conditional Formatting
  • Creating Customised Formats
  • Validating Data in a Worksheet
  • Protecting Workbooks and Worksheets
  • Creating Templates
  • Subtotalling Data
  • Filtering Data
  • Formula Auditing
  • Creating Hyperlinks

 Print this page