Excel Data Analysis for modern managers

Course summary

Make it easy to spot trend and key values in data quickly. Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data. These Excel skills are common tools that data scientists depend on to gather, transform, analyze, and visualize data.

Course Description

Working with sheets and files, calculating using multiple sheets or files, getting trends over sheets of files, linking files for auto-updating of values
Working with Names and Ranges, to simplify cell-referencing and copying of form
Working with Array Formulas
- getting a range of results (for each value in a range)
Working with Tables/Database:
- Working with Records and Fields
- Working with Filters
- Sorting Data
- Conditional Formatting
- Data Validation to maximise accurate user input
- Finding errors and formulae to clean data (Trim, Left, Right, Iferror, Ifblank, etc), remove duplicates
- Custom lists and using drop lists in cells
Subtotals, Group, Outline
Cross Referencing data:
- Hlookup
- Vlookup
- Match, Index
Function wizard for statistical functions:
- If,
- Sumif(s), Averageif(s), Countif(s)
- Dsum, Daverage, Dcount
For large dataset, organising columns, remove or add columns, filter relevant records:
- Advanced Filter
- Setting up criteria
- Using Wildcards
Summarising and categorising data and finding trends:
- Pivot Tables
- Pivot charts

What is included:

You can bring your own Laptop - let us know beforehand
You canbring your own data and examples - let us know beforehand
Refreshments: Tees, coffees and light refreshments, but no lunch
Certificates: You will get attendance certificates
Notes: You will get brief course notes
On-site support: 1-hour consultation after the course, bookable, online, on-site or at our office

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher

Starting Next 10 dates Oct 2017 Nov 2017 Dec 2017	How long	Where	Price

Mon 30th Oct 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Tue 31st Oct 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Wed 01st Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Thu 02nd Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Mon 27th Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Tue 28th Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Wed 29th Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Thu 30th Nov 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Fri 01st Dec 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Wed 27th Dec 11:00am - 6:00pm	1 Day Part time day	London, WC2N 5BY Map Trafalgar Square, London Connections , London, WC2N 5BY We book excellent training rooms at this location Room name 8 Northumberland Avenue, London WC2N 5AP;	~~£290.00~~ 17% off £240.7 per course	> Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

Book now Buy a course voucher Buy a course voucher This makes a great gift for someone, or if you know you want to do the course but don't know when yet. This is a voucher for the price of this course at this venue, but which allows you to attend at a date that you will agree with the course provider any time in the 12 months after purchase. It gives you the flexibility to buy now and arrange later.

View more start dates: