Microsoft Excel specialists

Major topic courses  

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

  • Discover the Excel formulas 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 formulas quickly.
  • Find all cells involved in circular reference warnings.
  • Avoid formulas 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.

The PivotTables to analyse and present data course is for you if you want to:

  • Analyse and report on imported data.
  • MLearn PivotTables from scratch.
  • Take your PivotTables ability to a higher level.

Course content overview:

  • Formulas & functions         | venues |
    Make formulas easier to follow, understand the calculation options, solve common formulas problems, discover the power of array formulas, master file-link formulas, total, count and average, round, use conditional logic, look up information, index and rank, calculate with dates and times.
  • 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.
  • PivotTables to analyse and present data         | venues |
    Create PivotTables, Group PivotTable fields, Add calculated fields and items, Add PivotCharts, Create multiple PivotTables from the same source data, Add Slicers, Create a Slicer-driven dashboard, Create variance reports.

Course structure:

  • Formulas & functions
    Duration: one day. Format: seminar.
  • Import, manipulate & report
    Duration: two days. Format: seminar with small team hands-on problem-solving exercises - computers are supplied.
  • PivotTables to analyse and present data
    Duration: one day. Format: Hands on step-by-step followed by exercises.

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.
  • A free PDF 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.
  • The GenieMini add-in, to speed up many common tasks and to help apply conventions and good practices.
  • 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:

  • Formulas & functions
    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.
  • PivotTables to analyse and present data
    All Excel users except beginners and those who have already mastered PivotTables.

Learn in a positive environment

  • Be assured the advice you get is well-proven and utilised.
  • Feel free to ask questions.
  • Get time away from the office and constant interruptions.
  • Enjoy a friendly environment where you don’t feel you’re holding others up.
  • Instantly apply what you’ve learned on return to work.

The courses cover Microsoft Excel releases XP(2002) through 2013.
Where there are differences among the covered releases, they are pointed out.

Course cancellation policy:

A course booking is considered final when received in writing (online, email, fax or post) by AbleOwl, and can be cancelled up to ten working days before the course. After that, payment is expected in full and no refund will be given. All cancellations must be notified in writing, i.e. post, fax or email. Another delegate may be substituted at any time.