Tools
You are here: Home » Training Courses » Microsoft » Excel » Excel 2000
Friday, 29 Mar 2024

Microsoft Excel 2000 - Advanced

Table of contents
« Prev Next »

Course Objectives

This one day course covers Excel's advanced features. The course will look at the more advanced functions and analysis techniques, and particular emphasis will be given during the course to Excel's macro commands.

Who Should Attend?

Those who have used Excel 2000 yet require a more in-depth knowledge of more advanced features and macros. Previous experience of using Excel 2000 to an intermediate level will be assumed. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Excel Intermediate" course.

Course Contents

Excel Database Features.

  • Advanced Filter
  • Database Functions
  • Pivot Tables

Sharing Workbooks.

Using Outlines.

Using Consolidation Commands.

Advanced Analysis Techniques.

  • Scenario Manager
  • Goal Seek
  • Solver

Advanced Reporting Techniques.

  • Custom Views
  • Report Manager

Macros.

  • Recording a macro
  • The Macro Language
  • Running a Macro
  • Relative Addresses

Range Names.

Using Input Boxes.

Using Message Boxes.

Using the If Then Control Structure.

Using Loops.

  • Using Do While and Do Until loops

More Complex Message Boxes.

Using Dialog Boxes.

  • userforms
  • textboxes, labels and command buttons
  • comboboxes
  • optionbuttons

Microsoft Excel 2000 Course DetailsDownload Course Details

(Page 4 of 4)

Contact Us

Telephone : 0117 929 1509
Send us a message or request a call back

1000 characters left