MSC Computer Training Booklets
The booklets that are sold on this website have been developed over a number of years with the kind assistance of our customers, and it is they who suggested that we market and sell them as part of our service.
We pride ourselves on producing easy to follow booklets with simple instructions, Illustrations and Guided Exercises that deal with the practicalities of using the particular programme(s). These help to explain how to carry out the skills that you need to develop in any particular programme. Included in the cost of the booklets are:
• A CD containing exercise files
• Printed exercise sheets
• Postage and Packing
Our books are not ALL listed on the website so if you can’t see the skill that you need to develop in the contents list please contact us at enquiries@msctraining.co.uk and we can get back to you.
1 GENERAL NOTES AND THE EXCEL FOR WINDOWS SCREEN
2 STANDARD KEYBOARD LAYOUT
3 FIRST THINGS FIRST
3.1 MOVING AROUND THE SPREADSHEET
3.2 SELECTING A RANGE OF ADJACENT CELLS
4 THE HOME MENU
4.1 SELECT A ROW OR COLUMN
4.2 INSERT A ROW OR COLUMN
4.3 MOVE OR COPY THE CONTENTS OF A CELL OR COLUMN
4.4 DELETE CELL CONTENTS
4.5 DELETE ROWS OR COLUMNS
4.6 CHANGE THE WIDTH OF A COLUMN
a) Method 1 (recommended)
b) Method 2
c) Method 3
4.7 INSERT DATA INTO CELLS
a) Replacing all of the contents of a cell
b) Making minor changes to the contents of a cell
5 FORMULAE
Guided Exercise 1 :
5.2 CREATING FORMULAS
Guided Exercise 2: subtraction, multiplication and division
5.3 ORDER OF OPERATIONS
5.4 FORMULA ERROR MESSAGES
6 FORMATTING CELLS
6.1 COLOURED CELLS
6.2 TO MAKE THE CONTENTS OF A CELL BOLD, ITALIC OR UNDERLINED
6.3 BORDERS
6.4 WRAP TEXT
6.5 ALIGN THE CONTENTS OF CELLS
6.6 MERGE AND CENTRE CELLS
6.7 FORMATTING NUMBERS
Guided Exercise 3 – currency, wrap text, merge cells, borders,colours
7 INSERTING A ‘SERIES’
7.1 COPYING/REPLICATING FORMULAS FROM ONE CELL INTO ANOTHER
Guided Exercise 4 – replicating/copying formulae and inserting series
8 ABSOLUTE REFERENCES
Guided Exercise 5 - Using absolute references
b) Where To Place The Absolute Reference Signs In The Formulae
c) A Quick Way To Place The $ Sign
9 CHARTS
Guided Exercise 6 - Creating A Chart
9.1 CHANGING THE CHART
a) Chart/design menu
b) Chart/ Layout Menu
Using the Chart/layout menu
c) Chart /Format menu
Guided Exercise 7 – Formatting a Chart
9.2 COPYING THE CHART INTO A WORD DOCUMENT
a) Using Paste:
b) Using Paste-Link
10 PRINTING A SPREADSHEET
10.1 PAGE SETUP OPTIONS
a) Page Margins
b) Orientation
c) Paper Size
d) Print Titles
e) Header and Footer
10.2 PRINT OPTIONS
10.3 PRINTING FORMULAS
11 SOME USEFUL SHORT CUT KEYS