Excel Intermediate Training Portsmouth & Southampton

Excel

Training

Excel Intermediate Training - all versions covered - Excel 2007, Excel 2003, Excel XP & earlier

Excel Intermediate Training in Portsmouth & Southampton

Formulae

Overview of basic formula and functions

Working with conditional functions:

IF and nested IF functions

IF OR

IF AND

SUMIF and SUMIFS

COUNTIF and COUNTIFS

Conditional functions and array formulas

Working with lookup functions

Using VLOOKUP with lookup tables

Using HLOOKUP with lookup tables

Using MATCH and VLOOKUP to create a two way lookup

Using INDEX and MATCH to create two way lookups

Condtional formatting using values and formulae

Performing Calculations Across Multiple Workbooks/Worksheets

Creating 3D formulae

Using the data consolidation function

Creating Protected Worksheets and Forms in Excel

Protecting a worksheet

Protecting elements of a workbook

Using Data validation to create drop down lists and restrict data

Adding Form controls to a worksheet

Creating a form template

Using Excel's Database Functionality

Filter tables using Autofilters

Creating complex filters using advanced filter functionality

Creating Pivot Tables and Pivot Charts

Generating tables with subtotals

Using the SUBTOTAL function on filtered tables

Using Database Functiions - DSUM, DAVERAGE etc on advanced filters

Saving custom views of your database