Change many Excel formats, filtering by colours, PowerPivot, Conditional Format with no numbers
In this issue:
- Next Advanced Excel course dates 12-16 Oct
- Beginner Excel Course Dates- Next 8 Oct 2015
- Filter by colour not showing all the colours
- In houses Courses- See below
- PowerPivot keeps crashing
- How to use our new online courses
- Changing formats in Excel in one go
- Excel Skills Transfer
- Conditional Formatting without numbers
Next Excel Courses
- Advanced Excel course (12-14 Oct 2015)
- Excel Financial Modeling, Budgets and Forecasts (15-16 Oct 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
Filter by Colour not showing all the colours
A new feature in the more recent versions of Excel, you can filter by colours. But what do you do if there are more colours in your column then spaces in the dropdown. 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
PowerPivot keeps crashing
A possible reason that your PowerPivot keeps crashing that has nothing to do with Excel 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
Changing the format of many cells at one time
How to (quickly) change the format of many cells e.g. all cells with Rands must be converted to Dollars … 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
Conditional Formatting without seeing the numbers
How to see only the conditional formatting and not the underlying numbers … 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