By the end of this course delegates will be able to keep detailed records in Excel. They will be able to sort and filter data. They will be able to summarise that data into meaningful reports. They will be able to create their own functions as well as recording simple Macros in order to automate their spreadsheets.

• Creating a List & Maintaining a List
• Using the Data Form
• Sorting & Filtering a List
• Using Subtotals in a List
• Creating a User Defined Function
• Creating Pivot Tables & Pivot Chart Reports
• Using Goal Seek & Solver
• Using Scenario Manager
• Recording and Using Macros

Classroom Training

This course is delivered as classroom training for a group of up to 8 delegates. It is held in Hatfield, easily accessible by road from areas like Harlow, Luton, St. Albans, Barnet, Stevenage, Letchworth and Welwyn Garden City. Hatfield is approximately 25 mins by train from London's Kings Cross station and on a direct route from London's Moorgate station.