Excel for work and study: live online course

Week by week

What the learner works on

1. Week 1
   Tables and formatting

   Entering, formatting and organising data.

2. Week 2
   Formulas

   Cell references, functions and common mistakes.

3. Week 3
   Lookups and logic

   IF, lookups and combining conditions.

4. Week 4
   Cleaning data

   Duplicates, text functions and consistent dates.

5. Week 5
   Pivot tables

   Summarising a large table in seconds.

6. Week 6
   Charts

   Choosing a chart that tells the truth.

7. Week 7
   Dashboards

   Putting results on one page.

8. Week 8
   Practice project

   Build a budget, a marks sheet or a small report.

The order and pace change to suit the learner, and the teacher adjusts after every few classes. Topics follow the learner's board or level.

Who it is for

Is this course right?

Students, job-seekers and office staff who use spreadsheets every week and want to do it faster and with fewer errors.

Not sure about the level? Send a message and the teacher will ask a few questions and suggest where to start. For related pages, see Data analytics course.

How classes run

Before the first class

Each class mixes a quick recap, a new idea taught live, guided practice and a few questions to take away. Join ten minutes early for a sound and camera check, and use a laptop or desktop if the class needs screen sharing. Read what to expect in your first online class.

Price

What Excel for work and study costs

Skills level. Courses of 20 or more classes cost 8 percent less per class, and 40 or more cost 12 percent less. Prices are per learner. We confirm the amount, payment options and refund terms in writing before you pay anything. See how prices work.

Free practice

Try before you decide

• Free calculators and tools