Excel 2007 Foundation

Target Audience

Excel Foundation is designed for users who are keen to extend their understanding and knowledge of the software. To fully benefit from this course, attendees are expected to be familiar with Windows and use of the mouse. Knowledge of a previous spreadsheet package would be useful, although not essential.

Pre-requisites

New or inexperienced users of Excel, those upgrading from a previous version of Excel or migration from another spreadsheet package.

At the completion of the course you should be able to:

• Start Microsoft Excel, navigate workbooks and worksheets, and exit correctly
• Understand the basic uses for spreadsheets
• Create, save, close and open a workbook
• Enter and edit different data types
• Select ranges of cells in a workbook
• Copy and fill data in a workbook
• Adjust the sizing of columns and rows in a workbook
• Create formulae that perform calculations in a workbook
• Use relative and absolute references in formulae
• Format cells and ranges to improve the appearance and readability of worksheets
• Apply formatting options to numbers
• Use basic functions in a workbook
• Preview and print a worksheet or range of cells
• Create simple charts (graphs)
• Toolbar customisation

Excel Basics

The Excel Screen • Moving About the Workbook • Simple Data Entry  • Selecting Ranges • Saving Workbook Formats

Copying & Filling

Using Fill for Quick Copying • Copying Cell(s) to One/Many Cells & Worksheets

Editing Data

Overwriting/Editing Cell Contents • Editing Formulae/Functions  • Using Undo/Redo •  Search & Replace

Adjusting a Worksheet

Inserting/Deleting Cells • Inserting/Deleting/Resizing Rows/Columns

Formulae

Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function

Absolute Referencing

Problems with Absolute/Relative Cell Referencing • Creating Absolute/Mixed References • Tracing Precedents/Dependent Cells • Circular References

Formatting in Excel

Formatting Numbers/Dates/Currency • Formatting for Effect (Bolding/Italics/Underling • Cell/Background Colours  • Cell Alignment

Working with Functions

Summing Non-Contiguous Ranges • Average/Maximum/Minimum Functions

Viewing Worksheets

Hiding/Unhiding Columns/Rows • Freezing Panes/Splitting Windows

Creating Charts

The Chart Wizard • Chart Types  • Adding Title/Legends/Lables • Printing Charts

Printing

Simple Printing/Previewing  • Page Setup & Orientation • Creating and Formatting Page Headers/Footers • Creating Headers & Footers (Information Fields)

You may also be interested in some of the following related courses below:

Microsoft - Excel 2007 - Intermediate
Microsoft - Excel 2007 - Power User
Microsoft - Excel 2007 - VBA

Send this course to a friend
 

Course Fee

We have a rolling programme of Scheduled Public sessions for the majority of standard courses – both in IT Productivity and Management & Soft Skills. Group sizes are limited to ensure optimum learning amongst delegates.

Passport Saving Plans

The advertised rates are on a per delegate basis, however if you have more than one attendee you may be entitled to a discount. To maximise your training budget why not email or contact one of our training consultants to see what rates/discounts may apply for your particular requirement.

Alternatively, if you have regular, ongoing training requirements, you may find one of our Training Passports of interest. Each is designed to provide our clients with significant benefits:
• Far better discounts
• Less administrative overhead
• Better control of your training schedules

Scheduled Training Passports
Enables you to pre-purchase training places on any of our standard scheduled courses.

Private Training Passports
Enables you to pre-purchase private training days against any of our standard courses.

Each of the above passports come with substantial discounts.

To maximise your training budget why not email or contact one of our training consultants who will be happy to provide you with the latest offers on any of our Training Passports. See what rates/discounts may apply for your particular requirement.

Please fill out the form below for more details:

First Name
Last Name
Job Title
Company
Office Telephone
E-mail
Brief Details	Characters Left.