Microsoft Excel 2007 Level 1

Price:£15.50

Print option:

Qty:

Microsoft Excel 2007 Level 1 (code:W-INF722 )

Duration: 8 hours

Overview

The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists.

Target Audience

This book is primarily designed for people who need to know how to use Microsoft Excel 2007 is designed for people new to the Excel environment. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations etc. Full colour or black and white manual.

Pre-requisites

Microsoft Excel 2007 Level 1 assumes no knowledge of the software or creating electronic worksheets and workbooks. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Objectives

At the completion of Microsoft Excel 2007 Level 1, you should be able to:

work within the basic Excel environment
create a new workbook
open and navigate within workbooks and worksheets
make changes to data in a workbook
understand and work with ranges in a worksheet
copy and paste data in Excel
understand, create and work with formulas and functions used to perform calculations
format rows and columns in a worksheet
understand and use the number formatting features in Excel
use font formatting techniques to greatly enhance the look of a worksheet
print your workbook data
create effective charts in Microsoft Excel

* Approximate duration should be used as a guide only. Actual duration will depend upon the skills, knowledge, and aptitude of the participants.

Contents

The course focuses on practical work within Microsoft Excel 2007 giving learners ample opportunity to use their newly acquired skills through a series of graded exercises.

Getting To Know Excel

Starting Excel

The Excel Screen

Using The Ribbon

Using KeyTip Badges

Minimising The Ribbon

Shortcut Menus

Using Shortcut Menus

Understanding Dialog Boxes

Launching Dialog Boxes

The Quick Access Toolbar

Customising The Quick Access Toolbar