Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Up and Running with Excel
Chapter 1: Up and Running
In This Chapter
✓ Creating an Excel workbook
✓ Understanding what a worksheet is
✓ Entering text as well as numeric, date, and time data
✓ Using the AutoFill command to enter lists and serial data
✓ Establishing conditional formats for text
✓ Setting up data-validation rules
This chapter introduces Microsoft Excel, the official number cruncher of
Office 2013. The purpose of Excel is to track, analyze, and tabulate
numbers. Use the program to project profits and losses, formulate a budget, or
analyze Elvis sightings in North America. Doing the setup work takes time,
but after you enter the numbers and tell Excel how to tabulate them, you’re
on Easy Street. Excel does the math for you. All you have to do is kick off
your shoes, sit back, and see how the numbers stack up.
This chapter explains what a workbook and a worksheet is, and how rows
and columns on a worksheet determine where cell addresses are. You also
discover tips and tricks for entering data quickly in a worksheet and how to
construct data-validation rules to make sure that data is entered accurately.
Creating a New Excel Workbook
Workbook is the Excel term for the files you create with the Excel. When you
create a workbook, you are given the choice of creating a blank workbook
or creating a workbook from a template.
A template is a preformatted workbook designed for a specific purpose, such
as budgeting, tracking inventories, or tracking purchase orders. Creating
a workbook from a template is mighty convenient if you happen to find a
template that suits your purposes, but in my experience, you almost always
have to start from a generic, blank workbook because your data is your own.
You need a workbook you create yourself, not one created from a template
by someone else.