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
1 Relative references
2 Absolute references
Guided Exercise 1
Guided exercise 2
2.2 A quick way to place the $ sign
3 If statements
Guided exercise 3
3.2 nested IF Statements
4 Working with multiple sheets
4.1 renaming sheets
Guided exercise 4
4.2 group formatting
Guided exercise
4.3 linking formula between sheets
Guided exercise 6
5 Freezing panes
6 Autofilter
6.1 Customised filter
6.2 Advanced filtering
7 Graphs
Guided exercise 7 – creating a chart
a) changing the chart
b) Change colours, font size and other visual aspects of the chart
Guided exercise 8
7.2 Copying the chart into a word document
8 Subtotals
Guided exercise 9 – using group totals
9 Protecting formulae
Guided Exercise 10
Short cut keys