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.

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

## Rounding to numbers other than 1, 10, 100 etc

Rounding to numbers other than 1, 10, 100 etc

## Excel Training in Tanzania

We now offer Excel training in Tanzania on an in house basis covering beginner, intermediate, advanced and financial modelling.

## Filter a pivot table based on a list in another sheet

Occasionally you may want to filter a pivot table based on values in other cells. This is to avoid having to check so many items. You can use VBA but an alternate is to create a helper column in the underlying data.

## Separating Lines within a cell

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

## Share and Unshare workbooks

A recent email query asked how to share and unshare workbooks in Microsoft Excel with a specific focus on switching off the sharing. The method to share and ‘unshare’ the workbook is the same. As shown in the image below, … Continue reading

The remarkable thing about Adrian's presentation is his ability to further change and adapt the focus of the course as issues arose. He was also able to keep the more skilled delegates challenged...

– Alexander Proudfoot Consultants

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