Microsoft Excel Advanced

Overview

Course duration: 1 day.

By the end of this course you will be able to confidently use the analysis tools to analyse data and make projections. You will learn how toconfidently import and query data from other sources and create, run, edit and assign macros, using the provided manual if required.

This course is run in partnership with 2e2 Training.

Is it right for me?

This course is designed for students who have completed the Excel Intermediate course or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.

This course can be run in versions 2000 / 2002 / 2003 and 2007.

What will it cover?

Advanced Formulas

• Using Names
• Decision-Making
• Nesting
• Financial Functions

Data Tables

• MATCH and INDEX
• Data Tables

Advanced List Management

• Subtotals
• Data Validation
• Database Functions
• Data Forms

Analytical Options

• Goal Seek And Solver
• Scenarios
• Views
• Reports

Pivot Tables

• Creating A Pivot Table
• Rearranging Pivot Tables
• Formatting Pivot Tables
• Pivot Charts

Exporting And Importing

• Exporting & Importing Data
• Querying External Databases

Working With Multiple Worksheets

• Using Multiple Worksheets
• Linking Worksheets By Using 3-D Formulas
• Managing Workbooks

Macros

• Recording And Running A Macro
• Editing VBA Code
• Function Procedures

Advanced Web Topics

• Creating Interactive Web Spreadsheets
• Pivot Tables On The Web