Advanced Excel 2007

This course provides a comprehensive overview of the more advanced features and functions of the Excel 2007 spreadsheet software, from producing a professional-looking financial statement to using charts and graphs to spot sales trends at a glance. It's compatible with 2007 operating systems.

• This course is for experienced computer users who are already confident users of Excel 2007

You'll learn how to:

• Filter and sort your worksheets
• Create, use and modify pivot tables
• Understand and use Excel 2007 functions
• Use commands to analyse data
• Use and customise macros
• Connect worksheets and workbooks for automatic sharing and updating
• Import information from the web, text files, XML data, Access documents, and other files from external data sources

Modules:

There are six modules in this eCourse:

• Filtering and Sorting Data
• Using Pivot Tables
• Working with Functions
• Using Data Analysis Tools
• Automating with VBA Macros
• Adding Connections and Importing Data

Course features:

You'll work through the course online, where you'll complete a series of exercises with actual Excel 2007 spreadsheets. A test at the end of the course lets you practise your new skills and check that you have understood all the techniques covered. You'll have access to this course for six months from the date of purchase - giving you plenty of time to finish your course.

How this course can help your business:

* Spot trends at a glance
* Get a clear view of current and projected business performance 
* Perform complex calculations and data analysis

Course Code: 104266BT032