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
Course Location
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.
Courses you can instantly connect with... Do an online course on Microsoft Office starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Office 2016 Complete John AcademyAED 124
AED 2,644Duration: Upto 3 Days - AED 37
AED 918Duration: Upto 1 Hour
