Microsoft Excel 2007 Advanced

Topics: 6

Length: 12 hours

Excel can be an exceptionally powerful tool in today's modern business environment. Utilising it to it's full potential can create huge advantages. The Excel 2007 Advanced series will show you to apply filters, analyze data and use formulas. You will be able to create complex business applications and analyses in Microsoft Excel 2007.

Topic 1: Filtering and Sorting Data

Following this course you will be able to filter and sort your worksheets in Excel 2007, remove duplicate records, and apply one-click, multiple-level, and custom sorts to your data.

Topic 2: Using Pivot Tables

You will be shown how to create and use pivot tables, including viewing, formatting, grouping and exploring Pivot Tables in Excel 2007.

Topic 3: Working with Functions

This topic introduces the use of functions in Excel 2007. You will learn basic Maths functions, date and time and logic functions, along with using statistical functions to determine relationships.

Topic 4: Using Data Analysis Tools

You will learn about thie commands used to analyze data in Excel 2007, including What-If analysis, Scenario Manager and Goal seek.

Topic 5: Automating with VBA Macros

This will teach you how to automate tasks using Macros and Visual Basic for Applications.

Topic 6: Adding Connections and Importing Data

Excel allows you to connect worksheets and workbooks for quick and automatic sharing and updating. This course provides details about importing information from the Web, XML data, text files, Access documents, and other files from external data sources.