Advanced Excel

Event Details

Date: 
Monday, 16 December, 2019 -
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

Course price: £77.00 - £99.00

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

Gold Patrons