Blog & Excel Tips

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

Don’t use + to start an Excel formula July 11, 2017

We have previously shown why, especially in South Africa, you shouldn't start an Excel formula with a +. In a recent course we found another reason that you don't use + to start an Excel formula. As a general rule just don't do it.

How to insert blank rows in excel automatically July 10, 2017

...sometimes you have to insert blank rows into a dataset to accommodate some other system. Perhaps your accounting system needs to have a gap between each journal entry. We look at some ways on how to insert blank rows in excel automatically.

Transpose vs Unpivot June 27, 2017

One of the most common data cleanup issues is changing the structure of the data. Perhaps rows need to become columns and columns rows. In some cases you actually may need to turn a report back into a database..... The terminology to get right is whether you want to transpose or unpivot that data.

How to follow an excel link to another sheet/ spreadsheet June 27, 2017

As you work through spreadsheets you will create links to other sheets and spreadsheets. But once it has been created you will need to know how to follow an excel link to another sheet/ spreadsheet. Otherwise you will need to remember each link and hope your memory lasts until you find it.

Two level axis in Excel chart not showing May 29, 2017

A two level axis in Excel charts allows you to show more information on the chart. For example if you want to clearly show items that are actuals versus the items that are budgets or forecasts you may want to set it up to look like this. Note that the first level shows the month name and the second level shows where the actuals and the forecasts start.

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