Microsoft Excel 2010 Advanced Function Writing

1 Day Course

Book Now - 1 Delivery Method Available:

Scheduled Online Onsite


The target students for this course are people who want to get the most out of their data by learning various analysis functions. Whether you are an account manager, an IT worker or someone who needs to regularly manipulate Microsoft Excel 2010 worksheet data, this course will show many functions and their capabilities. You will use the advanced features of Microsoft Excel 2010 to attain a high degree of proficiency as an Excel power user within the area of writing functions. This course is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Course Outline. (11 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


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 2010 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 2010: Level 1 Microsoft Office Excel 2010: Level 2 Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.

or call:408-759-5074

Course PDF


Share this Course


Recommend this Course