13- 17 May, 2013

# Blog & Excel Tips

Blog entries covering the latest Excel tricks and tips based on queries from clients and new learning from our excel consultants.

Advanced Excel Course - June 2013 in South Africa. Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 days or break it down into a 3 day Advanced Excel and 2 day Financial Modelling course

## Creating a Waterfall Chart in Excel the easy way

How to create a waterfall chart in excel by using the stock charts which already allow for changes in colour depending on whether the movement is up or down.

## Showing zeros in Excel

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.

## Separating Lines within a cell

How to separate lines within a cell without using the Wrap Text command

## Share and Unshare workbooks

How to share and unshare workbooks in Excel so that mulitple users can access the workbook without affecting its integrity.

## Internet Power- Making Excel run faster

A possible solution where Excel is slow to process an initial calculation but then speeds up afterwards

## Advanced Excel Training during May 2013 in Johannesburg

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.

## Financial Modelling Training in Mozambique during May 2013

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 .......

## Adding hypens into a group of telephone numbers

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

## Handy Tips & Tricks

Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading

## Creating a Waterfall Chart in Excel the easy way

A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading

AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.

– Sasol Polymers

## View Entire Video Gallery ››

• 03:14
• Skill Level:
• What's my skill level

• 00:42
• Skill Level:
• What's my skill level

## Waterfall chart using stock charts

• 07:11
• Skill Level:
• What's my skill level

## Absolute and Relative cell references

• 06:34
• Skill Level:
• What's my skill level