Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Solid grounding
Best-practice essentials
Powerful formulas and clear reporting
Automation and robustness

  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Foundation courses - Excel next step 3

Masterful manipulation and PivotTables

     Duration: 1 day  
     Format: Hands-on, computer provided  
   Arrival and refreshments: 8:45am  
   Start 9:00am  
   Finish: 4:30pm  
  YOUR POWER-PACKED AGENDA

Import data

  • Import the two types of text file: fixed-width and delimited.
  • Import dates correctly.

Split, join and manipulate columns

  • Concatenate columns with &.
  • Split columns with LEFT, MID and RIGHT.
  • Convert case with UPPER, LOWER and PROPER.
  • Split at a particular character with FIND and TRIM.

Create PivotTables

  • Create a PivotTable.
  • Format a PivotTable.
  • Update a PivotTable with the latest values.
  • Show data as a % of column total.
  • Display selected items only, remove subtotals and remove a grand total.

Calculate rank order

  • Use RANK and LARGE.

Apply advanced sorts and AutoFilters

  • Sort and Filter by colour and icons in Excel 2007 and later.
  • Sort into non-alphabetical order (such as month names).
  • Filter by top 10 and complex criteria.

Insert Subtotals and create Outlines

  • Insert subtotals into sorted tables.
  • Use Outlines to quickly hide and display data.

Structure for expansion: use a Table/List, range name

  • Make PivotTables, formulas and print areas expand automatically to include all data.
  • Use range names for quick range selection and maintenance.
  • Use the GenieMini add-in for superior range name management plus much else.

Discover other useful features (optional topics)

  • Use DSUM to total data that has complex criteria selection.
  • Delete duplicates.

Prerequisites

Excel users who can already create basic SUM and arithmetic formulas. Those who want to analyse data arranged in tables, which are often imported from other systems. Prior attendance at the Best-practice essentials and Powerful formulas and clear reporting courses is not mandatory, although it would be useful.


  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.

Presenters

AbleOwl has a number of different presenters, all of whom are Excel specialists.

See dates of all courses  

  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.