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

Balfour Beatty

"Great course, trainer was very interactive and enthusiastic."

GKN Aerospace

"Very informative and fun energy. I really enjoyed it and will be able to use what I leaned."

Prominate

"Excellent, informative, fun and engaging. Learnt a lot!"

"It was excellent. Easy to follow, engaging, structured and delivered with humour and patience."

Industrial Inkjet LTD

"Very good Excel for beginners training learnt a lot thankyou. very friendly and easy to understand tutor. would definitely recommend and do another course"

Microsoft Excel 2019 Training Course Beginners

Microsoft Excel 2019 Overview

We thought long and hard before creating this Microsoft Excel 2019 beginners training course. Seeing as Microsoft Excel is one of the most popular software applications at this moment in time. Crafting a one-day training course that reflects the variety in the way that companies use Excel today is problematic.

The purpose of a beginners training course is to not only introduce new skills to each student. But, also, to give each learner the confidence to use those skills in everyday life. Hence, we at Computer Tutoring, have drawn on the experience we have gained in the 20 years of training Microsoft Excel in designing this Excel 2019 beginners training course.

What You'll Learn

  • Build confidence in tackling everyday Excel tasks
  • Solve common spreadsheet challenges efficiently
  • Master formulas, including basic calculations and functions
  • Use Absolute References ($) and AutoFill for flexible formulas
  • Fix common formula errors and calculate across worksheets

Course Duration: 1 Day

Course Prerequisites:

This is a Beginners training course and hence has a minimal of course prerequisites from each individual student. These are as follows:

  • The ability to use a PC or Mac (Use of the mouse or equivalent interface device)
  • Able to use the Internet and download files
  • The use of a PC or Mac throughout the training day

Course Outline

Find Your Way Around Excel 2019

  • Working with the new spreadsheet interface
  • Using shortcuts in Excel (best practices)
  • Creating and saving a basic workbook
  • Pinning frequently used files
  • Searching for files
  • Quick Access Toolbar (no more searching for buttons)
  • Entering cell data
  • Tips for speeding up data entry in a spreadsheet
  • Using Excel Help, accessing free video tutorials
  • Consistent data typing
  • Using different zoom options

Learn How to Modify Worksheets in Microsoft Excel 2019

  • Inserting, deleting, and adjusting cells, columns, and rows (including shortcuts)
  • Finding and replacing data
  • Using Smart Lookup
  • Using Version History to undo mistakes
  • Using spellcheck
  • Adding, renaming, and deleting worksheets

Emphasising Spreadsheets Using Formatting

  • Adjusting fonts and alignment
  • Formatting currency and percentages
  • Understanding date formats
  • Using gridlines, borders, and background colours
  • Changing cell colour based on value
  • Ensuring consistency with styles in Excel 2019

How to Enter Calculations in Excel 2019

  • Entering basic arithmetic (addition, subtraction, multiplication, division)
  • Applying operator preference using brackets in formulas
  • Copying formulas using AutoFill
  • Using absolute references ($) for flexible formulas
  • Exploring functions to simplify tasks
  • Avoiding and fixing common formula errors
  • Reusing formulas and functions
  • Creating summary pages by calculating across worksheets
  • Handling common errors (#NAME? | #N/A | #DIV)

Get to Grips with Printing in Excel 2019

  • Exploring two new views to assist with printing
  • Setting a print area
  • Fitting data onto a page
  • Configuring headers and footers
  • Adding page numbers

Everyday Tips for Working with Excel 2019

  • Viewing multiple spreadsheets
  • Freezing panes to keep headers visible
  • Using split view effectively
  • Benefiting from synchronous scrolling
  • Using custom views
  • Adding custom views to the Quick Access Toolbar

Other Related Courses

Excel Training Courses

Microsoft Excel 365 Beginners Training Course

Microsoft Excel 365 Intermediate Training Course

Microsoft Power BI Beginners Training Course

Microsoft Excel 2019 Training Course Intermediate

Microsoft Excel 2019 Training Course Advanced

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel Pivot Tables Training Course Beginners

Green Pivot TablePower Pivot Training Course - Take your Pivot Tables to the next level with our introduction Power Pivot training course. If you feel that your Pivot Tables and/or Pivot Charts are someone limited then this is the course for you.


Power BI Training Course - If you have the data you need prepared but need more appetising charts, graphs and other visualisation to make your data palatable then look no further than a Power BI raining course.

Post-Course Resources

  • Training notes & exercise files
  • Online materials: video tutorials & shortcuts
  • 3 months post training support

All you need to know about our Live Online Training.

Live Online Training



Microsoft Excel 2019 Training Course Beginners

At Computer Tutoring, we prioritise your privacy and only collect the necessary information to provide our services. We will only share the personal data you provide in a form if you have opted in for those services. Our website also uses Google Analytics. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.

For more details, please read our full Privacy Policy.