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


 

Learning Microsoft Excel 2008
by Greg Bowden

The tutorials have been developed for Microsoft Excel 2008 on the Macintosh 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, financial and date calculations, AutoFormat, styles and save options.

More Details 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 (Both Modules) view pages (356k)
Chapter 1: Introduction to Microsoft Excel (27 pages)  
Chapter 2: Formatting Cells (26 pages) view sample pages (1.07 MB)
Chapter 3: Further Formatting (15 pages)  
Chapter 4: Copying Cell Data (22 pages) view sample pages (1.14 MB)
Chapter 5: Larger Spreadsheets (18 pages)  
Chapter 6: Using Worksheets (17 pages) view sample pages (808k)
Chapter 7: Displaying Data in Charts (16 pages)  
Chapter 8: More Detailed Charts (23 pages) view sample pages (1.03 MB)
Chapter 9: The Drawing Tools (24 pages) view sample pages (1.09 MB)
Module 1 Project (Multi- user version only)  

Top

Module 2: Advanced Excel Activities

Chapter 10: Making Predictions with Excel (12 pages)  
Chapter 11: Making Decisions with Excel (21 pages) view sample pages (831k)
Chapter 12: Lookup Commands (11 pages)  
Chapter 13: Creating Sales Invoices (30 pages) view sample pages (1.27 MB)
Chapter 14: Sharing Data Between Files (24 pages)  
Chapter 15: Payroll Systems (20 pages) view sample pages (752k)
Chapter 16: Financial Applications (18 pages) view sample pages (611k)
Chapter 17: Date Calculations (13 pages)  
Chapter 18: Useful Tools (11 pages)  
Module 2 Project (Multi-user version only)  

Top | More Details and Examples

 

Home | Products | Prices | Ordering | Podcasts | Downloads | Contact