Computer Tutoring Logo
Est. 2002
Menu Button

Cost Calculator

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live Online Face-to-Face
First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Leicestershire Police

"Really informative ! The trainer was patient and knowledgeable and was able to answer all the questions we had. Going over things we have covered again if required .I really enjoyed the session"

Supply Chain Academy

"I would like to say a big thank you for Simon for all of his help. His training has helped to bring back some of my lost knowledge and also have expanded my knowledge too! Will definitely be recommending to others. Thank you so much once again."

Doppelmayr Cable Car

"This course shows me how to use Excel in a very good and understandable presentation"

Ground Control Ltd

"Very clear and easy to follow, brought the training to life with specific examples and tried to tailor the training to our needs and our needs of the business."

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Overview

The onslaught of information today can be overwhelming. The constant need to calculate, evaluate, analyse and to work with figures is a must for a business of any size today. This Excel 2016 beginners training course give an introduction to Microsoft Excel 2016.

This course is the one to take should you have the 365 version of Excel with updates.

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

Course Prerequisites:

This is a beginners course so no previous knowledge of Excel is required. However an understanding of some of the basics of operating a computer is need if you want to get the most from this course.

Check that you are familiar with the following:

  • File Management
  • Operating System

Course Outline

Microsoft Excel 2016 Orientation

  • The Ribbon
  • Quick Access Toolbar
  • Older Dialog Boxes - The older way of doing it
  • Tell me what to do - The new Help Feature
  • Rows & Columns & Cells
  • The Formula Bar
  • Button Drop Down Lists
  • Context Tabs & Menus

File Management in Excel 2016

  • Creating a new File
  • Using Built-in Templates
  • Opening & Closing a Workbook
  • Saving a Workbook
  • Recent Workbooks & Places

Entering Information using Excel 2016

  • Selecting Data
  • Adjusting Column Width & Row Height
  • Using Auto Fill
  • Cut & Paste
  • Using the Paste Button
  • Moving Quickly around a Worksheet
  • Inserting & Deleting Rows & Columns
  • Find & Replace
  • Spell Checker

Formulas

  • Simple Formula
  • Using Cell References
  • Operators
  • Operator Preference
  • Functions
  • Copying & Renaming Worksheets
  • Calculating between Worksheets
  • Absolute References
  • Change Calculation Options

Formatting

  • Formatting Numbers
  • Font Size & Colour
  • Fill Colour
  • Borders
  • Cell Alignment
  • Text Wrapping
  • Cell Styles
  • Format Painter

Printing

  • Selecting the Print Area
  • Margins
  • Printing a Large Spreadsheet

Working with Different Views

  • Zooming in & Out
  • Split View
  • Freeze Panes
  • View Side by Side
  • Page Layout View
  • Gridlines, Headings & Formula Bar
  • Add Custom Views

Classroom based Beginners Excel Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

Training Delivery
Number Students?
Laptop hire?
Offsite training?

Course Price: £ *
Price Per Head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

Live Online Classroom
First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive software tips and special offers





Microsoft Excel 2016 Training Course Beginners

Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.

We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.

We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

By using our website, you consent to our use of cookies for the purposes outlined above.

For more details, please read our full Privacy Policy.