Excel 2010 - Introduction level

View our full Excel Course Schedule for course dates or call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

Excel 2010 Introduction

1 Day Course

Objectives

By the end of the day you will know how to:

• Understand the different sections of a spreadsheet
• Enter and edit data
• Modify an existing spreadsheet
• Create a new spreadsheet
• Use basic functions and formulae
• Format worksheets effectively
• Print documents, including large documents effectively
• Create basic charts
• Manage large spreadsheets

Prerequisites

A basic understanding of Microsoft Windows, and familiarity with a keyboard and mouse

Course Contents

Getting started

• Spreadsheet terminology
• The Excel environment
• Getting help
• Navigating a worksheet

Entering and editing data

• Entering and editing text and values
• Entering and editing formulas
• Working with pictures
• Saving and updating workbooks

Modifying a worksheet

• Moving and copying data
• Moving and copying formulas
• Absolute and relative references
• Inserting and deleting ranges, rows, and columns

Using functions

• Entering functions
• AutoSum
• Other common functions

Formatting worksheets

• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options

Printing

• Preparing to print
• Page Setup options
• Printing worksheets

Creating charts

• Chart basics
• Formatting charts

Managing large workbooks

• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message