Microsoft Office Tutorials and References
In Depth Information
Working with Excel Fundamentals
That’s it. Hey, you’re already on your way to being an Excel pro! Now that
you have a named area, you can easily select your data at any time. Just go to
the Name Box and select it from the list. Figure 1-10 shows how to select the
to find the
Tables work in much the same manner as named areas. Tables have a few
features that are unavailable to simple named areas. With tables you can
indicate that the top row contains header labels. Further, tables default to have
filtering ability. Figure 1-11 shows a table on a worksheet, with headings
and filtering ability.
With filtering, you can limit which rows show, based on which values you
select to display.
The Insert Ribbon contains the button to use for inserting a table.
Formatting your data
Of course you want to make your data look all spiffy and shiny. Bosses like
that. Is the number 98.6 someone’s temperature? Is it a score on a test? Is it
98 dollars and 60 cents? Is it a percentage? Any of these formats is correct: