ECDL Syllabus 5.0 Module 4 Spreadsheets Using Excel 2010

Description

This manual helps you learn how to design spreadsheets, use basic functions to perform calculations within your spreadsheets and how to create and format charts. The manual comes with its own data files on the web that you can use for practising the relevant exercises. Approved by the ECDL Foundation.

CONTENTS:

Screen Layout

Menus, Toolbars and Task Pane

Moving Around

Help

Preferences

Opening, Saving and Closing Workbooks

Entering Data

Saving in Various Formats

Basic Formulas

Multiple Workbooks and Sheets

Manipulating Sheets

Editing Cells

Duplicating and Moving Data

Finding and Replacing Text

Sorting Data

Page Setup

Previewing and Printing

Formatting Data and Cells

Inserting/Deleting Rows and Columns

Functions and Addressing

Charts