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

This can be useful if that was your intention, but most of the time it isn’t. To override this default, use the Insert Options (little Paintbrush) to c...

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 you dynamically need to assign the current Day and / or Time to a cell or Formula you can use the following Functions:

=Today()               Current Date...

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 Contents Page of all your Sheets that is sooo much easier to navigate. Simply Double-click on the Sheet Name once you've found it to take you straight there!

Please reload

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

  • improve my skills on microsoft excel
  • excel training for businesses
  • excel training help in Durban
  • learn the features of excel

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

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

2019 | Copyright | Summit Solutions