+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Microsoft Office Excel 2019

MS Excel 365 Course Outline – Introduction level

Course Description

This introductory MS Excel 365 course is for anyone who needs to understand the way Excel works both on and off-line. It’s suitable for complete beginners. The lessons show the desktop and web version.

By the end of this course you will be able to navigate a spreadsheet, use the ribbon and the quick access toolbar. You will be able to enter and edit data as well as copy and move it. You will learn about absolute and relative referencing and be able to determine the order of calculations. You will learn how to create basic formulas and use basic functions such as the auto-sum, minimum, maximum, average and count Functions. You will also learn how to format worksheets, create basic charts and lastly manage large worksheets.​

Estimated course duration is 3-4 hours. Each lesson takes on average 3-5 minutes to complete. This Course is CPD Certified.
Download PDF

Topics Covered

Getting Started

Excel environment
Worksheet terminology
Navigating worksheets
Switching between open workbooks
The ribbon
Customising the ribbon
Mini toolbar
Quick Access Toolbar
Status bar
Backstage view
Getting help
Opening & closing workbooks
Creating & saving workbooks
File formats

Working with Data

Entering data
Selecting data
Moving & copying data
Editing cells
Clearing vs Deleting cell contents
Using Undo & Redo
Find & Select
Creating custom lists
Working with comments

Working with Worksheets

Managing columns & rows
Inserting columns & rows
Deleting columns & rows
Managing worksheets
Inserting/Deleting worksheets
Moving & copying worksheets

Formulae and Functions

Understanding Formulas
Order of Calculation
Entering and Editing Formulas
Moving and Copying Formulas
Absolute and Relative Cell References
Using Autosum
Sum Function
Min and Max Function
Average Function
Count Function

Formatting

Live Preview
Text formatting
Text alignment
Text wrapping
Merge & Centre
Text orientation
Formatting numbers & dates
Format Painter
Cell Styles
Conditional Formatting

Charts

Charts Basics
Formatting Charts
Recommended Charts

Preparing to Print

Print preview
Page Break Preview
Page Setup options
Setting Print Areas
Spell Check
Printing worksheets

Can't see what you need?

All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.

All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.

Great deals for Corporate licences – give us a call.

GET IN TOUCH

On-line courses

Face to face Workshops

Virtual On-line Classes

On-line Shop for 1 to 50 licences

Personalise your own course

Create your own branded learning site
bitsy

Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!

Sign Up See our Tips