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.
• Learn PivotTables from scratch.
• Take your PivotTables ability to a higher level.

The Charts & Dashboards course is for you if you want to:

• Communicate effectively.
• Choose and build the best type of chart for a report.
• Highlight key figures with Conditional Formatting.
• Arrange elements of a report or dashboard neatly.

The Dashboards next step course is for you if you want to:

• Design reports that go beyond Excel's usual charts and tables.
• Add new features to reports, dashboards and infographics.
• Report on data that isn't in a report-friendly layout.
• Think critically about what makes a good report and what is clutter.

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.
• Charts & Dashboards         | venues |
  Create charts, choose the most appropriate chart type, format charts to communicate clearly, apply Conditional Formatting to colour cells according to formula rules, add icons to highlight good or bad values, plan a dashboard, display tables of varying sizes on a dashboard, create a map where regions change colour according to score.
• Dashboards next step         | venues |
  Create a chart that fills a shape, build a report that opens when you click on a certain number or chart on a dashboard, make a filter for two charts even if those charts have different source data.

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.
• Charts & Dashboards
  Duration: one day. Format: Hands on step-by-step followed by exercises.
• Dashboards next step
  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.