Book now

Excel Intermediate Course, Private 1-to-1

Course summary

This Excel course is offered one-to-one or in small group of up to 4, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe many questions daily and want to be more proficients.

Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours

Course Outline

Working with Functions and Formulas

  • Creating Formulae in Excel, general calculations
  • The Function Wizard
  • Using Functions in Excel: The 5 Popular functions
  • If- function
  • Working with Names and Ranges
  • Copying formulae
  • Lookups - Vlookup, Hlookup, Index, Match

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Filters and Sorting, Freeze panes, split, protecting and unprotecting
  • Using Excel as a Database- Advanced filter

Pivot-tables

  • Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, Refresh Data.
  • Pivot Charts

Adding the Finishing Touches

  • Adding Comments
  • Using Themes
  • Adding Text Boxes

Charts and Sparklines

  • Adding and Editing Charts
  • Adding and Editing Sparklines

Adding Graphics

  • Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes

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

Mon 27th 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

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

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

Mon 27th Nov
11:00am - 6:00pm

1 day
Part time day
Milton Keynes,
MK9 2UB
Map

£290.00 30% off
£203
per course

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

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
Portsmouth,
PO6 3EZ
Map

£410.00 30% off
£287
per course

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

Tue 28th 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

Tue 28th Nov
11:00am - 6:00pm

1 day
Part time day
Milton Keynes,
MK9 2UB
Map

£290.00 30% off
£203
per course

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

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

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

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
Portsmouth,
PO6 3EZ
Map

£410.00 30% off
£287
per course

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

Wed 29th 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

Wed 29th Nov
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£290.00 30% off
£203
per course

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