| |
|
|
Microsoft Office Training Surrey: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking.
|
 |
Excel Intermediate Training Course in Surrey |
|
 |
| Excel
Training Surrey > Intermediate Excel
Training Surrey |
Intermediate Excel
Training Content (Excel 2010, 2007,
2003, XP and earlier) |
The Intemediate Excel training course is aimed at delegates who have a basic grasp of excel features but wish to take their skills further.
For pricing click
here
WE COME TO YOU!
We are happy to travel to you anywhere in Surrey without charging travel expenses including: Addlestone, Ashford, Banstead, Bellfields, Camberley, Caterham, Chertsey, Cobham, Dorking, Earlswood, Egham, Englesfield Green, Epsom, Esther, Ewell, Farleigh, Farnham, Godalming, Guildford, Haslemere, Horley, Hurst Green, Hythe End, Leatherhead, Oxted, Redhill, Reigate, Shepperton, Staines, Sunbury-on-Thames, Walton-on-Thames, Weybridge and Woking. |
| 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 functionss
- 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
|
|
|
|
|
|
|
|
|
|
