Excel - Intermediate

Course Details

As a pre-requisite participants are expected to have covered the material in the 1 day Introduction to Excel.

On our courses both keyboard and mouse skills are taught. 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 & GRAPHIC TOOLS

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

MACROS

• Recording and editing basic macro’s
• Macro Buttons creating and editing

MISCELLANEOUS & 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

Venue

Etrain
Level 1
Prime Property House
2 Woodward Street
Corner Lambton Quay & Woodward
Wellington

Dates