Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.

Entering Long Numbers in Excel February 1, 2017

A common problem is entering long numbers in Excel. You will know you have this problem if Excel - Replaces some of the last characters of the long number with zero's - Seems to round long numbers to zero- Refuses to accept the number you type- you enter numbers that have 15 or more characters (think credit card numbers, ID etc)

South African Tax Spreadsheet Calculator 2017/ 2018 January 31, 2017

Finance Minister Pravin Gordhan will present the budget speech to Parliament on 22February 2017, at 2pm. At that stage we will be able to update our South African Tax Spreadsheet Calculator 2017/ 2018 and you will get a sense of whether you will be paying more or less next year.

Stop all the pivot tables applying the same grouping method January 30, 2017

You've built your pivots, they work great so you create a few more so that your dashboard can show the information in different groupings. Perhaps a daily pivot chart to show the trend and then the same data shown monthly for reporting purposes. The problem is that when you change the one pivot's grouping, to say monthly, all the other pivots also change to monthly.

Repeat pivot table row labels January 17, 2017

When using a Excel you may need to/ want to repeat pivot table row labels. Some of the reasons you may want to do this are that you plan to copy and paste the pivot table into another sheet to sort or filter and you need the blanks filled in (see here how to manually do this quickly), or the sheet is very long and as you scroll down you can't remember what section you are looking at

Consulting

We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.

Find Out More

Live Training

"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."

Find Out More