These documents are for use with any version of Microsoft Office software from Office 97 to 2003. I wrote the first versions over 10 years ago for students at Sheffield Hallam University, and have improved and updated them since then as new versions of the software have been released. I have now revised them for a general readership. There is a companion document intended for complete beginners at computing: IT Essentials: Windows, Word and the Web.
The files available here are in PDF (Adobe Acrobat Reader) format. Non-profit organisations wishing to modify and distribute them for their own use are able to obtain the files in Word document format, but must apply to Sheffield Hallam University, who hold the copyright. Contact Paul Buckley, Head of Academic IT Services, LITS (e-mail email@example.com).
Note: As is standard with PDF files, printed quality of small text (such as in illustrations of menu items) is much better than it looks onscreen. For optimum onscreen image quality, files should be viewed at 100% size.
Making IT happen with MS Word
|Assumes some experience of Windows and Word. Aims to provide advanced-level knowhow of the Word features which you are most likely to find useful in an office or academic context. Covers working with graphics; advanced formatting including styles and templates; mailmerge including labels; troublefree tables; tables of contents; section breaks; footnotes + more.|
Making IT happen with MS Excel
PDF format (455kb)
|No previous Excel knowledge is assumed, but requires some familiarity with Windows and word-processing basics. Covers entering, laying out and formatting data; using formulae and functions; organising data in lists; creating charts;importing, exporting and printing data.|
Making IT happen with MS Access
PDF format (776kb)
|No previous Access knowledge is assumed, but requires some familiarity with Windows and word-processing basics. Covers creating a database and entering data; finding,sorting, filtering and querying; formatting and printing; improving form and report layout; importing and exporting data; relating tables within a database.|
|IT Essentials: Windows, Word and the Web
- to follow
|Intended mainly for "oldies" who are new to computers. Windows, word processing, and Internet basics; file management and file size issues. Currently being revised to incorporate email basics.|
Jos Kingston's homepage