Theme: Office 2010

This tutorial uses a workbook and exercises provided on a disk to introduce Microsoft Excel 2007 for Windows. The course gives an introduction to spreadsheets, databases and charting.

The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs and managing small lists. This book is primarily designed for people who need to know how to use Microsoft Excel 2007 is designed for people new to the Excel environment. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions, and to use the sorting and filtering features to manage and analyse data. This course is intended for current Microsoft Excel 2007 users who wish to extend their knowledge and skills beyond building simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with automation and productivity features. It includes areas such as conditional formatting, validation and consolidation methods, data analysis tools, such as data tables, summarising, goal seeking and PivotTables, and ways of annotating worksheets to help when sharing information with others. This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

This is an introduction to the popular database software Microsoft Access 2007 for support staff. The course is aimed at those who have never used the package before and who would like to gain an overview of the package to get up and running. There is a fee for this course, see below.