Microsoft Excel Training Course

This course develops many of the features of Microsoft Excel. We will look at the most useful elements, including formulas and functions, using Excel as a database and sharing text and data with other applications. Everything will be explained in straightforward terms. It is also an opportunity to iron out any bad habits that you may have picked up.

Delegates are expected to have a reasonable knowledge of basic Excel.

Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. .

Lunch provided: Lunch and refreshments will be provided throughout the day.

Course Content

Review

Brief review of general Excel principles:

Arithmetic formulas

Looking at +, -, * & /

Brackets

BODMAS

Advanced AutoSum

Unusual ranges

Auto-Average/Max/Min/Count

AutoFill

Building Functions

Using the Paste Function dialog

Basic functions

Functions with one argument:

Statistical functions

Absolutes

When/how to use absolute references

Formulas and Functions between Sheets and Workbooks

Summarising data from multiple sheets

Linking workbooks

Advanced Functions

Functions with more than one argument

e.g. the IF Function

Named Ranges

Naming ranges

Navigating using named ranges

Using named ranges in formulas

Natural language formulas

Excel as a Database

Sorting your data

Filtering a list

Useful database features

Good Working Practice

Copy and Paste

Using the Windows clipboard

Paste-Special :–

Linking to other files and applications.

Replacing formulas with data

The Drawing Tools

Auto shapes

Layers

Rotation

Alignment

Grouping

Course costs range from £77 – £99 per person.

Link to book – www.southnorfolkandbroadland.gov.uk/training