Microsoft Excel 2007 Training Course Beginners Ipswich
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 - Ipswich
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
IpswichBelstead Road The Belstead Brook Hotel sits in nine acres of tranquil gardens, alongside a willow-lined stream. The original 16th Century hunting lodge is still very much at the heart of the hotel, housing a restaurant, bar and private dining rooms. An ideal place for training the Microsoft Excel 2007 Training Course Beginners. Alternatively if you live in and around Ipswich and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up. |
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 |