Excel 2007 Level 1
| Date |
Location |
Duration |
Cost |
| 04 Oct 2010 (Mon) | Washington | 1 | £ 165 |
| 03 Nov 2010 (Wed) | Washington | 1 | £ 165 |
| 09 Dec 2010 (Thu) | Washington | 1 | £ 165 |
| 07 Feb 2011 (Mon) | Newcastle | 1 | £ 165 |
| 04 Mar 2011 (Fri) | Washington | 1 | £ 165 |
| 13 Apr 2011 (Wed) | Washington | 1 | £ 165 |
| 31 May 2011 (Tue) | Newcastle | 1 | £ 165 |
| 08 Jul 2011 (Fri) | Washington | 1 | £ 165 |
| 22 Aug 2011 (Mon) | Washington | 1 | £ 165 |
Please contact us to discuss private course dates and locations |
What is Excel?
Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data
Course Overview
This course will enable delegates to gain a good general understanding of the main features of Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
Prerequisites
- Delegates should be familiar with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.
Objectives
Follow on Courses
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
Print