Microsoft Excel 365 Training Course Beginners

Microsoft Excel 365 Overview

This Excel 365 beginners training course covers 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.

An Excel 365 Beginners Training course that will teach you:

• Basic formulas and functions
• Understand how to work with multiple worksheets
• Sorting and filtering data
• Importing and exporting data
• Creating basic charts and graphs
• Sharing a worksheet with others

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

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.

Microsoft Excel training is available in person and online.

All you need to know about our Live Online Training.

Live Online Training

Have a look at our range of Excel Training Courses

At the End of the Course

• Comprehensive training notes coupled with exercise files they can use at their leisure
• Access to online training materials including Video Tutorials and Keyboard shortcuts
• 3 months of post training support which includes email, phone and screen sharing assistance

Other Related Courses:

Microsoft Excel 365 Training Course Intermediate

Microsoft Excel Power BI Training Course Beginners

Microsoft Word 365 Training Course Beginners

Microsoft PowerPoint 365 Training Course Beginners

Microsoft Office 365 Training Course Beginners

Microsoft Outlook 365 Training Course Beginners

Microsoft Excel and Forms 365 Training Course Beginners

Microsoft SharePoint 365 Training Course Beginners