International experts in Excel

These half-day courses are for you if you:

• Want an overview and to cover the agenda topics in less depth than our more advanced courses do.
• Don't use Excel every day, or are relatively new to Excel (but are definitely not a beginner).
• Can only take a half-day away from office responsibilities.

Course content overview:

• Macros short introduction         | venues |
  Automate tasks to save hours of work. Avoid having to remember lots of steps. Simplify long or complex formulae.
• Link & consolidate data         | venues |
  Create formulae that refer to other workbooks but avoid the common problems. Discover how to structure links in an efficient, easy-to-maintain way. Know how to locate and remove links. Consolidate data from different sheets or workbooks.
• Essential formulae & functions         | venues |
  Learn to harness the power of Excel's formulae capabilities. Explore how Excel's built-in functions can increase your efficiency. See beyond SUM: it's just the beginning of your calculation options.
• More essential formulae & functions         | venues |
  Learn to create powerful formulae to report and total. De-mystify date and time calculations. Master text manipulation.
• Work with tables of data         | venues |
  Learn the most efficient ways to sort your data. Group your data effectively with Subtotals and PivotTables. Explore Excel's powerful data-filtering capabilities.
• Import & manipulate         | venues |
  Import data from other systems either via text files or direct with Excel’s inbuilt Query. Learn the common problems and solutions. Split and join columns as needed.
• Create charts         | venues |
  Learn the key chart types and which to use for which purposes. Know how to customise charts in a wide variety of ways. Add trend lines and know whether the fit is statistically good or not.
• Professional formatting & reports         | venues |
  Improve your reports with better formatting. Master input-form creation. Ensure no one else can change your spreadsheets.

Course structure:

• All Focused topic courses
  Duration: half-day. Format: seminars 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 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.
• Mid-session refreshments included in the price.
• A course certificate upon request.

Who should attend

• All Focused topic courses
  Those who have mastered the basics; that includes formula construction, formatting and printing. You are definitely not a beginner.