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 Naming ranges
1.1 The Name manager
Guided Exercise 1 – naming a range
2 Pivot Tables
Guided Exercise 2 – Creating a Pivot Table
2.1 changing the calculation option in a field
2.2 grouping data
Guided exercise 3 – grouping data
2.3 showing field detail
Guided Exercise 4 – Show field detail
2.4 the report filter
Guided Exercise 5 – Use the Report Filter
2.5 refresh data
Guided Exercise 6 – Refresh Data
2.6 the design toolbar
3 Vlookup Functions
Guided exercise 7 – Using a table with index values that are sorted
Guided exercise 8 – Using a table with index values that are not sorted
3.1 LOOKUP with multiple criteria (nested lookup)
4 financial functions
Guided exercise 9 – Calculating loan repayments
5 data input tables
Guided exercise 10 – one input data table
Guided exercise 11 – two input data table
6 Using Drop down lists in excel
Guided Exercise 12 – choosing data from a list
6.1 Other validation options
7 error trapping
8 PROTECTING formulae
Guided Exercise 13
9 DAtabase and other functions
10 SHORT CUT KEYS