AJP IT Services

Course Objectives

This course will cover the advanced commands of this powerful application. The topics include an overview of the spreadsheet commands, the more involved graphics and database capabilities, the more advanced functions and analysis techniques, and a look at Excel's macro commands.

The broad objectives are to make clients fully aware of the advanced capabilities of the program.

Who Should Attend?

Those who have used Excel and who require a review of Excel's advanced facilities.

Previous experience of using Excel at an introductory level will be assumed. Delegates with no previous experience of Excel should first attend our "Introduction to Microsoft Excel" Course.  

Course Contents

A review of Excel basics.

• Spreadsheet
• Charts
• Database

Spreadsheet commands.

Absolute and Relative cell addresses.

Use of named areas.

Advanced Analysis Techniques.

• Scenario Manager
• Goal Seek
• Solver

Advanced Reporting Techniques

• Custom Views
• Report Manager

Excel's functions.

• IF function
• The LOOKUP function
• Discussions on other functions available

Workbooks and file linking.

More involved charting techniques.

Data Menu commands.

• Validation
• Sorting
• Filtering
• Sub-totals
• Pivot Tables

Writing, running and editing Macros.

Producing interactive macros.