Microsoft Excel Beginner and Intermediate Course

£129.00

Product Total: 129

Build the Excel Skills Employers Look For

Almost every career now needs Microsoft Excel. Whether you are starting from scratch or you already use Excel but want to work faster and with more confidence, this course takes you from beginner to intermediate level in one programme.

You will learn to build and format workbooks, write formulas and functions, create charts, and organise and filter data, giving you the practical Excel skills to be more productive in your role and stand out to employers.

How the Course Is Delivered

The course runs on an interactive online learning platform developed by a Microsoft Learning Partner. A virtual tutor guides you through every lesson, sets practical exercises, and provides corrections and feedback as you go, so you build real skills you can use straight away in your job.

  • Study online from home, the office or anywhere
  • Learn at your own pace
  • Practical exercises in every lesson

Course Content

Beginner Level

  • Getting started with Excel: creating new workbooks and an overview of what Excel can do
  • Formatting a workbook: fonts, cell formatting, borders, colours and highlighting; copying, cutting and pasting
  • Your first calculations: entering formulas, calculating a sum and other essential functions, and copying formulas to adjacent cells
  • Working more efficiently: number formats, spell check, find and replace, inserting, deleting and moving rows, columns and cells, merging cells, cell styles and text orientation
  • Printing: page layout, print preview, repeating row and column headings, headers and footers, page breaks and print areas
  • Managing your workbook: introduction to tables, sorting data, copying formatting, date formats, splitting the window and freezing rows and columns
  • Tables and charts: subtotal rows and filtering options

Intermediate Level

  • Multiple worksheets: naming, colouring, inserting, deleting, moving, copying and hiding sheets, and sheet backgrounds
  • Formulas and functions: absolute references, calculating with functions, simple conditions, named ranges and calculations across multiple cell ranges
  • Advanced copying: copying values, copying with a link and transposing data
  • Formatting data: wrapping text, custom formats, and applying and managing conditional formatting
  • Data validation: setting validation rules to control what is entered
  • Charts: creating and managing charts, adding and removing chart items, formatting charts and chart text, data series, labels and axes, and printing charts
  • Sparklines: mini charts inside cells
  • Visuals: inserting and managing pictures, drawing objects and text boxes, and rotating, aligning, stacking and grouping objects
  • Working with data in tables: automatic calculations, subtotal rows, automatic and custom filters, finding blank cells and duplicates
    Advanced filtering: criteria ranges, copying filtered rows and statistics with a criteria range
  • Flash Fill: filling data automatically from a pattern

Who Is This Course For?

  • Complete beginners who want to learn Excel properly
  • Excel users who are self-taught and want to fill the gaps
  • Office staff, administrators, PAs and assistants
  • Job seekers who want Excel skills on their CV
  • Anyone who wants to work faster and more accurately with data

Benefits of the Course

  • Training written by senior Microsoft trainers from a Microsoft Certified Academy
  • Virtual tutor guidance throughout every lesson
  • Numerous practical exercises to build real skills
  • CPD accredited, with a certificate on completion
  • A professional qualification to strengthen your CV
  • Excellent value at £129 for two full levels of training, cheaper than buying separately at £79 each

Accreditation

Souters is a Microsoft Certified Academy, and this Excel course is CPD accredited. When you successfully complete the course, you receive a CPD- accredited certificate.

Need Advanced Excel Too?

For pivot tables, VLOOKUP, IF statements and other advanced skills, take the full Microsoft Excel Diploma, which covers Beginner, Intermediate and Advanced levels.

Frequently Asked Questions

Do I need any Excel experience?

No. The course starts from the very beginning, and you can move quickly through anything you already know.

How is the course delivered?

Online, on an interactive learning platform with a virtual tutor who instructs you, sets exercises and corrects your work.

Is the course accredited?

Yes. It is CPD-accredited, and you receive a CPD-accredited certificate upon successful completion.

What is the difference between this course and the Excel Diploma?

This course covers Beginner and Intermediate levels. The Excel Diploma adds the Advanced level, including pivot tables and advanced formulas.