Excel 2007 Book Excerpts Are Available
I just found out that Wiley has made available quite a few excerpts from some of my Excel 2007 Books.
These excerpts are all at Microsoft's site. They are in *.MHT format, so you'll need Internet Explorer to read them. Or, you can download the files and open them with Microsoft Word.
Excerpts
from
Excel 2007 Charts:
- A chart maker's check list
- Adding lines and backgrounds to a chart
- Chart accuracy
- Charting a noncontiguous range
- Creating a box plot
- Creating a comparative histogram
- Creating a multiline category axis
- Creating a thermometer chart
- Creating a timeline
- Displaying multiple charts on a chart sheet
- Don't be tempted by 3-D charts
- Introducing Excel charts
- Problems with pie charts
- Understanding series names
- Using time-scale axes
Excerpts
from
John Walkenbach's Favorite Excel 2007 Tips & Tricks:
- Annotating a chart
- Creating worksheet-level names
- Dealing with missing data in a line chart
- Knowing when to use absolute references
- Knowing when to use mixed references
- Making a worksheet "very hidden"
- Returning the last nonblank cell in a column or row
- Summing across sheets
- Understanding workbooks versus windows
- Updating old fonts
- Using AutoSum tricks
- Using the status bar selection statistics feature
- Various methods for rounding numbers
Excerpts
from
Excel 2007 Bible:
- Applying number formatting
- Creating your first worksheet
- Getting to know the formatting tools
- How Excel handles dates and times
- Understanding array formulas
- Understanding custom Excel templates
- Understanding formula basics
- Understanding workbooks and worksheets
- Using different fonts
Excerpts
from
Excel 2007 Formulas:
- Reader Comments -
(No comments have been posted for this item.)
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.