Microsoft Office Tutorials and References
In Depth Information
Chapter 14: The Ten Commandments of Excel 2013
The Ten Commandments
of Excel 2013
When working with Excel 2013, you discover certain do’s and don’ts
that, if followed religiously, can make using this program just
heavenly. Lo and behold, the following Excel Ten Commandments contain just
such precepts for eternal Excel bliss.
10. Thou shalt commit thy work to disk by saving thy changes often (click-
eth or tappeth the Save button on the Quick Access toolbar or presseth
Ctrl+S). To saveth thy file in the almighty cloud so that thou may easily
access thy workbook from any of thy computing devices, selecteth a
folder on thy SkyDrive.
9. Thou shalt nameth thy workbooks when saving them the first time with
filenames of no more than twelve score and fifteen characters (255),
including spaces and all manner of weird signs and symbols. So, too, thou
shalt mark well into which folder thou savest thy file lest thou thinkest in
error that thy workbook be lost when next thou hast need of it.
8. Thou shalt not spread wide the data in thy worksheet, but rather thou
shalt gather together thy tables and avoideth skipping columns and
rows unless this is necessary to make thy data intelligible. All this thou
shalt do in order that thou may conserve the memory of thy computer.
7. Thou shalt begin all thy Excel 2013 formulas with = (equal) as the sign
of computation. If, however, ye be formerly of the Lotus 1-2-3 tribe, thou
shalt haveth special dispensation and can commence thy formulas with
the + sign and thy functions with the @ sign.
6. Thou shalt select thy cells before thou bringeth any Excel command to
bear upon them, just as surely as thou doth sow before thou reapeth.
5. Thou shalt useth the Undo feature (clicketh or tappeth the Undo
button on the Quick Access toolbar or presseth Ctrl+Z) immediately
upon committing any transgression in thy worksheet so that thou
mayest clean up thy mess. Should thou forgeteth to useth thy Undo
feature straightaway, thou must select the action that thou wouldst undo