Beginners Excel Training Course

  • 1 Day
  • Manchester | Leeds | Birmingham | Liverpool | Online

Microsoft Excel is a powerful and complex tool with a wide range of features. This one day course is an excellent introduction to the key features and will show you how to use them more effectively.

Make an Enquiry/Booking

Choose a Public Course or Private Course below

From

£195 +vat
Make an Enquiry
  • Small class sizes
  • 5 Star Rated Course
  • Practical courses
  • 3 month support

Excel For Beginners

If you’re looking to improve your Microsoft Excel skills for work or your own personal development and consider yourself to be a beginner, then this course is for you.

It will give you practical Excel skills and knowledge to take away, from basic to intermediate levels.

You will learn simple formatting through to utilising formulas and creating reports.

Along the way we will show you plenty of hints, tips and shortcuts, to make using Excel easier, quicker and more efficient.

This course is suitable for users of Excel 2010/2013/2016/2019 & 365 (Also Excel for Mac).

 

Learn Basic Excel Skills

Through a range of practical exercises, you will learn the essential Excel skills you need from basic formatting to using formulas and creating reports.

After the course, you will also be provided with helpful course notes for your own reference.

Beginners Excel Course Outline

  • Introduction to Excel

    • Customising the Excel environment
    • Worksheet terminology
    • Customisation of the Quick Access bar
    • Creating a new worksheet
    • Entering text and numbers
    • Saving a worksheet
    • The Backstage view
    • Retrieving a workbook
    • Quick navigation using shortcuts

     

    Using AutoFilter

    • Applying a filter to your data
    • Sorting a filtered list
    • Printing a filtered list
    • Clearing filters

     

    Formulas

    • Use AutoSum to calculate figures
    • What is AutoCalculate
    • Produce Min, Max and Average calculations
    • Write simple bespoke calculations
    • Understand BODMAS (order of calculations)
    • Understand Relative and Absolute cell addressing
    • Applying names to cells
    • Finding named cells
    • Using named cells across multiple sheets
  • Formatting

    • Adding borders and shading
    • Aligning cells using left, right and centre
    • Applying various number formats – currency, accounting, decimal places
    • Merge and centre cells
    • Using Text Wrap
    • Adding basic illustrations
    • Use various methods of cut, copy & paste
    • Hiding/Unhiding columns
    • Adding/deleting/displaying Comments
    • Printing comments

     

    Charts

    • Create a chart based on your data
    • Change the chart type
    • Amend source data
    • Using chart designs and applying layouts
  • Working with Ranges

    • Inserting/Deleting rows and columns
    • Adjusting the width of a column
    • Adjusting row height
    • Autofill
    • Using in-built lists
    • Creating custom lists
    • Freeze panes
    • Split screen

    Printing Your Reports

    • Adjusting margins
    • Scaling a document
    • Changing the Orientation
    • Adding Headers and footers
    • Set the print area
    • Printing a worksheet

Why Choose M Training

  • Small class sizes

    We run small classes so that there is more interactivity, opportunity for questions and is more personal.

  • Convenient Locations

    Public courses are held in Manchester, Leeds, Liverpool, Birmingham and Online. Private courses can be ran anywhere in the UK.

  • Course Materials

    Detailed course materials are provided for each delegate as well as post course notes

  • Expert Trainers

    Run by an experienced Microsoft trainer and consultant

  • Follow up support

    Along with the course notes, you also recieve 3 months email support for any follow up questions that you may have. 

  • 5 Star Rated

    Our courses are rated 5 stars by delegates, through post-course feedback forms, on Google and Facebook.

Who Should Attend this Introduction to Excel Training?

Whether you have been using Excel in a limited capacity, or you are a complete beginner, this course is designed for you.

If you already have a good knowledge of the basics of Excel take a look at our Intermediate Excel or Advanced Excel Classes.

Pre-course Requirements

You do not need any prior knowledge of Microsoft Excel to attend this course but you should be comfortable using a laptop/PC/Mac.

 

What is covered on the Beginners Excel Course?

Below is a summary of the topics covered on the 1-day Beginners Excel course. 

  • Introduction to Microsoft Excel
  • Using simple editing features
  • Saving and opening Excel
  • Entering and editing data
  • Creating and editing simple formulas
  • Working with multiple workbooks
  • View options and printing
  • Creating lists
  • Sorting and applying filters
  • Creating reports
  • Creating graphs

For a full course outline click here to download a PDF

 

Beginner Excel Course Day Details

Our 5 star rated Beginner Excel courses are practical courses with small class sizes, a maximum of 6 delegates, which allows for plenty of time to interact with the trainer and ask any questions!

These are held as in-person classroom courses or as live, online courses (over Zoom). All courses, run from 9:30 am to 4:30 pm, with plenty of breaks.

Scheduled Beginner Excel Courses

Our scheduled public Beginners Excel Courses are run in Manchester, Birmingham, Leeds, Liverpool and Online. Dates for these can be found below.

Private / Bespoke Beginner Excel Training

We run private one to one and group Excel Courses at our training centres, or at a location to suit you, anywhere in the UK. These can also be held Online.

Course Reviews

I have found the [Beginners Excel] course very informative and useful, the trainer helped me put things into practice within my daily working in what was delivered. This on its own is saving me loads of time . I will definitely be booking onto the next course

Kevin B
Falcon Cranes

Course Reviews

Very informative [Excel] course, tailored to our requirements. Small class made it better Trainer very knowledgeable, down to earth, good laugh and worked well with our skillset

Cheryl W
Accles & Shelvoke

Course Reviews

Great course for anyone wanting to learn more about excel, the trainer Louise was very knowledgeable and answered questions thoroughly, I definitely have a much better understanding of excel, cheers

Ronald C
Instilbio

Course Reviews

Excellent [Beginner Excel] course. Learnt lots. Everything was explained and I wasn't rushed. Used real working examples relevant to my job. Questions were welcome. Andy was a fantastic trainer!

Jamie Foss
Westminster Building

Course Reviews

Well worth the day [Beginner Excel] course, will save valuable time for my working day. Thank you.

Dean Whitmore
Central Electrical Services

Course Reviews

This was an online class and it was very effective. Examples and teaching were both very clear. I would highly recommend this course.

SallyAnn Coleman
Apprentify

Course Reviews

Really well thought out course with extra benefits regarding computer shortcuts, being self taught this course has changed how I will start Excel projects, and save me time!

Brian Lord
Weir Group PLC

Course Reviews

Excellent! [The trainer] was very patient and knowledgeable, which made me feel at ease during the course.

Abbie Jacobs
Sage

Course Reviews

Thank you to Louise who was so patient and great at explaining step-by-step. Excellent day.

Alexandra Witek
Catax

Course Reviews

Very warm, approachable trainer with excellent delivery. Broken down into small sections which kept engagement. Would definitely book again

Colette McGuinness
Self Funded

Course Reviews

Louise was very informative and helpful

Charlotte Cope
Innovations 4 Leisure

Course Reviews

Really enjoyed the course. Informative and set at a good pace.

Mike Davies
The Little Greene

Course Reviews

Very friendly. Comfortable asking questions. Thank You :-)

Danielle Smith
Back Four

Course Reviews

Everything was well explained. Felt I could shout out if I couldn't understand.

Carlene Parker
Innovations 4 Leisure

Course Reviews

Good course, lovely trainer. Very useful for my new job.

Catherine Hardman
Edmundson Electrical Ltd

Course Reviews

[The trainer] was very good at tailoring the course to all the participants learning needs, at a good pace whilst making it enjoyable.

Sarah Watson
Edmudson Electical Ltd

Course Reviews

Very good delivery of [beginners Excel] course, would recommend.

Ryan Tolan
Edmundson Electrical

Course Reviews

[Introduction to Excel] course content and delivery was exactly what was advertised. Delivered in a steady pace and Louise was great overall.

Ruth Challinor

Course Reviews

Well explained and at a good pace. Very patient and stopped to help when needed.

Caroline Tasker
One Manchester

Course Reviews

I found the introduction to Excel very interesting and informative, just what I needed. The course tutor, Ben was very polite and patient.

John Hope
Beldam Crossley

Course Reviews

I enjoyed the day and the tutor kept it interesting.

Adam Powell
AGM

Course Reviews

Louise was excellent - very knowledgeable. I liked the "quick tricks"/wins rather than self taught longer ways.

Julia Welsh
RBS

Course Reviews

I found the course easy to understand and very relevant to the work I do. Have found out things I didn't know and have found it very useful.

Gill Dally
One Manchester

Course Reviews

Great course, learnt lots of new things in one day. Will definitely book the Advance [Excel] course.

Cheryl Haney
New Look Waste

Course Reviews

I feel I have taken a lot away from this course and am looking forward to using it in practice and at work.

Anthony Haskins
PHMG

Beginner Excel Course Dates

Browse all public Beginner Excel course dates below or use the filter to show only dates in specific locations

Enquire about a private course
Filter by venue:
  • Course Dates
  • Venue
  • 08 January 2026
  • Manchester
  • View
  • 16 January 2026
  • Leeds
  • View
  • 23 January 2026
  • Birmingham
  • View
  • 28 January 2026
  • Liverpool
  • View
  • 03 February 2026
  • Online
  • View
  • 04 February 2026
  • Manchester
  • View
  • 05 February 2026
  • Liverpool
  • View
  • 19 February 2026
  • Leeds
  • View
  • 20 February 2026
  • Birmingham
  • View
  • 24 February 2026
  • Online
  • View
  • 06 March 2026
  • Liverpool
  • View
  • 13 March 2026
  • Manchester
  • View
  • 19 March 2026
  • Leeds
  • View
  • 20 March 2026
  • Birmingham
  • View
  • 24 March 2026
  • Online
  • View
  • 02 April 2026
  • Liverpool
  • View
  • 09 April 2026
  • Manchester
  • View
  • 21 April 2026
  • Online
  • View
  • 30 April 2026
  • Leeds
  • View
  • 01 May 2026
  • Birmingham
  • View
Enquire about a private course

FAQs

  • How long is this course

    This is a 1 day course. Running from 9:30 am to 4/4:30 pm. 

  • Where are the courses held?

    This course is run in Manchester, Leeds, Liverpool, Birmingham and Online.

  • Where in Manchester is this course held?

    All our courses in are run from 9.30 am to 4.00 pm at our head office:

    Manchester Science Park
    Pencroft Way
    Manchester
    M15 6LR

    Public Transport/Parking:

    The closest public park is Manchester Science Park Visitor Car Park or Cecil Street Car Park - 5 min walk

    Manchester Oxford Road Train Station - 15 min walk

    Manchester Piccadilly Train Station - 30 min walk

    Access

    Please let us know in advance if you have any mobility issues and will need any assistance. Disabled parking is provided.

    More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

  • Where in Leeds is this course held?

    Our public courses in Leeds  are usually held at:

    West Village,
    100 Wellington Street,
    Leeds,
    LS1 4LT

    (venue subject to change)

     

    Public Transport /Parking:
    There are a few public car parks close to the venue, the nearest is Wellington Street Multi-Story Car Park.

    The venue is also only a 15 minute walk from Leeds Train Station.

    More Information about our Leeds training courses, along with a map, can be found on our Leeds Training page

  • Where in Birmingham is the course is the course held?

    Courses in Birmingham are usually held at:

    Cornwall Buildings
    45 Newhall Street
    Birmingham
    B3 2DF

    (subject to change)

    There are several public car parks close to Cornwall Buildings.

    The closest are:

    Euro Car Parks (Lionel Street): 0.2 Miles ~ 3 Minute Walk

    Snow Hill Station Car Park: 0.2 Miles ~ 4 Minute Walk

    Ludgate Car Park (Lionel Street): 0.2 Miles ~ 5 Minute Walk

     

    Public Transport

    We encourage all delegates to use public transport where possible.

    Cornwall buildings are located close to:

    Birmingham New Street Station: 0.4 Miles ~ 8 Minute Walk

    Birmingham Snow Hill Station: 0.2 Miles ~ 4 Minute Walk

     

    The M Training office in Birmingham is based at:

    Innovation Birmingham Campus,
    Faraday Wharf,
    Holt Street,
    Birmingham,
    B7 4BB

     

  • Where in Liverpool is the course held?

    The course in Liverpool is usually held at:

    The Plaza
    100 Hall Street 
    Liverpool
    L3 9QJ

    (subject to change)

     

    Parking

    There are several public car parks close to The Plaza.

    The closest are:

    St Paul’s Square Car Park: 0.02 Miles ~ 1 Minute Walk 

    NCP Liverpool Pall Mall Car Park: 0.2 Miles ~ 4 Minute Walk

     

    Public Transport

    We encourage all delegates to use public transport where possible.

    The Plaza is a 20 minute walk from Lime Street Station and a 4 minute walk from Moorfields train station.

  • How do the Online courses work?

    The Online courses are run on Zoom.

    You will be sent a link to join the training session the day before the course along with any course materials needed.

    The courses run from 9:30 am to 4/4:30 pm and follow the same course outline as the classroom courses and you will be able to interact with the trainer and group and ask questions.

    Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:

    9.20 am | Sign in

    9.30 am | Start - First session

    11.00 am | 15 min break

    11.15 am |  Second session

    12.30 pm  | 30 min break

    1.00 pm  | Third session

    2.15 pm | 15 min break

    2.30 pm | Fourth session

    3.50 pm | Finish & Q&A

    4.30pm | End

    Find out more about how our online courses work on the Online Courses Page

  • What's the difference between Private & Public Courses?

    Public courses are scheduled and open for anyone to book on to. There is a maximum of 6 delegates on our public course to ensure that everyone receives tailored training.

    Private Courses are courses that are arranged specifically for individuals or groups, no one else can book on to these courses. Private course content can be tailored to suit your requirements

  • Will I receive a certificate?

    Yes, all participants receive an M Training certificate of completion. This can be used for CPD records or as evidence of professional development in training skills.

  • Can I pay by invoice / PO?

    Yes. We provide an invoice for every booking. This will be emailed to you once the booking has been made, it contains our bank details, for payment by Bank transfer, along with a link to make payment Online with a credit or debit card.

    If you require to set us up as a supplier, that is fine, just let us know and we can provide you with all the information you need.

Other Courses You Might Be Interested In

Intermediate Excel Course

Learn how to use Excel to handle data efficiently, create more advanced formulas, and build professional spreadsheets on this 1-day course

From £195
MORE INFO...

Advanced Excel Course

This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel.

From £195
MORE INFO...

Powerpoint Training Course

Learn how to create a more impressive PowerPoint presentation using the extensive features of PowerPoint.

From £250
MORE INFO...

1 Day Power BI Course: The Essentials

Learn the essential skills needed to create powerful reports and dashboards on this 1 day Power BI Course

£295
MORE INFO...
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • Amazon
  • barclays-course.png
  • BC 2.png
  • Bt
  • Bupa
  • chanel 2.png
  • Jd Sports
  • Jet2com
  • Manchester client logo 8.png
  • Manchester City training 2.png
  • nestle training 2.png
  • Next
  • nhs-logo.png (1)
  • M Training Clients 10.png (1)
  • PTL-Manchester-training-client-logo-200.png
  • skym-courses.png (1)
  • client logo leeds.jpg
  • coop manchester 2.png
  • Tui
  • liverpool training 2.png
  • Siemens
  • Kraftheinz
  • HM Government
Manchester: Base, Greenheys Lane, Manchester Science Park, Manchester, M15 6LR
Leeds: West One, 114 Wellington St, Leeds, LS1 1BA
Birmingham: Innovation Birmingham, Faraday Wharf, Birmingham, B7 4BB
Liverpool: The Plaza 100 Old Hall Street Liverpool L3 9QJ
Click here to sign up for offers, advice and industry news Subscribe
Book this course