The Excel 2007 Advanced series teaches you to apply filters, use formulas and analyze data. You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel.
This Excel 2007 Advanced online training series provides over 12 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Excel 2007 Advanced: Adding Connections and Importing Data
2 . Excel 2007 Advanced: Automating with VBA Macros
3 . Excel 2007 Advanced: Filtering and Sorting Data
4 . Excel 2007 Advanced: Using Data Analysis Tools
5 . Excel 2007 Advanced: Using Pivot Tables
6 . Excel 2007 Advanced: Working with Functions
Lesson Detail:
Excel 2007 Advanced: Adding Connections and Importing Data
This course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.
Excel 2007 Advanced: Automating with VBA Macros
This course introduces the use of macros in Excel 2007.
Excel 2007 Advanced: Filtering and Sorting Data
This course provides information on how to filter and sort your worksheets in Excel 2007.
Excel 2007 Advanced: Using Data Analysis Tools
This course provides an introduction to the commands used to analyze data in Excel 2007.
Excel 2007 Advanced: Using Pivot Tables
This course explains how to create and use pivot tables in Excel 2007.
Excel 2007 Advanced: Working with Functions
This course introduces the use of Excel 2007 functions.
Certification:
Excel 2007 Advanced
Audience:
This series is for anyone interested in learning about advanced data analysis features of Excel 2007.
Features:
What You Get:
You will receive Unlimited Access to all of the Excel 2007 Advanced training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Desktop Computing Package which includes all of the Excel 2007 Advanced training courses listed above plus hundreds of hours of related online training courses