You are here: Home » Training Courses » Microsoft » Excel » Excel 2007
Tuesday, 23 Oct 2018

Microsoft Excel 2007 - Intermediate

Course Objectives

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

Who Should Attend?

Those who have used Excel 2007 but have not yet tapped its full potential. 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 Office Excel 2007" Course.

Course Contents

A review of Excel basics.

  • Spreadsheet
  • Charts
  • Database

Spreadsheet commands.

  • Absolute and Relative cell addresses
  • Use of named areas

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

Microsoft Excel 2007 Course DetailsDownload Course Details

(Page 3 of 5)

Contact Us

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

1000 characters left

Microsoft Excel 2007 Courses

There are no courses scheduled