Member Training: Advanced Excel

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.

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

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