Microsoft
Excel Level 1
Course Outline:
|
Introduction
to Microsoft Excel Level 1
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.
Excel 2007 Courses
If you've moved to Excel 2007 and experience
difficulties using the new interface please ask us for
an Excel 2007 course.
|
|
Course Location
All these courses are regularly run at our
training centre at the Solent Business Park, Whiteley, Fareham,
Hampshire and 4 New Street, Salisbury,
Wiltshire. 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.
Aims
To create and edit basic Microsoft® Office Excel worksheets and
workbooks.
Course Objectives
By the end of this level you will be able to:
-
Create a basic worksheet
with simple formulas
-
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 work book
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 and Relative 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
|
|
Scheduled Course Dates in Southampton and Salisbury
Towns within 1 hour of our Training Venues
Our
Southampton training centre is ideally located
within 1 hours driving of the following towns: Salisbury,
Winchester, Basingstoke, Andover, Farnborough, Portsmouth,
Fareham, Gosport, Chichester and Bournemouth.
Our Salisbury training centre is ideally
located within 1 hours driving of: Winchester, Basingstoke,
Farnborough, Andover, Fareham, Southampton, Bournemouth, Poole,
Bath, Swindon, Newbury, Ringwood and Romsey.
|
 |
Microsoft Excel
Level 1
Introduction |
