In this issue:
- Reward- Quick Reference Guide – See below
- Next Excel course dates 14-18 Sep
- Excel VBA Public Course- 17-18 Sep
- BODMAS rule and Excel NB
- In houses Courses- See below
- Replacing quotes in Excel
- How to use our new online courses
- Arrange Windows Side by Side NB
- Rugby World Cup spreadsheet
- Excel Skills Transfer
- Beginner Excel Course Dates- Next 8 Oct 2015- Rest below
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
Reward- Quick Reference Guide
As 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 below to get this
Next Excel Courses
- Advanced Excel course (14-16 Sep 2015)
Excel Financial Modeling, Budgets and Forecasts (17-18 Sep 2015)- Excel VBA Course (17-18 Sep 2015)
- In House course- whenever it is convenient for you
- Excel Fundamentals for beginners
- 8 October 2015
Email us if you need more details or visit the calendar page
BODMAS rule and Excel
BODMAS is still an important rule, even in Excel. We recently came across errors where, by not including the correct brackets, the answer was 66% wrong… Read more
In Houses Courses
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
Replacing Quotes in Excel
Have you ever tried to replace quotes in Excel? Hard to do as quotes have another meaning in Excel. In order to do this…. 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
Arrange any windows e.g. Excel and pdf side by side
You should already know how to (easily) arrange 2 excel windows side by side. But do you know the shortcut to arrange a pdf and Excel window side by side … Read More
Excel 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
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