+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
spreadsheets

Spreadsheets Introduction Course Outline

Reinforce your knowledge of the essential topics relating to using a spreadsheet for everyday use

Course Description

This Spreadsheet course covers the essential topics relating to using a spreadsheet application for everyday use. It’s suitable for complete beginners.

By the end of this course you will be able to work with spreadsheets and save them in different file formats. Use the Help facility. Enter data into cells and use good practice in creating lists. Select, copy, sort and move and delete data. Copy, move, delete and rename worksheets. Create mathematical and logical formulas, format numbers, choose create and format charts. Lastly you will learn how to adjust page settings before committing to printing.

If you are studying towards the ICDL (formally ECDL) qualification, you will find this course really useful as it will help to reinforce your learning before you take your final exam.​​ Lessons are updated in line with syllabus changes.

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

Topics Covered

Using the Application

MS Excel Environment
Backstage View
Creating New Workbooks - UPDATED
Navigating within Workbooks - NEW
Opening and Closing Workbooks
Saving and Updating - UPDATED
Saving Workbooks as Templates
File Formats - UPDATED
Switching between Workbooks
Available Help Functions - UPDATED

Cells

Entering Text and Values - UPDATED
Selecting Ranges
Using Undo/Redo
Searching and Replacing Content
Sorting Cell Ranges
Copying and Moving Content - UPDATED

Managing Worksheets

Inserting Columns and Rows
Deleting Columns and Rows
Modifying Columns and Rows
Modifying Worksheets - UPDATED
Freezing Panes

Formulas and Functions

Order of Calculation
Creating Formulas - UPDATED
Relative and Absolute Cell Referencing
AutoSum
Sum Function
Average Function
Min and Max Functions
Count Function
Round Function
IF Function

Formatting

Formatting Numbers
Formatting Font Size and Type
Cell Contents Formatting - UPDATED
Format Painter
Text Wrapping - UPDATED
Aligning Cell Contents
Cell Content Orientation - UPDATED
Merging Cells - UPDATED

Charts

Creating Column Charts
Creating Bar Charts
Creating Line Charts
Creating Pie Charts
Editing Charts - UPDATED
Formatting Charts

Prepare Outputs

Page Setup
Headers and Footers
Print Set-Up
Previewing and Printing
Printing Workbooks
Printing Selected Ranges

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