Advanced Data Management in Excel 2002

Provide an overview of the advanced management features and data organization Excel 2002

• Using templates in Excel 2002
• After completing this topic, you should be able to use and customize templates in Excel 2002.
• Creating a template in Excel 2002
• After completing this topic, you should be able to customize and save books as templates in Excel 2002.
• Working with smart tags in Excel 2002
• After completing this topic, you should be able to use smart tags in Excel 2002.
• Using styles in Excel 2002
• After completing this topic, you should be able to use styles in Excel 2002.
• Creating styles in Excel 2002
• After completing this topic, you should be able to create and save styles in Excel 2002.
• Advanced Printing in Excel 2002
• After completing this topic, you should be able to print gridlines, row and column titles and formulas in Excel 2002.
• Working with templates in Excel 2002
• After completing this topic, you should be able to create templates in Excel 2002.
• Custom number formats in Excel 2002
• After completing this topic, you should be able to use advanced number formats in Excel 2002.
• Using advanced number formats in Excel 2002
• After completing this topic, you should be able to create, apply and remove custom number formats in Excel 2002.
• Conditional formatting in Excel 2002
• After completing this topic, you should be able to apply conditional formats to cells in Excel 2002.
• Creating and copying conditional formatting in Excel 2002
• After completing this topic, you should be able to create and apply conditional formatting to other cells in Excel 2002.
• Sorting and filtering data in Excel 2002
• After completing this topic, you should be able to sort and filter data lists in Excel 2002.
• Calculation of subtotals in Excel 2002
• After completing this topic, you should be able to find subtotals for data in Excel 2002.
• Sorting, filtering and subtotal data in Excel 2002
• After completing this topic, you should be able to sort, filter and find subtotals for data lists in Excel 2002.
• Clustering and data schemas in Excel 2002
• After completing this topic, you should be able to group and outline a list of data in Excel 2002.
• SEARCH function in Excel 2002
• After completing this topic, you should be able to group and outline a list of data in Excel 2002.