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 ABSOLUTE REFERENCES
Guided Exercise 1 - Using absolute references
Where To Place The Absolute Reference Signs In The Formulae
A Quick Way To Place The $ Sign
2 IF STATEMENTS
Guided exercise 2
2.2 NESTED IF Statements
3 WORKING WITH MULTIPLE SHEETS
3.1 RENAMING SHEETS
Guided exercise 3
3.2 GROUP FORMATTING
Guided Exercise 4
3.3 lINKING FORMULAE BETWEEN SHEETS
Guided exercise 5
4 FREEZING PANES
Guided Exercise 6
5 AUTOFILTER
Guided Exercise 7
6 Customised filter
Guided Exercise 8
7 Custom sort
Guided Exercise 9
8 subtotals
Guided exercise 10 – using group totals
9 charts
Guided Exercise 11 - Creating A Chart
9.1 Changing The Chart
Chart/design menu
a) Change the chart type
b) Change the chart layout
Chart/ Layout Menu
Chart /Format menu
Guided Exercise 12 – Formatting a Chart
9.2 Copying the chart into a word document
Using Paste:
Using Paste-Link
10 PROTECTING formulae
Guided Exercise 13
SHORT CUT KEYS