Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Creating a Spreadsheet from Scratch
Chapter 2
Creating a Spreadsheet
from Scratch
In This Chapter
Starting a new workbook
Entering the three different types of data in a worksheet
Creating simple formulas by hand
Fixing your data-entry boo-boos
Using the AutoCorrect feature
Using the AutoFill and Flash Fill features to complete a series of entries
Entering and editing formulas containing built-in functions
Totaling columns and rows of numbers with the AutoSum button
Saving your precious work and recovering workbooks after a computer crash
After you know how to launch Excel 2013, it’s time to find out how not to
get yourself into trouble when actually using it! In this chapter, you find
out how to put all kinds of information into all those little, blank worksheet
cells I describe in Chapter 1. Here you find out about the Excel AutoCorrect
and AutoComplete features and how they can help cut down on errors and
speed up your work. You also get some basic pointers on other smart ways
to minimize the drudgery of data entry, such as filling out a series of entries
with the AutoFill and Flash Fill features as well as entering the same thing in a
bunch of cells all at the same time.
After discovering how to fill a worksheet with all this raw data, you find out
what has to be the most important lesson of all — how to save all that
information on disk so that you don’t ever have to enter the stuff again!
Search JabSto ::




Custom Search