Part of our range of Microsoft Excel 2007 Training Courses in Manchester.
|
Course Overview For Microsoft Excel 2007 Training Courses (Introduction)This course is designed for the new or inexperienced user who has a need to use the programme on a regular basis, but who has had no formal or structured training and is likely to be self taught.
Delegates attending the course will gain the skills that will enable them to understand how to work with Excel on a day to day basis. Creating the most commonly used formulae, moving around the whole workbook in an efficient manner and designing the spreadsheets so that they can be printed in the most professional and easy to interpret format possible. The numerous shortcuts demonstrated, and the insight in to how to best use the day to day functions of Excel will ensure that the delegate is able to readily identify the benefits of attending the course immediately on returning to the workplace. |
|
| |
Course Content Of Microsoft Excel 2007 Training Courses (Introduction)
A typical course will cover the following:-
Excel 2007 Orientation
- The Excel Window
- Use the Ribbon
- The Quick Access Toolbar
- Use Shortcut Menus
- Customise the Status Bar
- Exit Excel
Creating A Basic MS Excel Workbook
- Create A New Workbook
- Enter Data In A Workbook
- Save A Workbook
- Open A Saved Workbook
- Enter Dates
- Create a Simple Formula
- Editing Data
- Filling a Series
- Close A Workbook
Selecting Data in Microsoft Excel 2007
- Select Contiguous Ranges
- Select Non-Contiguous Ranges
- Select Larger Ranges
- The Auto-Calculate Button
- Create an Input Range
Move And Copy Data in MS Excel
- Copy And Move Data From One Cell To Another
- Copy From One Cell To Multiple Cells
Microsoft Excel Printing
- Print Preview And Print Options
- Create Page Headers And Footers
- Print Formulas
|
Creating a Formula in Excel 2007
- Understand Formulae
- Create a Formula That Adds
- Create a Formula That Subtracts
- Create a Formula That Multiplies
- Create a Formula That Divides
- Absolute v Relative Referencing
Working With Functions in Excel
- Use The Sum Function
- Calculate An Average
- The Maximum Function
- The Minimum Function
- The Count Function
Excel 2007 Formatting
- Apply Bold
- Italics
- Underline
- Change Cell Colours
- Copy Formats From One Cell To Another
- Align Cells And Ranges
- Centre A Heading Over A Range
- Change Cell Content Orientation
- Add Borders To Cells And Ranges
Excel Row and Column Formatting
- Insert And Delete Cells
- Insert Columns And Rows
- Delete Rows And Columns
- Resize Columns And Rows
- Hide And Show Grid Lines
|
Download As A PDF
To find out more about how Copernicus Training can help your business, please call us on 0870 - 879 - 5327
or e-mail us at info@copernicus-training.com
|
