Advanced features for data manipulation and analysis of Excel 2002 New Horizons Lebanon
Price: TBA
  • Duration: Upto 4 Hours

Course details

About Course:
  • 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 command buttons macros 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
Updated on 08 November, 2015

About New Horizons Lebanon

As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.

See all New Horizons Lebanon courses
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or