International experts in Excel

The Formulae & functions course is for you if you want to:

• Discover the Excel formulae and functions (and their combinations) needed to solve common problems quickly.
• Pick up tips on better, faster, clearer and more maintainable formula construction.
• Find links in spreadsheet formulae quickly.
• Find all cells involved in circular reference warnings.
• Avoid formulae changes when you insert or delete.

The Import, manipulate & report course is for you if you want to:

• Import text files from other systems into Excel and avoid the problems that often result.
• Master manipulation tools for sorting, filtering, converting, completing, subtotalling, cross-tabulating, formatting, splitting and joining to create reports you need.
• Use ODBC drivers to access data directly via Microsoft Query.
• Learn Excel 2007/2010’s new Tables feature, and how to use Tables with MS Query.

Course content overview:

• Formulae & functions         | venues |
  Make formulae easier to follow, understand the calculation options, solve common formulae problems, discover the power of array formulae, master file-link formulae, total, count and average, round, use conditional logic, lookup information, index and rank, calculate with dates and times, use string formulae.
• Import, manipulate & report         | venues |
  Import fixed width and delimited files, solve import problems, import with Microsoft Query, use manipulation tricks, merge and split tables, check records, filter, split columns, subtotal, create PivotTable reports, create output text files.

Course structure:

• Formulae & functions
  Duration: one day. Format: seminar.
• Import, manipulate & report
  Duration: two day. Format: seminar with small team hands-on problem-solving exercises - computers are supplied.

What you get for each course:

• The best possible advice and training from international company AbleOwl, who have specialised solely in Excel and spreadsheets for over twenty years.
• Assimilation of good spreadsheet design practices. All AbleOwl courses apply ESP conventions. ESP=Excel Standardisation Programme. That means you will more quickly understand and navigate the workbooks used, whichever AbleOwl courses you attend.
• A well-written, full-colour, indexed course manual that explains each of the course agenda items in detail.
• A USB flash drive that contains all spreadsheets covered in the course examples. You can modify the spreadsheets for your own use.
• FREE and UNLIMITED email hotline support for twelve months following each course.
• A free copy of each of our monthly publications: Instant, In-depth and Visual Basic Excel Sheets. Then, select your preferred magazine and receive a free three-month subscription to it.
• Multiple-place discount: 10% off for three or more places booked on the same course.
• Refreshments and lunch included in the price.
• A course certificate upon request.

Who should attend:

• Formulae & functions
  For those who have been using spreadsheets for some time and are quite familiar with the basics of formula construction, formatting and printing.
• Import, manipulate & report
  Regular Excel users who have been working with financial, production or administrative data/databases for some time and are familiar with the basics of simple formula construction, formatting and printing.