Overview

This course teaches you everything about presenting data visually, sharing, analysing and organising data In Excel 2010.

Details

An excellent starting point for anyone wanting to learn the finer points of Excel 2010, this course uses simple easy-to-follow instructions to help you learn how to:

• create charts and work with them

• use WordArt, SmartArt and Pictures to illustrate a worksheet to give it greater visual appeal

• add shapes, use ClipArt and screen captures

• use the comments feature to insert comments in cells in the worksheet

• use file sharing methods that can be utilised from within Save & Send

• filter data, apply multiple search criteria, customise filters, sort with AutoFilters and remove filters

• use Excel's built-in number formats and create custom number formats

• apply conditional formatting to assist in identifying cells that meet specified conditions

Once you've completed the course you'll be able to improve many elements of your business including communication, decision making and forecasting.

Modules

There are 7 modules in this course:

• Creating and Modifying Charts

• Illustrations

• More on Illustrations

• Using Comments

• Sharing Workbooks

• Sorting and Filtering Data

• Custom and Conditional Formats

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

Certificate

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