Microsoft Excel 2007 Training Course Beginners
Course: Microsoft Excel 2007 Public Course
Level: Introduction
Date: 31st March 2010
Duration: 1 Day
Venue: Cambourne (Near Cambridge) Computer Tutoring Venue
Price: £200.00 + VAT Includes:
1 Day's Interactive Training
1 Months Post Training Support
Comprehensive Manual
Lunch
Level: Introduction
Date: 31st March 2010
Duration: 1 Day
Venue: Cambourne (Near Cambridge) Computer Tutoring Venue
Price: £200.00 + VAT Includes:
Learn how to manage, edit and print data using Microsoft Excel. You will learn how to perform various calculations, and successfully enter information in a work sheet, and develop a workbook. As you work through the exercises you will become familiar with the Excel environment and will see just what a useful tool it is.
Microsoft Excel 2007 Training Course (Beginners) Outline
Exploring the Excel Environment
- Explore the User Interface
- Explore the Ribbon
- Obtain Help
- Customize the Quick Access Toolbar
Working with an Excel Worksheet
- Navigate in Excel
- Select and Enter Data
- Save a Workbook
Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
- Create a Mixed Reference
Formatting a Worksheet
- Convert Text to Columns
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Merge Cells
- Apply Number Formats
- Align Cell Contents
- Find and Replace Formats
- Apply AutoFormat
- Apply Cell Styles
- Apply Themes
Developing a Workbook
- Format Worksheet Tabs
- Reposition Worksheets in a Workbook
- Insert and Delete Worksheets
- Copy and Paste Worksheets
Printing Workbook Contents
- Set Print Titles
- Create a Header and a Footer
- Set Page Margins
- Change Page Orientation
- Set Page Breaks
- Print a Range
Customizing Layout
- Split a Worksheet
- Arrange Windows
- Freeze and Unfreeze Rows and Columns
- Hide and Unhide Worksheets
Course Duration: 1 Day
Other courses you may be interested in:
Intermediate Microsoft Excel 2007 Training Course
Advanced Microsoft Excel 2007 Training Course
To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester |