Briefly

This is the most basic workshop in this series, but it is not a basic Excel course. This is a workshop to introduce many of the new Menu driven options in Excel 2007 to ‘professional’ users. Its ideal for people who want to see the real power of Excel 2007, and how the many features of the Ribbon system can be added to their ‘tool box’. The workshop also includes a critical look at the strengths and weaknesses of Excel itself.

The course would suit personnel using Excel frequently but have little knowledge of Excel 2007 and want to improve application skills.

Detailed Outline - A full one day workshop
                                                                          
For Whom:
Non-financial and Financial professionals who currently use Excel but have not had the opportunity to explore the many menu driven options of Excel 2007. It would also suit frequent users of Excel who want to improve application skills without a substantial learning curve.

Assumed expertise:
Applicants should be familiar with Excel 2002/3 to the extent of being regular users, but with limited use of the myriad of menu driven solutions displayed in the new Ribbon icons in Excel 2007.

Content:
We are interested in covering those areas of Excel which will increase our understanding of the functionality of the application for financial and statistical applications. In this workshop we begin by looking at the structure of the Excel workbook and then important features developed to help improve productivity. In summary the workshop includes:
 
- Multi worksheet and workbook characteristics, linking and unlinking, group worksheet entries and uses.

- Screen splits and freezing as well as simultaneous multi-workbook/worksheet display handling.

- Important date features of Excel 2007 and their use in financial applications.

- Important graphing options including the new Chart Wizard and other graphical tools for double axes displays.

- Use of Name Ranges in formulas - and printing

- New Security features of Excel 2007 - protecting formulae, worksheets and workbooks.

- The use of Conditional Formatting and Data Validations features in Excel 2007.

- Menu options for Sorting data, including Data Table options to ‘data fill’ for solutions.

- Worksheet Forms and Buttons - controlling users and data formats.

- Transposing data and filtering a database.