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

Learning Microsoft Excel 2007
by Greg Bowden

The tutorials have been developed for Microsoft Excel 2007 on the Windows system as single or multi-user versions. The multi-user version has assignments at the end of each chapter and a detailed project at the end of each Module so that students can practice the skills that they have learned from that chapter or module.

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 Spreadsheet features including IF statements, Lookup commands, creating sales invoices, payroll/payslip systems, creating macros, financial and date calculations, AutoFormat, styles and save options.

Chapter Descriptions

Contents and Sample Pages

Sample pages from chapters can be downloaded. The sample pages contain COMPRESSED screen pictures so their quality is lower than the actual product.

Module 1: Introductory Excel Activities

Contents	view pages (186k)
Chapter 1: Introduction to Microsoft Excel (27 pages)
Chapter 2: Formatting Cells (26 pages)	view sample pages (481k)
Chapter 3: Further Formatting (15 pages)	view sample pages (592k)
Chapter 4: Copying Cell Data (22 pages)	view sample pages (654k)
Chapter 5: Larger Spreadsheets (17 pages)
Chapter 6: Using Worksheets (18 pages)	view sample pages (450k)
Chapter 7: Displaying Data in Charts (19 pages)
Chapter 8: More Detailed Charts (24 pages)	view sample pages (711k)
Chapter 9: The Drawing Tools (25 pages)	view sample pages (585k)
Module 1 Project (Multi- user version only)

Top

Module 2: Advanced Excel Activities

Contents	view pages (187k)
Chapter 10: Making Predictions with Excel (12 pages)
Chapter 11: Making Decisions with Excel (19 pages)	view sample pages (443k)
Chapter 12: Lookup Commands (11 pages)	view sample pages (437k)
Chapter 13: Creating Sales Invoices (30 pages)	view sample pages (582k)
Chapter 14: Sharing Data Between Files (24 pages)
Chapter 15: Using Macros and Buttons (26 pages)	view sample pages (464k)
Chapter 16: Payroll Systems (20 pages)	view sample pages (424k)
Chapter 17: Financial Applications (18 pages)	view sample pages (478k)
Chapter 18: Date Calculations (13 pages)
Chapter 19: Useful Tools (12 pages)
Module 2 Project (Multi-user version only)

Top | More Details and Examples