Chapter 01 Examples of Finished Projects ==> Click on link, then click Save and navigate to the
class notes folder:
Project15 Excel
Workbook: Example of Finished Project 15
Project16 Excel Workbook: Example of
Finished Project 16
Download Excel Workbook with Keyboard Shortcut
List
WorkbookExcelMagicTricks597-603StartFile&FinishedFile
(Trick #603)
Chapter 01 VBlogs (Streaming Videos) ==> Click to watch VBlog:
VBlog for Project15: Intro to
Excel 01 part 1
VBlog for Project15: Intro to
Excel 01 part 2
VBlog for Project16: Intro to Excel 02
Hint For homework in Ch 01
Excel Magic Trick 603: Why
100*1.1 = 110 Means Increase by 10%
Michael Girvin's Book and Chapter 02 and 03 Handouts and Start Files and VBlogs ==>
Before you read the textbook and do the homework problems for Chapter 02 and 03, you must read Michael Girvin's FREE book, "Excel Is Fun! Excel 2007."
Download Free book and workbook that goes along with book:
Download Excel Is Fun! book for Excel 2007
Download the Excel workbook file that accompanies the book
View on-line Excel Is Fun! book for Excel 2007
VBlogs (streaming videos) that accompanies the book:
VBlogPart01: What is Excel? and the Ribbon (Last few minutes of VBlog do not have a good picture)
VBlogPart02: QAT, Selecting, Formulas
VBlogPart03: More Formulas, Functions, Math
VBlogPart04: More Math, Alt Key, Functions, Names
VBlogPart05: Cell References, Copy/Move, Assumption Tables
VBlogPart06: Cell Formatting: %, $, Date, Time, the ROUND function
VBlogPart07: Charts, Page Setup
VBlogPart08: Data Analysis: Sort, Filter, Subtotals, PivotTables
VBlogPart09: IF function
After you have completed Chapter 01 in the textbook and you have read Michael Girvin's book and have watched all the VBlogs for the book, then you can complete the homework for chapter 02 and 03 in the textbook.