Excel 2007 Level 1

Objectives

Delegates will be able to:

Create a spreadsheet containing data, navigate using keyboard shortcuts, add new columns & rows and save the spreadsheet.
Create and format a spreadsheet using the main features of the formatting toolbar,
Perform the following calculations on a range of numbers: addition, subtraction, multiplication and division.
Use: sum, average, count, min and max on a range of numbers.
Follow on Courses

Excel Level 2
Excel Level 3
Excel Pivot Tables and Data Analysis
Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377
What's Included

1 delegate per computer
Telephone and email support
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises
Course Content

Exploring the Excel environment
Exploring the user interface
Exploring the ribbon
Obtaining help
Customising the quick access toolbar
Working with an Excel worksheet
Creating a new workbook
Saving a workbook
Opening a workbook already created
Navigating in Excel
Selecting and entering data
Saving a workbook
Modifying a worksheet
Entering text and numbers
Entering numbers as text
Inputting dates and times
Editing the contents of a cell
Manipulating data
Using the fill handle
Using the undo and redo buttons
Ranges
Selecting a range of cells
Selecting more than one range
Selecting an entire column and row
Highlighting the entire worksheet
Columns and rows
Inserting and deleting cells, columns and rows
Changing column widths and row heights
Auto-fitting a column to its contents
Changing back to standard widths
Hiding and unhiding a column or row
Searching for data in a worksheet
Developing a workbook
Formatting worksheet tabs
Repositioning worksheets in a workbook
Inserting and deleting worksheets
Copying and pasting worksheets
Splitting a worksheet
Arranging windows
Freezing and unfreezing rows and columns
Hiding and unhiding worksheets
Making copies of cell contents
Moving the contents of cells
Printing workbook contents
Setting print titles
Creating a header and footer
Setting page margins
Changing page orientation
Setting page breaks
Setting a print area
Printing a range
Starting the spell checker
Formatting a worksheet
Converting text to columns
Modifying fonts
Merging cells
Applying number formats
Aligning cell contents
Finding and replacing formats
Applying AutoFormat
Applying cell styles
Applying themes
Applying borders to a selection
Deleting borders around a selection of cells
Applying a date format to a cell or range
Changing the alignment of the contents of a cell
Using the format painter
Clearing cells (removing formats)
Performing calculations
Creating basic formulas
Calculating with functions
Copying formulas and functions
Creating a mixed reference
Order of operation
Displaying formulae on a worksheet
Auto sum button
Useful functions
Spelling and printing
Starting the spell checker
Viewing a print preview
Printing the spreadsheet
Printing a section of a worksheet
Clearing a print area