Rugby WC, Excel not recognizing formula or space, undoing a sort order

Rugby WC, Excel not recognizing formula or space, undoing a sort order

In this issue:

If you want to get these tips and tricks as soon as they come out link to us via social media.

Please follow us on Facebook, Twitter , Google + or LinkedIn

Advanced Excel 2Next Excel Courses

Email us if you need more details or visit the calendar page

Excel not recognising formula

What to do if you try and create a formula in Excel and instead of it showing the result it shows the formula as text. Read more

In Houses Excel Courses- on site or at your selected venue

We are frequently asked if we can offer courses to clients at their premises. The answer is yes and the major benefits are:

  • Cheaper on a per person basis
  • Can be customised to suit your exact needs
  • Can be flexible with period over which it is presented.

For more information give us you group size and we can provide an estimate. Email us

Undo sort in Excel

Idea for making sure that you can get back to the original sort order without needing to click the undo button. Read More

How to use the new online courses

Instructions on how to use the new online Excel training course. We will be launching modules of the live courses over the next few months. Read More

Excel not recognising an obvious space

You and see the space but when you ask Excel to replace it, Excel says there are no spaces?  … Read More

excel skills testExcel Skills Transfer

We have developed a new Excel Skills Transfer Product to enable a more thorough transfer of our Excel skills. The product is for corporates who want to ensure that their training budget is used in the best possible way.  Read more

Using a PowerPivot file on a machine that doesn’t have PowerPivot

Can you use a PowerPivot file on a machine that doesn’t have PowerPivot loaded?  … Read More

Rugby World Cup

For fun we have a Rugby World Cup Sweepstakes spreadsheet… Read More

Excel Skills Assessment

Did you know that our Excel Skills Assessment is now being used by overseas companies to assess their entire workforce? Read More

VLOOKUP Explained

Do you need to join databases, age debtors or reconcile account?   Read more

Reward- Quick Reference Guide

Excel-Quick-Reference-Guide-pg-1As a reward for being a regular reader, we have made available the quick reference guide we hand out in the courses.

The guide covers $, IF, VLOOKUP, SUMIF, DATES, Shortcuts and more. Send this to your training department and ask them to:

  • Print it in colour, double sided
  • A3 or A4 (A3 is better)
  • Laminate it
  • Distribute to all staff to keep on your desks

Subscribe to the Newsletter below to download the free Quick Reference Guide