Member Training: Advanced Excel

Location: Carrowbreck House, 300 Drayton High Road, Norwich, NR6 5BJ.

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: From £72.00

For more details or any enquiries, please do contact us on 01603 788950, or email [email protected]