Microsoft Excel Course
Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VAT Overview:
Microsoft Excel 2003 is a
software application that can be used as a spreadsheet, database, or graphing
program. The electronic spreadsheet portion of Excel allows you to perform
sophisticated calculations and create formulas that automatically calculate
answers.
This course is designed to
help you to obtain the basic skills required to create and use a
spreadsheet using Microsoft Excel. You will learn to enter and
edit data, create formulas, format elements of a worksheet, and
insert charts.
Target audience
Those wanting to obtain basic
skills in using a spreadsheet, such as updating data, applying
formatting, printing, and making simple calculations.
What is Excel?
 | Understand the functions of spreadsheet
application • Recognise the different elements of the Excel
screen |
Creating a Workbook
| Create a new workbook • Move around the
worksheet using the mouse and keyboard • Select cells using
the mouse and the keyboard • Use zoom to view a worksheet at
different magnification • Use Undo and Redo |
Entering and Editing Data
| Enter text, values, and dates in cells •
Edit cell contents |
Creating a Formula
| Understand what a formula is and how to
create simple calculations • Use AutoSum • Enter a formula
by typing or by using the Formula bar • Enter a range within
a formula using the mouse • Use relative and absolute cell
references |
Moving and Copying Data
| Use the AutoFill tool • Create a custom
list • Use Drag-and-Drop to move or copy cell contents •
Move, copy, and paste data using the Windows Clipboard
|
Editing a Formula
| Create a formula using functions • Revise
a formula • Use Insert Function • Use basic arithmetic
functions (SUM, AVERAGE, COUNT, MIN, MAX) • Recognise and
resolve common error messages • Interpret spreadsheet data
|
Formatting Cell Values
| Apply value formats (currency, percent,
date, comma) • Adjust the decimal place • Change the
currency symbol • Apply other formats (accounting, time,
text, general) |
Formatting Cell Contents
| Apply font styles (typeface, size,
colour, enhancements) • Modify the alignment and orientation
of cell contents • Merge and unmerge cells (to centre
headings across columns) • Indent text in a cell • Use the
Format Painter to copy cell formats • Clear cell contents or
formats |
Structuring a Worksheet
| Modify the size of columns and rows •
Insert and delete rows and columns • Insert and delete
selected cells |
Page Layout
| Change paper size and orientation • Set
page margins and alignment • Scale print output to fit a
defined number of pages • Print column and row titles and
set other options • View a worksheet in Print Preview •
Change margin and column widths in Print Preview • Insert
and remove a page break • Set up headers and footers • Add
fields in headers and footers (page number, date/time, file
information) |
Printing Worksheets and Workbooks
| Print a worksheet • Print a workbook (all
sheets in book) • Display formulas in worksheet cells •
Print a range of cells • Set, print, and clear a print area
• Print a group of worksheets • Print to a file |
Creating a Chart
| Use the Chart Wizard to create different
chart types • Reposition, resize, and delete a chart •
Change the chart type • Preview and print a chart • Move and
copy a chart
|
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form |
