Intermediate Excel

Event Details

Date: 
Tuesday, 20 August, 2019 -
09:30 to 16:00

Location: Carrowbreck House, 7 Carrowbreck Road, Hellesdon, Norwich, NR6 5FA.

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.

Duration: One-day course (9:30am – 4:00pm approximately)
Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available.
Lunch provided: For full day training courses a sandwich lunch with crisps and cakes will be provided. Refreshments will be available throughout the duration of this course.

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
An explanation of different versions

Course price: From £77.00 - £99.00pp For more details or any enquiries, please do contact us on 01603 788950, or email carrowbreck@broadland.gov.uk

Gold Patrons