Excel supports a special type of formula known as an array formula . When you enter an array for
mula, 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))}
You can use this book any way you please. If you choose to read it cover to cover while lounging
on a sunny beach in Kauai, that’s fine with me. More likely, you’ll want to keep it within arm’s
reach while you toil away in your dimly lit cubicle.
Due to the nature of the subject matter, the chapter order is often immaterial. Most readers will
probably skip around, picking up useful tidbits here and there. The material contains many exam-
ples, designed to help you identify a relevant formula quickly. If you’re faced with a challenging
task, you may want to check the index first to see whether the book specifically addresses your
No comments:
Post a Comment