Book your training online... 1000's of courses, 100's of locations, 1 website!

Less

COURSE FINDER

or

Booking Enquiry

Microsoft Excel for Data Analysis - Online Classroom

£305 per delegate

Duration: 1 day

Trainer: WC315P

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

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

- Group and Outlining
- 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

- Working with Tables

- Working with Records and Fields

- Working with Tables and Filters

- Using Excel as a Database

Your Enquiry

Please select expected number of delegates

VCode

I am interested in...

In-Company/Own Venue Open Course All Course Types

Enquiry

Please enter your enquiry details below and leave the rest to us. Need different dates or venue? No problem! Please remember to include:
- Preferred dates
- Preferred location(s)

Your Details

Name

Company Name

Email

Telephone

Mobile

Postcode

Address

City

County

Country

What happens next?
Once you have clicked above and sent us your enquiry, our team of advisors will then review your specific needs and email the details that best suit you. We may need to contact you to clarify requirements prior to processing the enquiry.

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

Email Enquiries

enquiries@bookmycourse.co.uk

GET A QUOTE