Maria’s Guides

Sample Files from the Book.

The following sample files were created for use with Creating Spreadsheets and Charts with Microsoft Office Excel 2007: Visual QuickProject Guide. This book covers Excel 2007 for Windows only.

Each of these files represents the project workbook file at the end of a chapter. So if you wanted to follow the steps for Chapter 6 but didn’t want to do Chapters 1-5, you could download the Chapter 5 file and use that as a starting point.

• Chapter 2: Create a Workbook File
• Chapter 3: Build the Budget Worksheet
• Chapter 4: Duplicate the Worksheet
• Chapter 5: Consolidate the Results
• Chapter 6: Format the Worksheets
• Chapter 7: Add a Chart
• Chapter 8: Share Your Work

I add two excerpts from my upcoming Excel 2007 Visual QuickProject Guide to the book’s companion Web site.

I just added the following two excerpts for my Excel 2007 Visual QuickProject Guide to the list of book excerpts available for download. These files are in PDF format and are roughly 1 MB each:

• Front Matter, including Table of Contents and Introduction
• Excerpt from Chapter 3

These files should give you a good idea of how the book is laid out and what it contains.

The book should be available in stores by December month-end. It’s currently available for presale on Amazon.com for the excellent price of $11.55 (that’s 32% off).

Two Excerpts from Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide.

Want to see some sample pages from my Excel Visual QuickProject? Here are a few links.

• Front Matter (including complete Table of Contents)
• Excerpt from Chapter 3

Sample Files from the Book.

The following files either appeared in the book as illustrations or as sample exercises, or were created to provide additional examples of how Excel works. Be sure to check the comments for each file, if appropriate.

• Excel Basics (xls, 33k)
• Mixed References (xls, 10k)
• Functions (xls, 40k)
• Loan Amortization (xls, 170k)
• Database (xls, 281k)
• Text File (txt, 15k)
• Consolidation (xls, 22k)
• Web Publishing (zip, 5k)

Sample Files from the Book.

The following sample files were created for use with Creating Spreadsheets and Charts with Excel: Visual QuickProject Guide. This book covers Excel 2003 for Windows and Excel 2004 for Mac OS.

Each of these files represents the project workbook file at the end of a chapter. So if you wanted to follow the steps for Chapter 6 but didn’t want to do Chapters 1-5, you could download the Chapter 5 file and use that as a starting point.

• Chapter 2: Create a Workbook File
• Chapter 3: Build the Budget Worksheet
• Chapter 4: Duplicate the Worksheet
• Chapter 5: Consolidate the Results
• Chapter 6: Format the Worksheets
• Chapter 7: Add a Chart
• Chapter 8: Print Your Work