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.
Excel 2003 Advanced Course
1 Vlookup Functions
Guided exercise 1 – Using a table with index values that are sorted
Guided exercise 2 – Using a table with index values that are not sorted
1.2 VLOOKUP with multiple criteria (nested lookup)
2 Naming ranges
3 Pivot Tables
Guided exercise 3 – creating a pivot table
3.2 grouping dataGuided exercise 4
3.3 viewing details
3.4 the pivot table toolbar
3.5 Field settings screen
4 financial functions
Guided exercise 4 – calculating loan repayments
5 data input tables
Guided exercise 5 – one input data table
Guided exercise 6 – two input data table
6 using Drop down lists in excel
6.1 Other validation options
a) Allow only whole numbers
b) Allow a date within a time frame
c) Allow a time within a time frame
d) Allow text within a length
e) Calculate what is allowed based upon the contents of another cell
7 error trapping
8 PROTECTING formulae
Guided Exercise 7
9 database and other functions
SHORT CUT KEYS