Who Should Attend: Existing users who wish to learn how to use many of the functions available within Excel. This course deals primarily with gathering and extracting information.

Pre-requisites: Delegates must be able to produce a spreadsheet containing simple formulae. Understand the difference between absolute and relative cell addresses.

Course Objectives: At the end of this one day course the user will be able to build complex calculations with VLookup and nested IF, AND, OR statements. Produce a database within Excel and sort, subtotal and pivot the data.

Course Content
Logical Functions: Create and editing formula using If, And, Or statements. Use nested If statements as part of a calculation. Understand SumIf, CountIf, Isnumber and Isblank.

Lookup: Use Index and Match to pinpoint the location of an item within a large range of cells. Use Vlookup and Hlookup to extract information. Mix Vlookup and If statements with Isblank to produce an invoice.

Consolidation: Gather data across worksheets using the consolidation feature to sum or average information.

Databases: Create and edit a database in Excel. Sort data and use the subtotal tool. Use Autofilter and Advanced filter to extract information.

Text functions: Split information across columns. Use Left, Right and Concatenate to extract and join text from cells.

Pivot Tables: Create and edit a pivot table to manage information. Create a chart based on the pivot table data. Extract data from the pivot table.

Related courses
Getting Started with Word
Adobe Acrobat
Getting Started with PowerPoint