Discover how to arrange the top, side and sheet titles on every sheet.

Format quickly with styles.

Clearly identify inputs, processes and outputs.

Keep the settings for a repeat next month.

Apply sheet name, colour and flow conventions.

Discover the six data-sheet types.

Add the standard Guide and Params sheets to every workbook and understand their
benefits.

Work with tables of data

Filter staff data to show records for a particular employee or department.

Put filters to work applying formats and deleting unwanted data.

Subtotal leave data by country and city.

Locate and remove duplicates from staff training data.

Build formula and PivotTable staff remuneration reports

Use formulas to build a standard report in any layout.

Quickly build ad-hoc reports with a PivotTable.

Calculate with date & time

Total hours and minutes worked.

Multiply time worked by a rate.

Calculate the number of working days required to complete a project.

Create a list of working days in a month.

Calculate age and tenure accurately.

Calculate completed years of employment to determine long service leave.

Mail-merge with Word

Create standardised salary confirmation letters with Word from an Excel table of
employees.

Solve formatting problems with merged numbers and dates.

Build organisation charts

Discover the inbuilt organisation chart feature.

Modify an existing organisational chart when an employee¡¯s position changes.

The above agenda covers many different functions. They include: INDEX, SUMIF, COUNTIF,
IF, VLOOKUP, LEFT, MID, TRIM, SEARCH, NETWORKDAYS, DAY, MONTH, YEAR, TEXT and many
more. It also covers many shortcut tips and tricks that can be used in everyday
spreadsheet work.

Prerequisites

Those who have been using spreadsheets for some time and are quite familiar with
the basics of formula construction.

While some sections of this course could fairly be described as 'advanced' we don't
assume you know any of it. There will be other delegates with just the same level
of ability as you have.

A course booking is considered final when received in writing (online, email, fax
or post) by AbleOwl, and can be cancelled up to ten working days before the course.
After that, payment is expected in full and no refund will be given. All cancellations
must be notified in writing, i.e. post, fax or email. Another delegate may
be substituted at any time.