Online Beginners Excel Training Course

Duration :1 DayCost: From £250
Venues :Zoom: Live with a trainer

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.

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.


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, see the Course Outline tab on the menu below - or click here to download a PDF


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 / 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.


Beginner Excel Course Day Details

Our 5 star rated Online Beginner Excel courses, are designed to recreate the classroom experience so that you get the maximum value from the session.

Our online course content mirrors that covered in our in-person Excel training. 

Online sessions run from 9:30 am to 4:30 pm.

We understand that extended screen time can be draining.

That's why we've woven in frequent breaks, interactive exercises, and ample opportunities to engage with both the trainer and other delegates.


Why Choose M Training's Online Beginners Excel Training?

Our highly experienced trainers use a blend of live demonstrations and supervised exercises, with feedback that refines and integrates your learning experience, to develop your Excel skills.

  • Live With A Trainer: Run by an expert Excel Trainer
  • Limited Class Sizes: Enjoy personalised attention in small, focused groups
  • Low Cost: From Only £250 + VAT per delegate
  • User-Friendly Platform: Join sessions effortlessly via Zoom, no specialised software required
  • Classroom Locations: Manchester, Leeds, Liverpool & Birmingham
  • Tailored Sessions: One to one and private group courses online and throughout the UK at your premises
  • Course Materials: courses notes and workbooks provided
  • Interactive: Plenty of opportunities to ask questions and share your experiences
  • Certificate: a certificate of achievement will be provided on completion
  • Live With A Trainer
  • 6 Small Class Sizes
  • Practical Exercises
  • Supplied Course Materials
  • Q&A Opportunities
  • Held on Zoom
  • Certificate Provided

Select from the tabs below to find out more:

Beginner Excel Course Dates

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

Filter by venue:
  • Course Dates
  • Venue
  • 15 August 2024
  • Online
  • View
  • 04 September 2024
  • Online
  • View
  • 01 October 2024
  • Online
  • View
Private Course Enquiries

We are happy to run private Beginners or Intermediate 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 classroom courses are available from £590 plus VAT 

Private Online courses are available from £550 + VAT (6 hours).

To get a quote please complete the form below or call us on 0161 226 6032.

Private Online Beginner Excel Course Enquiry

Beginners Excel Course Outline

google-logo.jpg
5
  • 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

Online Beginner Excel Courses

The Online Beginner Excel 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. 

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

Beginner Excel Course Reviews

google-logo.jpg
5
40
Other Courses you May Be Interested In
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
Click here to sign up for offers, advice and industry news Subscribe