SUBSCRIBE FOR FREE EXCEL TIPS

January 28, 2020

Un-beknown to most, when you insert a new column, the Format of the cells in the Column are of the cells in the Column on the Left. So, if you get a Date when you enter a number as with the example shown, you would have inserted the column to the right of a Date Format...

January 16, 2020

A reminder of 2 very useful keyboard shortcuts!

Ctrl + ;                Current Date

Ctrl + shift + ;   Current time

These shortcuts will enter hardcoded values and will therefore not change on future days. If yo...

December 4, 2019

 A hover-over of your Worksheet Scroll arrows reveals two more very useful tips!

Ctrl + Left Click on the right arrow shoots to the last sheet. (Ctrl + Left click on the the left arrow will shoot back to the First one.)

Right Clicking on either arrow gives you a Pop-up C...

November 20, 2019

The Excel Format Painter is a wonderful tool. To be able to copy all the formatting from one cell and apply it over other cells is a real time-saver. If you need to apply the copied format more than once though, then a simple double-click on the Format Painter command...

November 6, 2019

Most times using a keyboard shortcut is quicker than using a mouse. Sometimes though, it’s a nifty combination of the two that does the trick!

The standard way of moving a column within a range of data is to right-click on the column header, select “Cut”, then right cli...

Please reload

Please reload

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

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

Email: info@summitsolutions.co.za 

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

2020 | Copyright | Summit Solutions