Book now

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 How long Where Price

Thu 30th Nov
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 07th Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 14th Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 21st Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 28th Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Fri 29th Dec
11:00am - 6:00pm

1 Day
Part time day
London,
WC2N 5BY
Map

£290.00 30% off
£203
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher