Microsoft Excel for Data Analysis - Online Classroom
Categories:
Microsoft Excel Training
£305 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 28 Feb 25 Single day duration, date as indicated. |
1 | £305 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 7 Mar 25 Single day duration, date as indicated. |
1 | £305 + VAT | BOOK | ENQUIRE |
| ONLINE CLASSROOM | East Anglia, Midlands, South Central England |
Fri 14 Mar 25 Single day duration, date as indicated. |
1 | £305 + VAT | BOOK | ENQUIRE |
| Courses found 1 to 3 of 3 | 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).
© 2025 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy