Microsoft Excel 2007 Advanced Function Writing

1 Day Course
Code QAEX07AF

This course has been retired. Please view currently available Business Development Training Courses.

Modules

Course Outline (10 topics)

  • Function Writing Review
  • Review of Basic Functions
  • The IF Functions
  • Nested Functions
  • Array Functions
  • Date and Time Functions
  • Working with Text Functions
  • Lookup and Reference Functions
  • Rounding Numbers
  • Miscellaneous Statistical Functions

Prerequisites

Before attending this course, students need to be able to: Demonstrate a good working knowledge of Microsoft Windows Demonstrate a good working knowledge of Microsoft Excel 2007 Understand basic functions such as Sum and Average and how they are written Write and edit a variety of basic formulas using Excel functions To ensure your success, we recommend the following courses have been undertaken, or equivalent knowledge gained: Microsoft Office Excel 2007: Level 1 Microsoft Office Excel 2007: Level 2 Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.

Course PDF

Print

Sections