International experts in Excel

The Essential Spreadsheets for Human Resources course is for you if you want to:

• Master all of Excel’s manipulation tools for sorting, filtering, converting, completing, subtotalling, cross-tabulating, formatting, splitting and joining.
• Learn how to import data from other systems and solve any problems you might have.
• Discover the useful HR functions such as VLOOKUP.
• Know how to do all kinds of date and time calculations.
• Mail-merge with Word.

The More Essential Spreadsheets for Human Resources course is for you if you want to:

• Create professional reports that combine charts, tables and graphical indicators.
• Learn to create dashboard reports.
• Create robust forms for others to use that you can then combine into a single data source.
• Go beyond simple filters, lookup functions and PivotTables.
• Chart data and show trandlines.

Course content overview:

• Essential Spreadsheets for Human Resources         | venues |
  Plan and report, import data from other systems, manipulate HR databases, total database data, adopt best practices for workbook and sheet layout, calculate with Date & Time, mail-merge with Word, build organisation charts, validate data input.
  
  
• More Essential Spreadsheets for Human Resources         | venues |
  Learn best-practice multiple workbook structure, utilise Excel's Advanced Filter, explore advanced PivotTable techniques, chart and show trends, understand advanced Excel functions, create forms, create succinct, readable dashboard reports, explore an employee performance report model.

Course structure:

• Essential Spreadsheets for Human Resources
  Duration: two days. Format: seminar with small team hands-on problem-solving exercises - computers are provided.
  
  
• More Essential Spreadsheets for Human Resources
  Duration: one day. Format: seminar with small team hands-on problem-solving exercises - computers are provided.

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. Our agendas contain 100% useful information. Our course examples are problem- (not feature-) based, and deal with real-world situations.
• 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, fully-indexed course manual that explains each of the course agenda items in detail. Manuals have the degree of detail appropriate to the course level (step-by-step for entry-level courses, highly-condensed for more advanced) and include material additional to the agendas.
• Files of all spreadsheet examples covered on each course, as well as other files you can adapt for your own use, provided on a USB memory stick that you can keep.
• FREE and UNLIMITED email hotline support for twelve months following each course.
• The ESPMini add-in, to speed up many common tasks and help apply conventions and good practices.
• A free PDF assessment copy of each of our monthly magazines: Instant, In-depth and Visual Basic Excel Sheets. Then, choose your preferred magazine and receive a free three-month subscription.
• Learning at a comfortable pace in a friendly environment - from the Excel experts.
• A course certificate upon request.
• Lunch, as well as refreshments upon arrival, mid-morning and mid-afternoon, are all included in the price.

Who should attend:

• Essential Spreadsheets for Human Resources
  HR staff involved in planning, analysing and reporting of HR data, who have been using spreadsheets for some time and are quite familiar with the basics of formula construction. While some sections of this course could fairly be described as ‘advanced’, we don’t assume you know any of it.
  
• More Essential Spreadsheets for Human Resources
  HR staff involved in planning, analysing and reporting of HR data, who have been using spreadsheets for some time and are quite familiar with the basics of formula construction. While the Essential Spreadsheets for Human Resources course is not a prerequisite to attend this course, you should be familiar with the material outlined in the agenda for the two-day course if you plan to attend More Essentials.