This is not a book for beginning Excel users. If you have absolutely no experience with Excel, this
is probably not the best book for you — unless you’re one of a rare breed who can learn a new
software product almost instantaneously.
To get the most out of this book, you should have some background using Excel. Specifically, I
assume that you know how to
Create workbooks, insert sheets, save files, and complete other basic tasks
Navigate through a workbook
Use the Excel 2010 Ribbon and dialog boxes
Use basic Windows features, such as file management and copy and paste techniques
Take a minute to skim this section and learn some of the typographic conventions used throughout
this book.
Keyboard conventions
You need to use the keyboard to enter formulas. In addition, you can work with menus and dialog
boxes directly from the keyboard — a method you may find easier if your hands are already
positioned over the keys.
Formula listings
Formulas usually appear on a separate line in monospace font. For example, I may list the following
formula:
=VLOOKUP(StockNumber,PriceList,2,False)
Excel supports a special type of formula known as an array formula. When you enter an array formula,
press Ctrl+Shift+Enter (not just Enter). Excel encloses an array formula in brackets in order
to remind you that it’s an array formula. When I list an array formula, I include the brackets to
make it clear that it is, in fact, an array formula. For example:
{=SUM(LEN(A1:A10))}
No comments:
Post a Comment