1 Day Introduction Excel Training Course: CPD Accredited

1 Day Introduction Excel Training Course: CPD Accredited

4.8
45 reviews
microsoft-partner
feefo award

Master the basics of Microsoft Excel on our 1-day Excel Introduction training course.

Our friendly, certified Excel trainers will have you confidently using Excel in no time.

✔ A complete beginners’ Excel course that covers all of the basics.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.

Take a look at our Introduction Excel course, which we teach all over the City of London

CPD Accreditation

This course is CPD certified by The CPD Standards Office.

This course qualifies for 5.75 hours of CPD training.

We issue all attendees who complete this course a full CPD certificate.

What Will I Learn?

This course includes plenty of chances to practise so that you can consolidate what you are learning.

Things you’ll learn about include:

  • Navigating Excel so that you know where to find everything.
  • Using formulas to handle difficult calculations quickly.
  • Livening up your work with different fonts, colours and effects
  • Setting up your sheet so that it looks professional on-screen and when printed out.

Full Course Details

Download full course details Download full course details

By the end of this session you’ll know exactly where everything is and be ready to dive in.

  • Finding your way around Excel, including the Ribbon, Backstage View and Quick Access Toolbar
  • Creating a new workbook and entering text, numbers and dates correctly
  • Selecting cells, ranges, rows and columns quickly, including large and non-adjacent ranges
  • Editing, clearing and undoing changes without losing your work
  • Saving, spell-checking and safely closing your first workbook

The habits you build here save time every day.

  • Filling data fast with the Fill Handle, fill series and custom lists
  • Using Flash Fill to split and extract names, dates and numbers in seconds
  • Building your first formulas that add, subtract, multiply and divide
  • Totalling rows and columns quickly with SUM

This session tackles the mistakes that catch most users out, so your calculations are right every time.

  • Calculating averages and finding highest and lowest values
  • Building what-if formulas to test different scenarios
  • Understanding relative, absolute and mixed references, and when each one matters
  • Copying formulas without breaking them
  • Recognising and fixing Excel’s most common error messages

These are the finishing touches that turn a working spreadsheet into something ready to hand over.

  • Formatting fonts, numbers and borders so your sheet looks clean and professional
  • Inserting and deleting rows and columns, and working across multiple sheets
  • Sharing via OneDrive, with tracked changes and comments
  • Setting print areas, page breaks and repeating titles, and scaling to fit the page

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.