Book now

Excel Formulae for Excel users - ONLINE Course

Course summary

Get to know how to create Excel Formulae. Excel is a very powerful tool and is not always used to it's full potential by many Excel users. Come and spend a useful and fun evening with us. It could change your working life!

Course Description

  • Creating arithmitic calculations and formulae (addition, subtraction, multiply, division, BODMAS, percentage)
  • Copying formula, absolute and relative cell referencing
  • Working with Names and Ranges, to simplify cell-referencing and copying formulae
  • Popular Functions: Sum, Average, Min, Max, Count, Counta, Countblank
  • Cross Referencing data:
    • Hlookup
    • Vlookup
  • Function wizard for statistical functions:
    • If,
    • Sumif(s), Averageif(s), Countif(s)
  • 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 can bring 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

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

2 hours
Part time evening
London,
WC2N 4AP
Map

£45
per course

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

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

2 hours
Part time evening
London,
WC2N 4AP
Map

£45
per course

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

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

2 hours
Part time evening
London,
WC2N 4AP
Map

£45
per course

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