Excel

MS Excel Course Outline – Introduction level

Topics Covered

Getting Started

Spreadsheet Terminology
Creating, Saving and Closing Workbooks
Switching Between Open Windows
The Excel Environment
Getting Help
The Ribbon
Customising the Ribbon
Backstage View
Live Preview
Quick Access Toolbar
Mini Toolbar
File Formats
Status Bar
Using Undo and Redo

Working with Data

Entering Data
Selecting Data
Copying and Moving Data
Editing Cells
Find and Select
Creating Custom Lists
Working with Comments

Working with Columns and Rows

Managing Columns and Rows
Inserting Columns and Rows
Deleting Columns and Rows

Worksheets

Insert or Delete a Worksheet
Copying and Moving Worksheets
Managing 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

Font Formatting
Font Alignment
Text Wrapping
Merge and Centre Data
Text Orientation
Formatting Numbers and Dates
Conditional Formatting
Cell Styles
Format Painter

Charts

Charts Basics
Formatting Charts
Recommended Charts

Preparing to Print

Print Preview
Page Break preview
Page Setup Options
Printing Worksheets
Setting Up Print Areas
The Spell Check

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!