Microsoft Excel specialists

Excel training courses

See dates of all courses
Contact us

  


Related Courses
Solid grounding
Best-practice essentials
Masterful manipulation and PivotTables
Automation and robustness

  WHAT YOU GET

Course manual
& Excel files

20  minutes’
hotline time

Excel expertise
28 years’
specialisation

Foundation courses - Excel next step 2

Powerful formulas and clear reporting

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

Learn important, powerful formulas

  • Avoid #DIV/0! errors with IF.
  • Employ AND and OR to create complex tests for IF.
  • SUM through sheets rather than create a formula that refers to a cell on each sheet.
  • Use VLOOKUP to search for a matching code and return a value from a table.
  • Use SUMIF and criteria to total certain values of a table.
  • Understand how Excel stores dates and times.
  • Calculate with dates and times.

Format conditionally

  • Colour cells according to the band they fall within.
  • Colour entire rows according to the band they fall within.

Sort and filter

  • Sort in Excel 2007 and earlier versions.
  • Apply a filter to view just the data that meets certain criteria.

Create charts to communicate results clearly

  • Create simple charts.
  • Customise charts.
  • Add pie charts to your data-display diet.

Design clear reports

  • Pick up conventions that make reports clear, professional and consistent.
  • Learn to structure sheets for ease of navigation and minimisation of errors.
  • Use the GenieMini add-in to rapidly build workbooks that have standard layouts.

Discover other useful features (optional topics)

  • Document certain entries with Comments.
  • Use ROUND to make totals reconcile with items totalled.
  • Use Excel tools to trace formulas references.

Prerequisites

Excel users who can already create basic SUM and arithmetic formulas. Prior attendance at the Best-practice essentials course is not mandatory, though it would be useful. For those who want to: (i) master commonly-used powerful formulas; (ii) present results in a clear, professional and confidence-inspiring way.


  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.