spreadsheets

Spreadsheets Course Outline

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

Topics Covered

Using the Application

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

Cells

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

Managing Worksheets

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

Formulas and Functions

Order of Calculation
Creating Formulas
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
Format Painter
Text Wrapping
Aligning Cell Contents
Cell Content Orientation
Merging Cells

Charts

Creating Column Charts
Creating Bar Charts
Creating Line Charts
Creating Pie Charts
Editing Charts
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.

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!