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 365 Training Course Beginners

Microsoft Excel 365 Overview

This Excel 365 beginners training course introduces learners to the basic functions for performing calculations on sets of data in a worksheet. The SUM function allows users to add up a range of cells, while AVERAGE calculates the mean of a range of cells. MIN and MAX find the smallest and largest values in a range of cells, respectively.

In addition to these functions, the course will also cover techniques for filtering data in a worksheet. This can be useful for quickly finding specific records or for hiding irrelevant data. Filtering can be done using simple criteria or more complex logical statements.

What You'll Learn in this Excel 365 Beginners Training Course

  • Learn to use basic formulas and functions effectively
  • Understand how to create and manage multiple worksheets
  • Explore how to sort and filter data for better organisation
  • Discover methods for importing and exporting data efficiently
  • Create and customise basic charts and graphs
  • Share worksheets with others for collaboration

Finally, the course may also cover the basics of creating charts and graphs to visualise data. This may include creating different types of charts (e.g. column charts, line charts, pie charts), formatting chart elements (e.g. titles, axis labels, data labels), and adding data to charts. The course may also cover basic printing techniques, such as adjusting page layout and print settings, and previewing and printing worksheets.

Course Duration: 1 Day

Course Prerequisites:

This is a beginners training course, so no advanced skills are required, just a willingness to learn! To make the most of your training experience, we recommend:

  • Familiarity with using a PC or Mac, including navigating with a mouse or equivalent device.
  • Confidence in accessing the internet and downloading files as needed.

Course Outline

Introduction to Excel 365 and the Excel Interface

  • Understanding rows, columns, and cells
  • Navigating and selecting data in a worksheet
  • Entering and editing data in cells
  • Basic formatting techniques (e.g. changing font size, colour, and alignment)

Basic Formulas and Functions within Excel 365

  • Using basic arithmetic operators (e.g. +, -, *, /)
  • Understanding the difference between relative and absolute cell references
  • Using functions such as SUM, AVERAGE, MIN, and MAX

Working with Multiple Worksheets and Workbooks

  • Creating, renaming, and deleting worksheets
  • Moving and copying data between worksheets and workbooks
  • Linking data between worksheets and workbooks

Sorting and Filtering Data

  • Sorting data alphabetically or numerically
  • Filtering data using criteria
  • Advanced filtering techniques (e.g. using AND/OR logic)

Working with Basic Charts and Graphs

  • Creating and formatting charts and graphs
  • Adding data labels and data tables to charts
  • Changing the chart type and style

Importing and exporting data

  • Importing data from other sources (e.g. CSV files, databases)
  • Exporting data to other formats (e.g. PDF, CSV, HTML)

Collaborating with Others, Including Printing

  • Sharing workbooks and worksheets with others
  • Tracking and resolving conflicts in shared workbooks
  • Protecting worksheets and workbooks with passwords
  • Printing worksheets


Microsoft Excel 365 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.