Microsoft Excel Intermediate

Suitable for: Existing Excel users who wish to use the advanced features of this package. The course starts by refreshing the layout and efficient navigation techniques fundamental to newer versions of Microsoft Office. It then quickly advances to include detailed coverage of additional features.

Objectives: Extend the users knowledge of formulae. Apply appropriate Data Validation rules to speed-up data entry and improve accuracy. Consider additional tools to assist in summarising and analysing data. Sort and filter lists. Create and modify graphs/charts in Excel. Link cells in multiple worksheets.

Course Content:

SECTION 1 – Data Entry - Time Savers

AutoCorrect

Entering Numbers

Faster Data Entry with Autofill

Create your own Custom Lists

Text to Columns

Flash Fill

Cell Notes / Comments

Data Validation -Settings -Input messages - Error Alerts

Tips for working with data validation

Add data validation to a cell or range

Restrict data entry to values in a drop-down list

Restrict data entry to a whole number or decimal numbers within limits

Restrict data entry to a date or time within a time/date frame or to a specified length

Copy data validation settings

SECTION 2 -Working with and Presenting Data

Freeze panes to lock specific rows or columns

Sorting Data, text, numbers, dates, times

Sort by cell colour, font colour, or icon

Sort by more than one column

Sort rows

Filtering Data

Apply a Filter to text, numbers, dates or times

Filter for top or bottom numbers, above or below average numbers

Filter for blanks or nonblanks

Filter by cell colour, font colour, or icon set

Determine if a filter is applied, clear a filter or filter for unique values

View two worksheets in the same workbook side by side

Subtotals -Show or hide outlined data, copy outlined data

Remove subtotals

Charts

Sparklines

SECTION 3 – Formulae

Multiple worksheets in Excel

Formulae linking different cells in multiple worksheets

Formulae

Create a formula by using cell references or a function

Absolute References -Switch between relative, absolute, and mixed references

This is a sample course outline. We tailor every one of our workshops to suit your company's individual needs.