1 Day Intermediate Excel Training Course: CPD accredited

1 Day Intermediate Excel Training Course: CPD accredited

4.85
40 reviews
microsoft-partner
feefo award

Expand your Excel skills on this 1-Day Intermediate Excel training course.

Learn to use some of Excel’s more powerful features like sorting and filtering data and creating charts.

This hands-on course includes lots of time to try out what you are being taught and ask questions.

✔ An intermediate Excel course that will build on your existing Excel skills.
✔ Plenty of one-to-one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and CPD accreditation

Find out what's covered in our Intermediate Excel course, run in central London or online.

What Will I Learn?

By the end of this course you’ll be a far faster, more confident Excel user. 

You’ll learn how to:

  • Create and format different types of charts.
  • Work with multiple sheets in Excel workbooks.
  • Copy and paste data in a variety of different data formats.
  • Use quick analysis tools to visualise your data.
  • Work with Excel’s list / database features to quickly sort data tables.

Course Details

Download full course details Download full course details

Below is the typical timetable for this training course, although exact timings vary between training course.

Stop copying and pasting between tabs – let Excel pull the data for you automatically.

  • Renaming, reorganising and managing multiple worksheets
  • Linking data between sheets so it updates automatically
  • Using COUNT and SUM variations to answer questions about your data quickly
  • Combining text from separate cells into one

Build charts that communicate clearly, not just charts that exist.

  • Choosing the right chart type and creating it in a few clicks
  • Adding axes, titles, legends and gridlines so your chart tells a clear story
  • Printing charts cleanly alongside your spreadsheet data

If you spend time manually sorting or formatting data, this session will help get that time back.

  • Using paste options to bring across only what you need – values, formulas or links
  • Sorting and filtering data to find what matters and hide what doesn’t
  • Saving custom views so you can switch between perspectives without reformatting

Make your data easier to understand at a glance and let Excel do more of the analysis work.

  • Using conditional formatting to make important values and trends stand out visually
  • Adding data bars, colour scales and sparklines, so patterns are immediately obvious
  • Converting data into a proper Excel table for faster filtering, formatting and formulas
  • Using the Quick Analysis tool to generate charts and totals in seconds

Online Training Requirements

To attend this Excel course online, you will need:

✔ MS Excel on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.