Excel Training Course Level 1 UK Wide - On-site and Online

Beginners Microsoft Excel Training Course

This one-day Microsoft Excel beginners training course provides the essentials that you need to get started working with Excel, Microsoft's industry standard spreadsheet application.

Our Beginners Excel course introduces the most fundamental features and functions that you might encounter in the day-to-day management of your business data and enables learners to get going with Excel basics at a competent level.

Email us or call 0844 493 3699 to find out more about booking MS Excel training for your team.

Both our on-site (face-to-face) and live virtual classroom Microsoft Excel courses offer a flexible teaching approach and your allocated trainer will call you before the event to discuss your exact training needs. You can also combine Beginners, Intermediate and Advanced Excel training courses to create a blended training programme of up to four days in duration.

Our expert trainers come to you and can deliver this Microsoft Excel Beginners course at your premises across most regions of mainland UK (including East Midlands and West Midlands, Greater Manchester and the North West, Yorkshire and the Humber, Greater London, East Anglia, Bristol area, South East and South West of England etc.), or virtually from anywhere.

Excel Beginners Training Course Prerequisites

No previous knowledge of Microsoft Excel is needed to attend this introductory course. Learners should be able to navigate their way around Windows and/or the Microsoft Office 365 environment and have an understanding of opening, closing and saving files and folders. If you already have some self-taught experience with Excel but feel more comfortable starting from scratch, or with a refresher, that's fine too.

Intended Audience

This introductory fundamentals Excel course is aimed at business professionals, individuals and groups of employees who need to become competent using Microsoft Excel spreadsheets and anyone who needs to get off the starting block managing, analysing or reporting upon small, medium or large sets of data including:

• Administrators
• Accountants
• Sales Teams
• Financial Sector Workers
• Customer Service & Sales Representatives
• Analysts
• And any other profession which depends upon data management

On-site Microsoft Excel Beginners Courses in the United Kingdom

Our closed courses for Microsoft Excel are delivered as private courses for your learners offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your particular learning needs.

Excel is one of the most powerful and useful of the traditional Microsoft Office applications, but also often the one with which people can struggle the most, and that they find the most frustrating to work with. In fact, having team members and colleagues that are confident and proficient with Microsoft's Excel software can not only increase productivity and efficiency in the workplace, it can even be good for morale.

Our entry-level Excel course is the perfect place to start on this journey, and to build confidence and competency working with spreadsheets.

All of our mobile trainers understand that helping their students to work more effectively is not just a business-oriented goal, it is also empowering for the individual students themselves. As such, our trainers are not just educators, they also champions of the software who endeavour to promote enthusiastic adoption of Excel among those they teach. Before the start date they will discuss with you the goals and objectives of the training and those skill-sets that your team need the most in order to get started working effectively with Excel.

Microsoft Excel versions available for training courses include: Excel 365, MS Excel 2021, MS Excel 2019, MS Excel 2016 and MS Excel 2013.

Our Regional Microsoft Trainers Come to You

With our on-site Microsoft Excel Beginners courses our regional Excel trainers come to your workplace throughout England, bringing the training to you regardless of whether you are in a major city such as London, Manchester, Birmingham, Bristol or Leeds, or anywhere else.

This offers a really cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Nottinghamshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding of Yorkshire and everywhere inbetween.

Virtual Microsoft Excel Beginners Courses for the United Kingdom and Beyond

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Microsoft Excel courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These Online instructor-led courses are taught via MS Teams video conferencing.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

Our virtual learning Microsoft Excel courses cater for groups of up to ten people and your learners benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

Our realtime virtual classroom Microsoft Excel courses are charged out at £550.00 plus VAT per day inclusive up to 5 delegates. Further learners can be added up to a maximum of 10 charged out at £50.00 plus VAT per person per day. Courseware will be provided electronically.

You can find out how to set up Microsoft Teams for a live Online virtual course here (Virtual Learning with MS Teams).

Do you Record your Live Virtual Microsoft Excel Beginners Courses?

In our experience recording live Excel courses delivered via Microsoft Teams is not necessarily a good idea. The problems you might encounter include recordings failing due to Microsoft making updates to Teams and also bandwidth issues caused by streaming live courses and recording at the same time. As such, and in order to ensure the best possible learning experience for your students (and without any unnecessary disruptions) our instructors do not record our live virtual Microsoft Excel Beginners courses.

We really ❤ love helping UK organisations to master Microsoft Excel. Our only question is: Will it be yours?

Commercial and Corporate Excel Courses for the Public and Private Sectors

How Many People Should Attend Our Private Microsoft Excel Beginners Courses?

Whilst the number of people who attend our private Microsoft Excel courses is essentially up to you and dependant upon the number of learners you have who need to receive the training (up to our ten delegate per course maximum), we encourage all of our clients to keep your class sizes small where possible. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.

What is the Teaching Method for Our Microsoft Excel Beginners Courses?

The teaching method for our private Excel courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory, hands-on learning method your staff will retain information better, whether they are studying Excel in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Excel know-how to life in a small-class-size setting.

How Long are Our Microsoft Excel Beginners Courses?

Usual teaching hours for this one-day course are 9.30AM to 4.30PM with an hour for lunch and two short breaks morning and afternoon. This timetable is fairly standard across UK training providers and gives six hours of hands-on Excel learning, which is an optimal day's training when it comes to comfortably absorbing knowledge, undertaking practice exercises and retaining information.

If you need an earlier or later start time for your course please let us know and we will do our best to accommodate you.

Courses are delivered week days, Monday to Friday during normal business hours.

More About Our Microsoft Excel Training Delivery Method for Closed Courses for Businesses

• Step-by-Step Courses: Instructor-led Beginners Excel training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Q&A courses: Dynamic and interactive Excel courses with plenty of time for questions and answers.
  
  
• Flexible Courses: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Excel functions, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Small Class Sizes: Private, corporate Beginners Excel training for small group sizes with a maximum of 10 learners on any course.
  
  
• Scalable Courses: Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Excel knowledge and confidence that you require.

Introduction to Microsoft Excel Training Course Outline

You can combine Beginners, Intermediate and Advanced Excel topics and agendas for a blended step-by-step training curriculum of up to four days in duration.

We specialise in delivering flexible training programmes and the actual course content, topics and syllabus taught will often vary depending upon your learning requirements and upon the version of the software taught.

• Module 1: Introducing Microsoft Excel
  1. What are Worksheets?
  2. What are Workbooks?
  3. What are columns and rows?
     
     
• Module 2: Mouse Pointer Functions in Excel
  1. What are the Different Mouse Cursor Symbols?
  2. Select Cell Cursor
  3. Extend and fill Cells Cursor
  4. Insertion Point Cursor
  5. Drag Selection Cursor
  6. Change Row and Column Dimensions Cursor
     
     
• Module 3: Selecting Cells in Excel
  1. Cut Cells
  2. Copy Cells
  3. Format Cells
  4. Move Cells
     
     
• Module 4: Navigating the Excel Screen
  1. Introduction to Menus, Sheets and Views
  2. Add, Insert, Rename and Move Worksheets
  3. Scroll Bars, View Buttons and Magnification
  4. Menus and Sub-Menus
  5. Quick Access Toolbar
  6. Customising the Toolbar
  7. The Options Button and Global Settings
     
     
• Module 5: Entering and Editing Excel Data
  1. Text, Values and Dates
  2. Formulas, Values and Operators
  3. Active Cells
  4. Content Spill
  5. Adjust Column Width
  6. Editing Cells
  7. AutoFill
     
     
• Module 6: Copying and Pasting Excel Data
  1. Menu, Mouse or Keyboard Copy and Paste?
  2. Drag Cells to Copy
     
     
• Module 7: Save, Close and Open Excel Files
  1. Save, Save As
  2. Disk Drive, Network Drive, OneDrive
  3. File Names and Renaming
  4. Opening and Closing a File
  5. Adjust Column Width
  6. Editing Cells
  7. AutoFill
     
     
• Module 8: The File Tab Environment
  1. Open, Save, Print
  2. Info, Recent and Options
     
     
• Module 9: Create a New Excel Workbook
  1. Create a New Workbook from Scratch
  2. Excel Workbook Templates
     
     
• Module 10: Basic Math Formulas and Functions
  1. What are Formulas and Functions?
  2. Operators, Cell References and Constants
  3. Cell Referencing
  4. Operators and Operator Order
  5. The SUM function and values
  6. The AVERAGE function and values
  7. The COUNT function and values
  8. The MAX and MIN functions and values
     
     
• Module 11: Absolute Referencing
  1. What is Absolute Referencing?
  2. Creating an Absolute Reference
  3. Formula Auditing
     
     
• Module 12: Formatting Excel Worksheets
  1. Number Formatting
  2. Fonts
  3. Borders
  4. Fill Colour
     
     
• Module 13: Printing Excel Worksheets
  1. Print Settings
  2. Print Preview
  3. Borders
  4. Print Ranges and Print Selection
  5. Create a Print Area
  6. Print Titles
     
     
• Module 14: Excel Charts
  1. Create a Simple Chart
  2. Chart Types
  3. Chart Styles
  4. Chart Tools Layout
  5. Chart Title
  6. Format Legend
     
     
• Module 15: Sorting and Filtering Excel Data
  1. Sort Options
  2. The Sort Command
  3. Add Levels
  4. Filter a Database
  5. The Filter Command
     
     

Excel Course Levels: training courses are available for beginners, intermediate, and advanced users of Microsoft Excel.

Microsoft Excel Training Reviews from our UK Customers

An excellent, clear and patient tutor who guided me through the course seamlessly.
M Menzies (Online Excel training 365 (virtual classroom))

Can I just pass on my thanks to your team for the training you provided in York. I've had lots of positive feedback from the staff involved.
J Whiley, NHS York and Selby (Excel training York, North Yorkshire)

Really useful. Really knowledgeable trainer.
A Ward, Aeromet (Advanced Excel Training Worcester, Worcestershire)

The trainer explained everything really well. I found the course easy to follow.
V Broxham, Baywa-re Operational Services (Intermediate Excel training Milton Keynes, Buckinghamshire)

Happy with everything.
M Aston, Bierce Surveying Ltd (Advanced Excel Training Aylesbury, Buckinghamshire)

We have had a few people over the years but the way the trainer picked up our business and requirements so quickly – all I can is you have a diamond there.
S Jenkins, Concorde Glass (Intermediate Excel Training Grimsby, Lincolnshire)

We all thoroughly enjoyed the course, we learned a great deal and thought Sara was a brilliant trainer, very patient with a fantastic way of teaching us, so thank you for that.
C Waldock, Darlington Borough Council (Intermediate Excel training Darlington, County Durham)

The content covered the exact content required after the beginners course. The information will allow me to improve the spreadsheets currently in use.
L Powell, Dudley Building Society (Intermediate Excel Training Dudley, West Midlands)

Great course!
V Franklin, E-Leather (Excel Beginners Training Peterborough, Cambridgeshire)

The training approach and style was great. Incredibly informative and supportive.
L Shier, One YMCA (Introduction to Excel Training Watford, Hertfordshire)

Great teacher!
J Smith, Fisher German (Intermediate Excel Training Canterbury, Kent)

Its an excellent course. I was impressed by the discovery of so many tools that will facilitate our working life. The trainer is excellent, everything was perfect.
S Green, HW Martin (Beginners Excel Training Cambridgeshire)

Very happy to learn so much.
O Chawishly, LM Information Delivery (Intermediate Excel Training Oxfordshire)

Covered all objectives. Wish We'd had two days.
B Hough, Homebase (VBA for Excel Training Milton Keynes, Buckinghamshire)

The course was excellent, covering more in a single day of training than I anticipated would be possible with a high degree of clarity.
Unsigned, New Economy, (VBA for Excel training Manchester, North West)

Very informative, easy to follow. Trainer was clear with his explanations
S Nottingham, Denney O'Hara (Microsoft Excel training Leeds, West Yorkshire)

Excellent day!
L McLachlan, Grange School (Excel training Rochdale, Greater Manchester)

Brilliant Training, went at the right speed [and] was made relevant to work
Kathryn Strong, Tennants Distribution (Excel training Manchester, North West)

Fantastic course, not too much information overload. Explained simple. Exactly what I needed. Many thanks.
K Stobbs, Depuy Spine - A Jonson and Jonson Company (Introductory Excel training Leeds, West Yorkshire)

The flexibility of the course was ideal.
S Walsh, Progress Rail (Advanced Excel training Edinburgh, Midlothian)

The guys who came to the course this week were very impressed with the whole set up and are now eager to attend the next level up.
E Dixon, Connaught PLC (Beginners Excel training Leeds, West Yorkshire)

The course has improved my knowledge of Microsoft Excel and was a good pace so easily understandable. Gerry was very patient and helped each of us where we needed it.
L Muir, Filtronic Broadband (Microsoft Excel training Newcastle Upon Tyne)

Although a total beginner on Excel, I found the course to be extremely helpful.
S Antonie, Filtronic (Excel training Shipley)

Made what I thought was going to be completely foreign to me easy to understand. I can actually see where I can use Excel in my day job now. Max was very good and took the time to make sure we understood. [...] Nothing could be improved.
C Elsmore, Elmwood Design (Excel training Leeds, West Yorkshire)

Straight forward clear exercises, well presented.
Microsoft Excel Beginners Training for a client in Coventry, CV6)

Very Useful.
J Collins, Cooper Research Technology Ltd (Advanced MS Excel Training Ripley, Derbyshire)

Enjoyable and informative.
N. Bell, Cosalt PLC (Excel advanced training Grimsby, Lincolnshire)

The training session went very well and I have had a lot of good feedback from the participants.
P Ogden, InterfaceFLOR (Microsoft Excel Training Halifax West Yorkshire)

Course exceeded expectations.
K. Richards, Ashfield Homes (Microsoft Excel Training Sutton-in-Ashfield, Nottinghamshire)

The day was very well constructed and presented.
D. Coulthand, Crossgates Shopping Centre, Leeds (Intermediate Microsoft Excel Training Leeds, West Yorkshire)

Very happy with the training and with [the trainer] and we would like to use yourselves again.
Microsoft Excel Beginners Training for a client in Sheffield, S4)

Its an excellent course. I was impressed by the discovery of so many tools that will faciliate our working life. The trainer is excellent, everything was perfect.
Microsoft Excel Beginners Training for a client in Peterborough, PE6)

Training very clear. Never felt rushed or pressured to complete tasks. Each item explained and demonstrated very well. Easy to follow
S. Hope, Lear Corporation (Advanced Microsoft Excel Training Coventry, West Midlands)

Good course, good information, good trainer and at a nice tempo
A. Webster, BE Aerospace (Advanced Microsoft Excel Training Hinckley, Leicestershire)

Excellent, the best Excel course I have ever been on. Trainer gave time and patience to us all.
D. Gill, Persimmon Homes (Beginners Microsoft Excel Training Malmesbury, Wiltshire)

A very robust day's training.
T. Camp, Ideal Shopping (Beginners Microsoft Excel Training Peterborough, Cambridgeshire)

The course in Edinburgh was incredible
C. Rowley (Beginners Microsoft Excel Training Edinburgh, Midlothian)

Back to top

MS Excel Course Levels

Beginners Excel

- introductory topics for working with Excel spreadsheets

Intermediate Excel

- conditional formatting, VLOOKUP, IF, apply formulas across worksheets, database features, security and conditional formatting etc.

Advanced Excel

- What-If Analysis, PivotTables, PivotCharts, Goal Seek, Sparklines, protecting workbooks, formula auditing etc.

Masterclass Excel

- 'zero to hero' three-day intensive Excel course

Excel for VBA beginners

- one or two day introduction to programming with VBA

Excel Power Query course

- Introduction to using Excel Power Query in conjunction with Pivot Tables, Power Pivot and Power Pivot Measures

Back to top