Categories:
Microsoft Excel Training
£295 per delegate. This may be less for special offers on specific course dates and in-company training courses
Duration: 1 day
Trainer: WC315P
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Course Aims
This course is to help you use Excel with large spreadsheets in database format
Good for people who are using Excel to analyse their data with Excel
- Working with Tables
This course is to help you use Excel with large spreadsheets in database format
Good for people who are using Excel to analyse their data with Excel
Pre-Requisites: Beginners course
Course Outline
Course Outline
Working with Functions and Formulas
- Using Formulas in Excel
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
Working with Array Formulas
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
Working with Array Formulas
- Group and Outlining
- Hiding rows and columns
- Vlookup, Hlookup, Match, Index, Indirect
- Subtotals
- Pivot tables:
- Hiding rows and columns
- Vlookup, Hlookup, Match, Index, Indirect
- Subtotals
- Pivot tables:
- Importing Pivot Table Data- Calculated Fields in Pivot Tables- Showing Pivot Data as a Percentage- Creating Custom Pivot Tables Styles
- Pivot Charts
- Sumif, Averageif, Countif
- Criteria Ranges
- Copy To/Extract
- Dsum, Dcount,Daverage
Managing Tables
- Sumif, Averageif, Countif
- Criteria Ranges
- Copy To/Extract
- Dsum, Dcount,Daverage
Managing Tables
- Working with Tables
- Working with Records and Fields
- Working with Tables and Filters
- Using Excel as a Database
| Location | Region | Start Date | Days | Price ex. VAT | ||
|---|---|---|---|---|---|---|
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 5 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 5 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 5 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 5 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 12 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 12 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 12 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 12 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 19 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 19 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 19 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 19 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 26 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 26 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 26 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 26 Mar 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 9 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 9 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 9 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 9 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 16 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Fri 16 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Fri 16 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Fri 16 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Fri 23 Apr 21 Single day duration, date as indicated. | 1 | £295 + VAT | BOOK | ENQUIRE |
| Courses found 1 to 25 of 48 | 1 2 Next | |||||
Click location to see venue
|
Move cursor over calendar icon to see course dates
|
|||||
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2021 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy