Guided Computer Tutorials Software Training

Microsoft Tutorials
	Access 2010
	Access 2007
	Access 2003
	Excel 2010
	Excel 2011
	Excel 2007
	Excel 2008
	Excel 2003/2004
	PowerPoint 2010
	PowerPoint 2011
	PowerPoint 2007
	PowerPoint 2008
	PowerPoint 2003
	PowerPoint 2004
	Word 2010
	Word 2011
	Word 2007
	Word 2003
	Word 2004
Adobe Tutorials
	Photoshop CS5
	Photoshop CS4
	Photoshop CS3
	Photoshop CS3 Applications
	Photoshop Elements 8
	Photoshop Elements 7
	Photoshop Elements 6
	Photoshop Elements 3
	Flash CS5 & CS5.5
	Flash CS4
	Flash CS3
	DreamWeaver CS5 & CS5.5
	DreamWeaver CS4
	DreamWeaver CS3
	Illustrator CS5
	Illustrator CS4
	InDesign CS5 & CS5.5
	InDesign CS4
	InDesign CS3
	InDesign CS
	FireWorks CS5
	FireWorks CS4
Junior IT Courses
	PIT1 Support Files
	PIT2 Support Files
	PIT1 Office 2010 Files
	PIT2 Office 2010 Files
	PIT1&2 Adobe CS5 Files
	Sample IT Projects
Other Tutorials
	Kahootz 3
	Kahootz 2
	FileMaker Pro 10
	FileMaker Pro 8
	FileMaker Pro 7
	FileMaker Pro 6
	iMovie HD 5.0
	iPhoto 5.0
	Flash 8
	Flash MX 2004
	Flash MX
	DreamWeaver 8
	DreamWeaver MX 2004
	DreamWeaver MX
	DreamWeaver 4.0
	Access 97
	VectorWorks 9.0
	PageMaker 7.0

Learning Microsoft Excel 2010
by Greg Bowden (446 pages)

The tutorials have been developed for Microsoft Excel 2010 on the Windows system as single or multi-user versions. The files can be printed, followed onscreen next to the application or used on an iPad or similar device. Support Files are included that provide all the graphics used in the tutorials along with prepared spreadsheet templates so that students do not need to be continually creating spreadsheets from scratch. Assignments are provided at the end of each chapter and the multi-user version has a detailed project at the end of each Module.

Module 1: Introduces the Excel basics including entering labels, values and formulas, formatting cells and worksheets, copying cell data, creating different types of charts such as Pie, Column, Line, Bar and Sparkline charts, and using the drawing tools.

Module 2: Introduces advanced Spreadsheet features including IF statements, Lookup commands, creating Sales Invoices, creating Payroll/Payslip systems, using Macros and Buttons, financial and date calculations, creating Pivot Tables, applying Conditional Formatting, and using AutoFormat, Styles and Save options.

Click to view Prices, Chapter Descriptions and Examples

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 (Modules 1 & 2)	view pages (120k)
Chapter 1: Introduction to Microsoft Excel (27 pages)	view sample pages (481k)
Chapter 2: Formatting Cells (26 pages)	view sample pages (567k)
Chapter 3: Further Formatting (19 pages)	view sample pages (578k)
Chapter 4: Copying Cell Data (22 pages)	view sample pages (479k)
Chapter 5: Larger Spreadsheets (16 pages)
Chapter 6: Using Worksheets (18 pages)	view sample pages (467k)
Chapter 7: Displaying Data in Charts (19 pages)	view sample pages (514k)
Chapter 8: More Detailed Charts (24 pages)	view sample pages (818k)
Chapter 9: Sparkline Charts (9 pages)
Chapter 10: The Drawing Tools (25 pages)	view sample pages (572k)
Module 1 Project (Multi- user version only)

Top

Module 2: Advanced Excel Activities

Chapter 11: Making Predictions with Excel (12 pages)
Chapter 12: Making Decisions with Excel (19 pages)	view sample pages (396k)
Chapter 13: Lookup Commands (11 pages)
Chapter 14: Creating Sales Invoices (30 pages)	view sample pages (623k)
Chapter 15: Sharing Data Between Files (24 pages)	view sample pages (545k)
Chapter 16: Using Macros and Buttons (29 pages)	view sample pages (464k)
Chapter 17: Payroll Systems (20 pages)	view sample pages (572k)
Chapter 18: Financial Applications (18 pages)
Chapter 19: Date Calculations (13 pages)
Chapter 20: Pivot Tables (18 pages)	view sample pages (404k)
Chapter 21: Useful Tools (18 pages)
Module 2 Project (Multi-user version only)

Top | Chapter Descriptions and Examples