June 2007
Intermediate to advanced
1224 pages
35h 32m
English
book
Office 2007 Bible
by John Walkenbach, Herb Tyson, Faithe Wempen, Cary N. Prague, Michael R. Groh, Peter G. Aitken, Michael R. Irwin, Gavin Powell, Lisa A. Bucki
Content preview from Office 2007 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Top Excel Options
Not surprisingly, many of Excel’s options have to do with calculations, but there are also options for proofing and editing. These are other Excel options you may need to know, by category:
Formulas. The section names in this category (see Figure A-4) do a good job of identifying the purpose of the options in this category. If you have a large worksheet that recalculates slowly, you can click the Manual option button under Workbook Calculation in the Calculation Options section and then press F9 to recalculate the sheet manually when needed. Under Working with Formulas, you can turn Formula AutoComplete on and off. The Error Checking and Error Checking Rules sections offer numerous settings for turning formula error checking on and off as well as identifying which errors Excel should flag.
Proofing. The choices that appear in this category are a subset of those that appear in Word. You can control AutoCorrect Options and use the settings under When Correcting Spelling in Microsoft Office Programs choices to fine-tune spell checking.
Advanced. This category also includes Editing Options for Excel, but they are different than those for Word. For example, with After Pressing Enter, Move Selection selected, you can use the Direction drop-down list to specify which direction the cell selector will move. You ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.