Excel Intermediate

Duration:

One Day

Aims:

This one-day training course aims to give basic users of Excel knowledge of commands and functions which will make them more proficient in spreadsheet design and development. How to apply these tools to solving their own business problems and good spreadsheet practice will also be covered.

Prerequisites:

A working knowledge of Excel gained from prior attendance on an Apt Training Microsoft Excel Introduction course or from a user environment.

Revision
  • Excel Introduction
  • Revision exercises
Functions
  • Date function
  • IF function
  • Integer function
Cell Addressing
  • Absolute cell addresses
Conditional Formatting
  • Applying conditional formats to text
Database Features
  • Using a spreadsheet as a database
  • Sorting data
  • Basic subtotals
  • Filtering data with AutoFilter
  • Custom AutoFilter
  • Data form
Lookup Tables
  • Creating lookup tables
Working with Multiple Sheets
  • Selecting sheets
  • Inserting & deleting sheets
  • Copying sheets
  • Copy and paste between sheets
  • Naming sheets
Working with Multiple Workbooks
  • Opening multiple workbooks
  • Arranging windows
  • Linking workbooks
  • Linking worksheets
  • Workbook passwords
  • Worksheet protection
Additional Features
  • Inserting comments
  • Editing comments
  • Printing comments
Charting
  • Revision of basic charts
  • Chart types
  • Sizing and moving a chart
  • Editing a chart
  • Changing chart data
  • Formatting chart elements
  • Drawing features
  • Printing a chart