Advanced features for data manipulation and analysis of Excel 2002

Provide an overview of the advanced features of data manipulation and analysis of Excel 2002

• Using macros in Excel 2002
• After completing this topic, you should be able to use macros in Excel 2002.
• Recording and executing a macro in Excel 2002
• After completing this topic, you should be able to record and run a macro in Excel 2002.
• Modify and delete macros in Excel 2002
• After completing this topic, you should be able to modify and delete macros in Excel 2002.
• Modifying a macro in Excel 2002
• After completing this topic, you should be able to edit a macro in Excel 2002.
• Using macros to buttons in Excel 2002
• After completing this topic, you should be able to assign a macro to a command button in Excel 2002.
• Creating and modifying macros in Excel 2002
• After completing this topic, you should be able to create and edit macros in Excel 2002.
• Importing Data in Excel 2002
• After completing this topic, you should be able to import data from other applications to an Excel 2002 workbook.
• Importing data from the Web in Excel 2002
• After completing this topic, you should be able to import data from Excel Web in 2002.
• Importing an HTML table in Excel 2002
• After completing this topic, you should be able to import an HTML table in Excel 2002.
• Excel data export to other applications
• After completing this topic, you should be able to export data to other applications Excel 2002.
• Export data to Excel 2002 Web
• After completing this topic, you should be able to export data from Excel 2002 to a web page.
• Dynamic table reports Excel 2002
• After completing this topic, you should be able to create and modify reports dynamic table in Excel 2002.
• Creating a dynamic report table in Excel 2002
• After completing this topic, you should be able to create and modify a dynamic report table in Excel 2002.
• Calculations of dynamic table in Excel 2002
• After completing this topic, you should be able to perform calculations in table dynamic reports in Excel 2002.
• Performing calculations of dynamic table in Excel 2002
• After completing this topic, you should be able to perform calculations of dynamic table in Excel 2002.
• Dynamic publishing tables in Excel 2002 Web