Categories:
Microsoft Excel Training
£300 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
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 | ||
|---|---|---|---|---|---|---|
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 8 Jul 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 15 Jul 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 22 Jul 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 29 Jul 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 5 Aug 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 12 Aug 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 19 Aug 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 26 Aug 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 2 Sep 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 9 Sep 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 16 Sep 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 23 Sep 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 30 Sep 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 7 Oct 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 14 Oct 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 21 Oct 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 28 Oct 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 4 Nov 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 11 Nov 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 18 Nov 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 25 Nov 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 2 Dec 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 9 Dec 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 16 Dec 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 23 Dec 22 Single day duration, date as indicated. |
1 | £300 + VAT | BOOK | ENQUIRE |
| Courses found 1 to 25 of 25 | 1 | |||||
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).
© 2022 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy