Beginners Excel Training Course
Duration :1 DayCost: From £220
Venues :Manchester | Birmingham | Online
Beginners Excel Courses
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.
Beginners Excel Course Introduction
Microsoft Excel is an extremely powerful and versatile tool that enables easy data manipulation, process automation, and report generation to name a few.
Our Excel Course for Beginners will take you through the basics of using Excel to using some more complex features.
The course covers Excel 2010/2013/2016/2019 & 365 (Also Excel 2011 for Mac). You are welcome to bring along an Excel spreadsheet that you are working on.
Beginners Excel Courses
Our public, 5 Star Rated, Beginners Excel Courses are run in Manchester, Birmingham and Online. We also run one to one and private group Excel Courses at your premises or at a location to suit you.
*Group booking discounts are available
Excel Basics Training Course for Beginners - Intermediate Course Topics
- Introduction to 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 see the Course Outline tab on the menu below - or click here to download a PDF
Classroom & Online Beginners Excel Courses
Our 5-star rated Beginner Excel Courses are available online as well as in Manchester and throughout the UK. O
See the dates below for a public course or contact us for one to one or private courses.
Suitability - Who Should Attend this Introduction to Excel training?
Our Beginners Excel course is designed for people who are new to Excel or are using Excel in a limited capacity and want to learn more.
You do not need any prior knowledge of Excel.
If you already have knowledge of the basics in Excel take a look at our Intermediate / Advanced Excel Classes.
Why Choose M Training's Beginners Excel Training?
- Run by a highly experienced Excel trainer
- This course is limited to 6 places so you are guaranteed personal support throughout the course
- Only £245 + VAT per delegate
- Convenient locations in Manchester, Birmingham & Online
- Course notes and support material provided
- Lunch and refreshments provided
- Certificate of achievement
- 5 Star Rated in Google Reviews
-
6 No more than 6 delegates
-
5 star rated courses
-
3 month online support
-
Lunch & refreshments provided
-
Practice led learning
Select from the tabs below to find out more:
Beginners Excel Training Course Dates
Click on the location tabs to see the available dates for our public Excel Course for Beginners for each city or online.
Online Beginner Excel Courses
Timings: Our online Beginner Excel public courses start at 9:30am and will finish around 4:30pm with plenty of breaks. Timings for private courses can be arranged to suit you.
Payment: Once booked an invoice will be sent which can be paid by Credit Card, via Bank Transfer, or Cheque.
PRIVATE ONLINE COURSES
Our Online one-to-one and private group training in Beginner Excel are available from £220 + VAT (three hours) or £390 + VAT (6 hours).
KEY BENEFITS:
Highly Interactive: You will see the trainer, their screen, and be able to chat/ask questions.
Ongoing Support: After the course, you receive the course notes, certificate, and 3 months of online support.
Contact us if you want to book a private online Beginner Excel course
Click here for information about how our online Courses work
Classroom Based Courses
Timings: The Beginner Excel course starts at 9:30am and will finish around 4:30pm with 45 mins for lunch. Timings for private courses can be arranged to suit you.
Payment: Once booked an invoice will be sent which can be paid by Credit Card, via Bank Transfer, or Cheque
Lunch & Refreshments: A great lunch and plenty of tea/coffee & biscuits are provided on all Beginner Excel public courses.
PRIVATE CLASSROOM COURSES
One-to-one and private group courses are available for Beginner Excel Training from £590 + VAT (Full Day)
These courses are ideal if you cannot make one of the set course dates or if you already know the basics and want something more specific.
After the course, you receive the course notes, certificate, and 3 months of online support.
More Information can be found on the Private Course Enquiry Tab (above) or call us on 0161 226 6032 or contact us
Private Beginners Excel Course
We are happy to run private Beginners, Intermediate & Advanced Excel courses at your offices, at our Manchester office, or at a venue to suit you.
The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.
Private Beginner Excel classes are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.
Private courses are available from £590 plus VAT
Private Online courses are available from £220 + VAT (3 hours) or £390 + VAT (6 hours).
To get a quote please complete the form below or call us on 0161 226 6032.
Private Beginner Excel Course Enquiry
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
-
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
-
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
-
Using AutoFilter
- Applying a filter to your data
- Sorting a filtered list
- Printing a filtered list
- Clearing filters
-
Charts
- Create a chart based on your data
- Change the chart type
- Amend source data
- Using chart designs and applying layouts
-
Printing Your Reports
- Adjusting margins
- Scaling a document
- Changing the Orientation
- Adding Headers and footers
- Set the print area
- Printing a worksheet
-
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
Manchester
Our Manchester Venue:
All our Beginner Excel Manchester courses are run from 9.30am to 4.30pm at our head office:
Greenheys Business Centre
Manchester Science Park
Pencroft Way
Manchester
M15 6JJ
Public Transport/Parking:
Free visitor parking is available at car park at the front of Greenheys building.
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
Birmingham
Our Birmingham Venue:
Our public Intro to Excel courses in Birmingham are usually ran 9.30am to 4.30pm at:
Innovation Birmingham Campus,
Faraday Wharf,
Holt Street,
Birmingham,
B7 4BB
Public Transport /Parking:
Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability.
Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.
More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page
Online
Because we only have 4 delegates on our online courses we can be flexible.
However, the standard timings for our Beginners Excel online course are as follows:
9.15am | Sign in - to check everyone is up ad running on the software – and show them the tools available
9.30am | Start - First session
11.00am | 15 min break
11.15am | Second session
12.45am | 45 min break
1.30pm | Third session
3.00pm | 15 min break
3.15pm | Fourth session
4.30pm | Finish & Q&A
4.45pm | End
Beginner Excel Course Reviews
-
Find out more
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. -
Find out more
Project Management Course
A one day theory and practical skills course to enhance your project management skills. -
Find out more
Powerpoint Training Course
Create a more impressive presentation using some of the more advanced features of PowerPoint. -
Find out more
Word Course for Beginners
This is a practical 1 day course that will teach you the essentials skills you need to get started with Microsoft Word creating simple yet effective documents
Kirsty Long, Royal Bank of Scotland