Pobol y We
Llwyn
Lôn Dryll
Llanfairpwll
Ynys Môn / Anglesey
LL61 5PQ
Llwyn
Lôn Dryll
Llanfairpwll
Ynys Môn / Anglesey
LL61 5PQ
01248 712614
07743 389652
07521 761498
07743 389652
07521 761498
Online - IT Modules
Microsoft EXCEL 2003
Microsoft EXCEL 2003
EACH MODULE is Downloadable
contains...
VIDEOS
HANDOUTS
Excel spreadsheets
Tasks
Exercises
contains...
VIDEOS
HANDOUTS
Excel spreadsheets
Tasks
Exercises
Why not try our user friendly, web-based modules!
STEP 1:
view the video
STEP 2:
look at the Handout
STEP 3:
have a go at the Tasks
STEP 4:
Try the Exercise!
[step-by-step Instructions given ]
view the video
STEP 2:
look at the Handout
STEP 3:
have a go at the Tasks
STEP 4:
Try the Exercise!
[step-by-step Instructions given ]
__________________________________________________________
Product Code: x3m1 File size: 19.1MB Price: £15.63
Module 1
[VIDEOS]
Opening Excel and Main Features
Closing and Opening a Workbook
Inserting data, active cell, naming cells, aligning text & numbers, using the TAB key to move to different cells, using the Formatting Toolbar, re-sizing columns, using the Format Cells Dialog Box.
HANDOUT: EXCEL 2003 Main Features + Menus/Toolbars [.pdf]
TASK: Open & create a new workbook [.pdf]
EXERCISE : Input data, close & save I [.pdf]
__________________________________________________________
Product Code: x3m2 File size: 14.1MB Price: £13.65
Module 2
[VIDEOS]
Cursor Points in Excel
Company Workbook 1:
Inputting Data
Align Text & Figures
Merge & centre, + cell borders
HANDOUT: Cursor Pointers in Excel [.pdf]
TASK: SAVING YOUR WORKBOOK [spreadsheet] [.pdf]
EXERCISE 1 + 2 : Company Workbook [.pdf] __________________________________________________________
Product Code: x3m3 File size: 2.78MB Price: £2.27
Module 3
[VIDEOS]
Company Workbook 1:
Background colour, border to cells
Re-size column width
Change Font Style
EXERCISE 3 : Company Workbook - add background colour + border to cells, re-size columns, change font, save [.pdf] _________________________________________________________
Product Code: x3m4 File size: 3.30MB Price: £3.98
Module 4
[VIDEOS]
Company Workbook 1
Inserting and copying a formula
Inputting data, use fill handle + copy & paste
EXERCISE 4 : Company Workbook - inserting & copying
a formula, inputting data, use fill handle , copy & paste [.pdf] __________________________________________________________
Product Code: x3m5 File size: 2.75MB Price: £3.73
Module 5
[VIDEOS]
Company Workbook
Inserting and copying a formula across cells | autosum
| fill handle | centre align text | Inputting data |
copy & paste | selecting cells | typing the SUM formula |
copying formula | format cells | left align text |
add background color and border to cells.
EXERCISE 5 : Company Workbook - insert a formula, use autosum, copy formula across row, centre-align row, type in sum formula, copy & paste formula down the column, format cell borders, add bold, align cells, add italic, print, save [.pdf]
__________________________________________________________
Product Code: x3m6 File size: 3.67MB Price: £3.32
Module 6
[VIDEOS]
Format cells to show currency [£] symbol + add a border
Insert a row, input data, copy formula
EXERCISE 6: Format cells to show currency [£] symbol
+ add a border, insert a row, input data & copy a formula
[.pdf]
__________________________________________________________
Product Code: x3m7 File size: 3.85MB Price: £3.60
Module 7
[VIDEOS]
Inserting a copyright © symbol
Fill data to adjacent cells , when part of a series
i.e. Monday, Tuesday, etc using fill handle
Fill Right & Fill Down
EXERCISE 7 : Inserting a copyright © symbol
Fill data to adjacent cells , when part of a series
i.e. Monday, Tuesday, etc using fill handle
Fill Right & Fill Down [.pdf]
__________________________________________________________
Product Code: x3m8 File size: 3.93MB Price: £2.98
Module 8
[VIDEOS]
Insert a formula to calculate daily cost, change font
colour, add line borders, fill colour, bold, copy formula
& resize column
Insert a Data
EXERCISE 8: Insert a formula to calculate daily cost,
change font colour, add line borders, fill colour, bold,
copy formula & resize column Insert a Data [.pdf]
__________________________________________________________
Product Code: x3m9 File size: 11.5MB Price: £16.12
Module 9
[VIDEOS]
Create a chart
Deleting Rows & Columns
Sorting Data using Auto Filter
EXERCISE 9 : Create a Chart [.pdf]
TASK : Open an Excel document "Sorting Sandwiches -
DATA.xls" and create your own searches using the
different filters [.pdf]
__________________________________________________________
Product Code: x3m10 File size: 5.39MB Price: £3.80
Module 10
[VIDEOS]
Saving your Workbook
Print and Print Preview
Personal Options for a Workbook
Product Code: x3m1 File size: 19.1MB Price: £15.63
Module 1
[VIDEOS]
Opening Excel and Main Features
Closing and Opening a Workbook
Inserting data, active cell, naming cells, aligning text & numbers, using the TAB key to move to different cells, using the Formatting Toolbar, re-sizing columns, using the Format Cells Dialog Box.
HANDOUT: EXCEL 2003 Main Features + Menus/Toolbars [.pdf]
TASK: Open & create a new workbook [.pdf]
EXERCISE : Input data, close & save I [.pdf]
__________________________________________________________
Product Code: x3m2 File size: 14.1MB Price: £13.65
Module 2
[VIDEOS]
Cursor Points in Excel
Company Workbook 1:
Inputting Data
Align Text & Figures
Merge & centre, + cell borders
HANDOUT: Cursor Pointers in Excel [.pdf]
TASK: SAVING YOUR WORKBOOK [spreadsheet] [.pdf]
EXERCISE 1 + 2 : Company Workbook [.pdf] __________________________________________________________
Product Code: x3m3 File size: 2.78MB Price: £2.27
Module 3
[VIDEOS]
Company Workbook 1:
Background colour, border to cells
Re-size column width
Change Font Style
EXERCISE 3 : Company Workbook - add background colour + border to cells, re-size columns, change font, save [.pdf] _________________________________________________________
Product Code: x3m4 File size: 3.30MB Price: £3.98
Module 4
[VIDEOS]
Company Workbook 1
Inserting and copying a formula
Inputting data, use fill handle + copy & paste
EXERCISE 4 : Company Workbook - inserting & copying
a formula, inputting data, use fill handle , copy & paste [.pdf] __________________________________________________________
Product Code: x3m5 File size: 2.75MB Price: £3.73
Module 5
[VIDEOS]
Company Workbook
Inserting and copying a formula across cells | autosum
| fill handle | centre align text | Inputting data |
copy & paste | selecting cells | typing the SUM formula |
copying formula | format cells | left align text |
add background color and border to cells.
EXERCISE 5 : Company Workbook - insert a formula, use autosum, copy formula across row, centre-align row, type in sum formula, copy & paste formula down the column, format cell borders, add bold, align cells, add italic, print, save [.pdf]
__________________________________________________________
Product Code: x3m6 File size: 3.67MB Price: £3.32
Module 6
[VIDEOS]
Format cells to show currency [£] symbol + add a border
Insert a row, input data, copy formula
EXERCISE 6: Format cells to show currency [£] symbol
+ add a border, insert a row, input data & copy a formula
[.pdf]
__________________________________________________________
Product Code: x3m7 File size: 3.85MB Price: £3.60
Module 7
[VIDEOS]
Inserting a copyright © symbol
Fill data to adjacent cells , when part of a series
i.e. Monday, Tuesday, etc using fill handle
Fill Right & Fill Down
EXERCISE 7 : Inserting a copyright © symbol
Fill data to adjacent cells , when part of a series
i.e. Monday, Tuesday, etc using fill handle
Fill Right & Fill Down [.pdf]
__________________________________________________________
Product Code: x3m8 File size: 3.93MB Price: £2.98
Module 8
[VIDEOS]
Insert a formula to calculate daily cost, change font
colour, add line borders, fill colour, bold, copy formula
& resize column
Insert a Data
EXERCISE 8: Insert a formula to calculate daily cost,
change font colour, add line borders, fill colour, bold,
copy formula & resize column Insert a Data [.pdf]
__________________________________________________________
Product Code: x3m9 File size: 11.5MB Price: £16.12
Module 9
[VIDEOS]
Create a chart
Deleting Rows & Columns
Sorting Data using Auto Filter
EXERCISE 9 : Create a Chart [.pdf]
TASK : Open an Excel document "Sorting Sandwiches -
DATA.xls" and create your own searches using the
different filters [.pdf]
__________________________________________________________
Product Code: x3m10 File size: 5.39MB Price: £3.80
Module 10
[VIDEOS]
Saving your Workbook
Print and Print Preview
Personal Options for a Workbook
Product Code: x3c2 File size: 70MB
TO BUY THE COMPLETE COURSE [10 modules]
25 VIDEOS
2 HANDOUTS
3 TASKS
10 EXERCISES
... a TOTAL of 40 RESOURCES
for the complete course!!
TO BUY THE COMPLETE COURSE [10 modules]
25 VIDEOS
2 HANDOUTS
3 TASKS
10 EXERCISES
... a TOTAL of 40 RESOURCES
for the complete course!!
or
BUY the entire COURSE
BUY the entire COURSE
You can BUY individual MODULES
... a SAVING of 20% discount
... your bargain price will only be £69.00
... your bargain price will only be £69.00
NO VAT!!
View Cart
top
top
top
top
top
After purchase, you will be directed to a download section where the zip file containing all resources can be downloaded to your computer.
Excel 2003 - Zip instructions
pdf file - Zip instructions
Excel 2003 - Zip instructions
pdf file - Zip instructions
If you are unable to open .pdf files, you might need the latest Adobe Reader upgrade - please click HERE
Module1 | Module 2 | Module 3 | Module 4 | Module 5 |
Module 6 | Module 7 |Module 8 | Module 9 | Module 10 |
Module 6 | Module 7 |Module 8 | Module 9 | Module 10 |
20%
OFFER
OFFER