Advanced Excel

Event Details

Date: 
Monday, 26 June, 2017 -
09:30 to 16:00

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

This course develops many of the most useful aspects of Excel such as formulas and functions, list management, and more advanced features including Pivot Tables and summarising data across multiple sheets or books. Trainees will have completed the introduction course or have a similar knowledge and experience of using Excel in the workplace.

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 lunch with sandwich or salad, crisps and cake or fruit will be provided. Refreshments will be available throughout the duration of this course.

Course Content
Review
Brief review of general Excel principles:
Formulas, Functions, Absolutes, Formatting, AutoFill
Functions
Using Paste Function
The IF Function
Nested IF Functions
The VLOOKUP Function
Nesting other Functions
Linking Multiple Sheets and Workbooks
Summarising data from multiple sheets
Working with 3D Formulae
Linking workbooks
Workspaces
List Management (Databases)
Sorting
Subtotals
Filtering
Good Working Practice
Pivot Tables
Creating pivot tables with the Pivot Table Wizard
Formatting pivot tables
Manipulating pivot tables
Graphs/Charts
Creating a graph/chart
Formatting a graph/chart
Changing and editing your graph/chart
Using the Chart Wizard
Incorporating a chart into a Spreadsheet
Macros
Recording a simple macro
Assigning a macro to toolbar buttons
An explanation of different versions
How to find familiar commands in the
2003 & 2007/10 interface

Course price: £72.00 - £94.00

For more details or any enquiries, please do contact us on 01603 788950, or email carrowbreck@broadland.gov.uk

Gold Patrons