April 12, 2019

Ever need to manipulate data repeatedly through multiple rows? In the old days we would need to use complex nested Text Formula. Today (well since 2013) we can give Excel an example, and then get it to replicate this through all the other Rows simply by using the Short...

March 28, 2019

In a previous tip we highlighted that if a menu command has a shortcut, if you hover over the icon it will give you the shortcut in brackets.

If there is no dedicated short cut assigned, it doesn’t mean that the only way to access this feature is by using your mouse. Th...

March 14, 2019

We often need to repeat a particular format on cells that are not necessarily connected. Even using the Format Painter which enables us to apply more than one Format at a time can be time-consuming as we need to keep on re-selecting it.

The Function Key F4 enables us to...

March 4, 2019

Whether we are self-taught, or relatively new to Excel, we invariably have gaps in our Essential Excel Skill Set. We often end up plugging away the best we know how, even though there is this nagging feeling that there must be a simpler and more efficient way. Take tim...

February 28, 2019

We can use the Wrap Text feature in Excel to display all cell content over multiple lines. At times though this does not have the completely desired effect.

alt + Enter enables one to put a Line Break at the exact point required irrespective of the Column Width.

Please reload

Please reload

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions