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. Equipment: No equipment is necessary for you to bring to the course. Pens and note paper will be available. Lunch provided: Lunch and refreshments will be provided throughout the 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 costs range from £77 – £99 per person. For more details please contact us at [email protected] or on 01603 788950. Link to book – www.southnorfolkandbroadland.gov.uk/training