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.
CONTENTS
The Spreadsheet Window
1.Opening a spreadsheet
2.Saving a file
3.What is a spreadsheet
3.1 moving around a spreadsheet
3.2 selecting a range of cells
3.3 select a row or column
3.4 move or copy the contents of cell(s)
3.5 delete cell contents
3.6 insert rows or columns
3.7 to make the contents of a cell bold
3.8 changing the width of a column
Method 1 (recommended)
Method 2
Method 3
3.9 edit text in cells a) Replacing all of the contents of a cell
b) Making minor changes to the contents of a cell
4. Using formulae for calculations
4.1 order of operations
5.Formula Error messages
6. Formatting cells
6.1 change the way that numbers are displayed
6.2 alignment6.3 borders
6.4 pattern (coloured cells)
7. Inserting a 'series'
7.1 copying formulas from one cell to another
8. Absolute references
8.1 where to place the absolute reference signs in the formulae
9.A quick way to place the $ sign
10. Graphs
10.1 changing the chart 10.2 changing the size of the chart
10.3 edit the title of the chart
10.4 changing the type of chart
10.5 changing the axis 10.6 copying the chart into a word document
10.7 using paste 10.8 using the paste-link
11. Printing formulas
12. Printing a spreadsheet - page setup options
12.1 page
12.2 margins
12.3 header/footer
12.4 sheet
12.5 print the spreadsheet or a selected range
13. Autofilter
14. Freezing Panes
15. Short Cut Keys