Overview

This interactive online course gives you an introduction to using basic spreadsheets with Microsoft Excel 2010. The course will help you to use spreadsheets to evaluate business performance, improve communication and make more accurate forecasts based on your data.

Details

Designed with spreadsheet beginners in mind, this course uses simple everyday language to teach you how to:

• open and close Excel and use the Help features

• understand the basic Excel 2010 screen and its components

• use techniques to navigate Excel workbooks and its associated worksheets

• personalise Excel to suit your own requirements by changing zoom magnification, splitting windows and freezing panes

• create new workbooks and enter and edit data in worksheets

• open existing workbooks and move between them

• save workbooks in different file formats so people with earlier versions of Excel or other applications can open them

• use some of the more common selection methods in Excel to ensure fast ways to select data saving you time and effort when creating large worksheets

• move and copy data using the ribbon buttons, right-click menu, and shortcut keys

• insert, delete columns and rows and adjust the width of columns and the height of rows

• locate specific data within a worksheet using the Find and Replace commands and identify Search Options

• sort data alphabetically, numerically using the Sort feature

• change the appearance of a worksheet by modifying various formatting features such as font styles and sizes, data alignment, currency symbols, decimal placing

• work with multiple worksheets, including deleting, inserting, moving, copying, renaming tabs and applying a colour to worksheets

Features

• Simulation training replicates the software you're learning, providing a realistic learning experience

• Easy step-by-step actions to teach you how to perform tasks at your own pace

• Interactive and multiple choice quiz questions to reinforce your knowledge at the end of each 30-minute lesson

• Bookmarking allows you to dip in and out, so you can learn whenever suits you

• Navigation features allow you to jump directly to specific topics of interest quickly and easily

Modules

There are 12 modules in this course:

• Starting Excel and Help

• Screen Components

• Navigating Workbooks

• Splitting, Freezing and Options

• Creating Workbooks

• Opening, Saving and Closing

• Selection Techniques

• Moving and Copying Data

• Adding and Removing Cells

• Searching and Sorting

• Formatting Cells Techniques

• Handling Worksheets

Certificate

A learndirect certificate will be emailed to you when you have successfully completed the course.