Excel 2007 / 2010 Level 1
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
| 08 Jun 2012 (Fri) | Newcastle | 1 | £ 165 |
| 06 Jul 2012 (Fri) | Washington | 1 | £ 165 |
| 08 Aug 2012 (Wed) | Newcastle | 1 | £ 165 |
| 10 Sep 2012 (Mon) | Washington | 1 | £ 165 |
| 09 Oct 2012 (Tue) | Newcastle | 1 | £ 165 |
| 07 Dec 2012 (Fri) | Washington | 1 | £ 165 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
What is Microsoft 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 Microsoft 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
Other courses in this series: Course Content
Exploring the Microsoft 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 Microsoft 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
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
Microsoft and Microsoft Excel are Registered Trademarks
Training courses North East England, courses in Durham, North East courses in Washington, Newcastle
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
