Guided Computer Tutorials Software Training

Current Tutorials
Microsoft
	Access 2007
	Access 2003
	Access 97
	Excel 2007
	Excel 2003/2004
	PowerPoint 2007
	PowerPoint 2003
	PowerPoint 2004
	Word 2007
	Word 2003
	Word 2004
Adobe
	Illustrator CS4
	Photoshop CS4
	Photoshop CS3
	Photoshop CS3 Applications
	Photoshop Elements 8
	Photoshop Elements 7
	Photoshop Elements 6
	Photoshop Elements 3
	Flash CS4
	Flash CS3
	Flash 8
	Flash MX 2004
	Flash MX
	DreamWeaver CS4
	DreamWeaver CS3
	DreamWeaver 8
	DreamWeaver MX 2004
	DreamWeaver MX
	DreamWeaver 4.0
	InDesign CS4
	InDesign CS3
	InDesign CS
	PageMaker 7.0
Other
	PIT Book 1 Support Files
	PIT Book 2 Support Files
	Sample IT Projects
	Kahootz 3
	Kahootz 2
	FileMaker Pro 10
	FileMaker Pro 8
	FileMaker Pro 7
	FileMaker Pro 6.0
	iMovie HD 5.0
	iPhoto 5.0
	VectorWorks 9.0

Microsoft Excel Activities 2003/2004
by Greg Bowden

The tutorials have been developed for Microsoft Excel 2003 on the Windows system and Microsoft Excel 2004 on the Macintosh system. They are available in PDF format and Module 1 is also available as podcasts.

Module 1: Introduces the Excel basics of entering labels, values and formulas, formatting cells and worksheets, copying cell data, creating charts and using the drawing tools.

Module 2: Introduces advanced Excel features including IF statements, Lookup Commands, creating sales invoices, payroll/payslip systems, creating macros, financial and date calculations, AutoFormat, styles and save options.

More Details and Examples | Download Product

Contents and Sample Pages

Sample pages from each chapter can be downloaded. The sample pages contain COMPRESSED screen pictures so their quality is lower than the actual product. The sample podcasts provide the first few minutes of the prodcast and they are the QuickTime Player versions.

Module 1: Introductory Excel Activities

Contents	view pages (88k)
Chapter 1: Introduction to Microsoft Excel (24 pages)
Chapter 2: Formatting Cells (24 pages)	view sample prodcast (2.6MB)
Chapter 3: Further Formatting (15 pages)	view sample pages (688k)
Chapter 4: Copying Cell Data (20 pages)	view sample pages (740k)
Chapter 5: Larger Spreadsheets (15 pages)	view sample prodcast (2.3MB)
Chapter 6: Using Worksheets (14 pages)	view sample pages (552k)
Chapter 7: Displaying Data in Charts (19 pages)	view sample prodcast (2.7MB)
Chapter 8: More Detailed Charts (22 pages)	view sample pages (640k)
Chapter 9: The Drawing Tools (15 pages)	view sample prodcast (2.5MB)
Module 1 Project (Multi- user version only)

Top

Module 2: Advanced Excel Activities

Contents	view pages (88k)
Chapter 10: Making Predictions with Excel (12 pages)
Chapter 11: Making Decisions with Excel (16 pages)	view sample pages (532k)
Chapter 12: Lookup Commands (11 pages)
Chapter 13: Creating Sales Invoices (30 pages)	view sample pages (540k)
Chapter 14: Sharing Data Between Files (24 pages)
Chapter 15: Using Macros and Buttons (24 pages)	view sample pages (612k)
Chapter 16: Payroll Systems (16 pages)	view sample pages (504k)
Chapter 17: Financial Applications (17 pages)
Chapter 18: Date Calculations (14 pages)	view sample pages (432k)
Chapter 19: Useful Tools (12 pages)
Module 2 Project (Multi-user version only)

Top | More Details and Examples | Download Product