You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel to manage, edit, and print data.

If you've moved to Excel 2007 and experience difficulties using the new interface please ask us for an Excel 2007 course.

All these courses are regularly run at our training centre at the Solent Business Park, Whiteley, Fareham, Hampshire. Other courses are run at Farnborough and Amesbury near Salisbury. Or if you have four or more delegates for an Excel course we can run the course at your offices, and offer you a very cost effective solution.

To create and edit basic Microsoft® Office Excel worksheets and workbooks.

• Create a basic worksheet
• Modify a worksheet and its simple formulas
• Create and Edit simple formulas [Sum, Min, Max and Average]
• Format the data, cells and sheet
• Sort a list of data and answer more complex questions of that data
• Filter a list of data and answer more complex questions of that data
• Create and edit a simple vertical bar chart
• Print the contents of a workbook

Content

Getting Started with Excel - An Overview of Excel - Navigate in Excel - Select Data - Enter Data - Save a Workbook - Obtain Help

 

Modifying a Worksheet - Move and Copy Data Between Cells - Fill Cells with Series of Data - Edit Cell Data - Insert and Delete Cells, Columns, and Rows - Find, Replace, and Go - to Cell Data - Spell Check a Worksheet

 

Performing Calculations - Create Basic Formulas - Calculate with Functions Copy Formulas and Functions - Create an Absolute Reference

 

Formatting a Worksheet - Change Font Size and Type - Add Borders and Colour to Cells - Change Column Width and Row Height - Merge Cells - Apply Number Formats - Create a Custom Number Format - Align Cell Contents - Find and Replace Formats - Apply an AutoFormat - Apply Styles

 

Developing a Workbook - Format Worksheet Tabs - Reposition Worksheets in a Workbook - Insert and Delete Worksheets - Copy and Paste Worksheets Copy a Workbook

 

Printing Workbook Contents - Set a Print Title - Create a Header and a Footer - Set Page Margins - Change Page Orientation - Insert and Remove Page Breaks - Print a Range

 

Customizing Layout - Split a Worksheet - Arrange Worksheets - Freeze and Unfreeze Rows and Columns - Hide and Unhide Worksheets