Blog entries covering the latest Excel tricks and tips based on queries from clients and new learning from our excel consultants.
Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them.
How to separate lines within a cell without using the Wrap Text command
How to share and unshare workbooks in Excel so that mulitple users can access the workbook without affecting its integrity.
A possible solution where Excel is slow to process an initial calculation but then speeds up afterwards
Our next Advanced Excel Training is happening from the 13th - 15th May 2013 in Johannesburg South Africa. The 3 day course covers Pivot Tables, Data Visualisation (charts) and Advanced Excel Functions.
The course is running from the 8th to the 10th of May 2013 at the Hotel Cardoso in Maputo. We will be covering the following topics over the 3 days Good Financial Model Practice Types of financial models Consistency in models .......
A recent question asked Regarding a column of phone numbers that have been entered without hyphens... Is it possible to highlight the column and put hyphens into the numbers e.g. from 3105551212 to 310-555-1212?
Recently a simple error in a report by some economists contained a simple spreadsheet error that had the impact of claiming a negative average growth as apposed to the correct positive growth
Rounding to numbers other than 1, 10, 100 etc
We now offer Excel training in Tanzania on an in house basis covering beginner, intermediate, advanced and financial modelling.
Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically … Continue reading
If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading
“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”– Absa Capital