Microsoft Office Tutorials and References
In Depth Information
CHAPTER FIVE Creating, Sorting, and Querying a Table
5 Creating, Sorting, and
Querying a Table
Objectives
You will have mastered the material in this chapter when you can:
Create and manipulate a table
Delete sheets in a workbook
Validate data
Add calculated columns to a table
Use icon sets with conditional
formatting
Use the VLOOKUP function to look
up a value in a table
Print a table
Add and delete records and change
fi eld values in a table
Sort a table on one fi eld or
multiple fi elds
Display automatic subtotals
Use Group and Outline features to
hide and unhide data
Query a table
Apply database functions, the SUMIF
function, and the COUNTIF function
Save a workbook in different fi le
formats
 
 
Search JabSto ::




Custom Search