Excel - Accelerated Intermediate

As a pre-requisite participants are expected to be familiar with the content covered in the Excel - Accelerated Introduction course. All courses are instructor led, and include comprehensive notes.


REVIEW OF INTRODUCTION

  • Minimising, maximising and arranging windows
  • Cutting and pasting between spreadsheets
  • Linking spreadsheets
  • Consolidating data and using workbooks

DATABASE AND SORTING

  • Sorting rows based on a column
  • Subtotals
  • Outlining
  • Setting criteria and extracting records using Filters
  • Advanced Filter
  • Using the data form
  • Basic functions and function wizard

WORD AND GRAPHIC TOOLS

  • Adding and editing word processing frames
  • Using the drawing tools to add graphic objects

MISCELLANEOUS CONTENT AND TIPS

  • Absolute referencing
  • Freezing columns and rows for easy editing
  • Naming ranges for linking and quick positioning
  • Grouping Worksheets
  • Autofill and Series fills
  • Inserting comments and notes
  • Transpose columns and rows
  • Tips and techniques

Class Details

Venue:

Level 2 Primeproperty House
2 Woodward Street
Corner Lambton Quay & Woodward Street
Wellington

Dates


Dates don't suit? Call or E-mail.