You are here: ICB Sign upLogin

Do you know your IF functions from your Lookup functions? Or your Goal Seek from your Solver?

We've teamed up with the Institute of Certified Bookkeepers (ICB) to bring all ICB members our accredited, CPD-verified (up to 25 points), online Course and Test at an exclusive discounted price of £132 (from £160). Use the exclusive ICB discount code (see InVoice) when purchasing.

Our online diagnostic and testing tools quickly measure your Excel skills before prescribing a bespoke, business-focused Excel course. We reviewed Excel's 500 functions, ruthlessly stripping out any business non-essentials, leaving a jargon-lite Excel course for bookkeepers and accountants to learn from within a matter days, at a pace that suits and at a competitive price.


 


Test. Train. Excel.™
 
  

"I have found everything very useful, especially the units on Linking Worksheets and the various formatting ones. The course is just right for my level and very easy to understand. The materials are of good quality and I can't think of anything that needs adding to it. I hope everyone else enjoys the course as much as I did."

  Stella Doogan, ICB Member (Sep 2010)                 

Tips & Tricks in 60 seconds ICB Members only

We believe that there are many quick tricks you can learn in Excel, specifically, tricks that you can learn in under 60 seconds. You will find below a select group of techniques and methods (in PDF format) which ought to make your life easier - each with a distinct emphasis on business application. We hope you enjoy reading them as much as we did writing them!

  1. Formatting numbers New!
    A starter course in how to make Excel display numbers as you would wish. 
  1. Avoiding crashes
    How to reduce the chance of Excel crashing, and how to minimise the consequences when it does. 
  1. Eliminating errors
    Techniques to help you avoid errors when building and auditing spreadsheets. 
  1. Meaningful cell references
    A way of simplifying Excel formulae and making them more meaningful, by replacing cell references with names of your own choosing. 

More 'Tips and Tricks'

How it works

.Use arrows to scroll or hover over images to find out more.*
Key features
  1. Distilled syllabus
    2. Our 32 units collectively cover 120 essential Excel functions and techniques.
  1. Diagnostic
    2. Take our Course Diagnostic at the start to help prioritise your learning, producing a traffic light for each unit based on level and need. Read more.
  1. myEwB
    2. Your learning hub shows progress on all 32 units. As you complete a unit, all dates get logged automatically; perfect for meeting CPD requirements. Read more.
  1. Distilled syllabus
    2. Owing to the distilled nature of the course, the circa. 24 hours of learning can be mastered within a month and at a pace that suits you. Read more (to see an example).
  1. Business focus
    2. We have used our combined industry experience to bring you a business focussed course with an emphasis on practice (eg cumulative total tricks) over theory (COUPNCD function)
  1. 2003 & 2007 versions
    2. Unlike most courses, our materials are made available in both 2003 and 2007 versions of Excel. This may help to jog your memory or decide to upgrade.

*If you are unable to view the above process or would like to view as a video walkthrough please click here.

 
© 2012 Excel with Business Help FAQs Contact us About us Terms Of UsePrivacy