Briefly

The workshop covers many of the new functions and common formulae structures used for specific solutions of calculation, selection, sorting and classifying information. The workshop covers logical, financial, date and time, searching and calculation functions. Many of the functions are placed inside comprehensive formulae to solve specific business applications. Also covered are functions and routines to trap errors and stabilise models, while the workshop finishes with the new multiple criteria functions of Excel 2007.

Detailed Outline - A full one day workshop
                                                                          
For Whom:
Non-financial professionals operating in the mining and resource sector, who currently use  Excel but need more tools to develop more powerful and stable solutions. A powerful workshop for any professional wanting power to develop comprehensive solutions to financial and non-financial problems

Assumed expertise:
Applicants should be familiar with Excel 2002/3 to the extent of being regular users, and creators of at least basic formulae. An understanding of function structures would be useful, but this is considered early in the workshop.

Contents:
Many users will be familiar with some of the most common functions used in Excel, however their application within formulae to solve specific problems may be new. Additionally, several powerful and new functions are introduced to calculate, search and select data. The importance of financial functions is examined together with the principle behind them, while we also examine several error trapping routines capable of helping to stabilize solutions. Specifically we cover:

- Understanding the protocol used by Excel in its calculation methodology, including worksheet re-calculation and iteration.

- Examining the logic function ‘IF’ and its extensions AND and OR  in formulas to select and control.

- Using the results of one function as an argument within a second function.

- Look at the variations of the SUM function, including SUMPRODUCT, SUMIFS and SUBTOTAL with its multiple option flags.

- Understand the use of some specific search functions such as LARGE, COUNT, SMALL, MAX and MIN.

- Using some of the common Financial functions in Excel 2007. How they operate.

- Some ERROR routines and functions for stabilizing spreadsheet solutions.

- Using special search functions such as INDEX, MATCH, EXACT for special searches including Lookup Wizard.

- Special multi column and analytical search functions and combinations.

- Combining functions together within formulae using arguments to increase the functionality of the application. (Including name - ranges).

- Using the new multiple criteria functions of Excel 2007.