Session 2: Friday, 7 March, 11h00 - 12h30
Tel: 086 167 3923 Email: Info@SummitSolutions.co.za
August 16, 2018
In a nutshell – holding down the Shift Key anchors your current cell selection, the ctrl key moves to the end of a continuous range of data and the arrow keys give you direction.
Employing a combination of these keys enables one to quickly highlight a specific selectio...
August 2, 2018
To select / highlight an entire range without having to drag your mouse from top left to bottom right, simply select a single cell within the range and use the keyboard shortcut ctrl + A (All).
With the ctrl key still depressed, pressing A a second time will highlight...
Excel Tip - Validating an SA ID Number
July 29, 2020
Excel Tip - Catering for Millennials in D.O.B. from an ID Number
July 15, 2020
Excel Tip - Extracting a Date of Birth from an ID Number
June 30, 2020
Excel Tip - Storing Generation-Z ID Numbers.
June 17, 2020
Excel Tip – Number Formatting Keyboard Shortcuts
June 5, 2020
Excel Tip – Copy & Paste and keep Column Widths
February 26, 2020
Changing Values from Negative to Positive and Visa Versa
February 13, 2020
Excel Tip – The Format of an Inserted Column
January 28, 2020
Excel Tip – Entering the Current Date and Time
January 16, 2020
Excel Tip – Navigating a Workbook with Lots of Worksheets
December 4, 2019
Excel Tip – Using the Format Painter multiple times
November 20, 2019
Excel Tip – Quickest way to move a column!
November 6, 2019
Excel Tip – How to handle Financial Years that are not Calendar Years
October 23, 2019
Excel Tip – What to do with Leap Year Babies!?
October 8, 2019
Excel Tip – Extracting a Birthday from a Date of Birth
September 20, 2019
Excel Tip - How to calculate the number of Working Days between 2 Dates
September 11, 2019
Excel Tip - How to fix incorrect Date formats in a jiffy!
August 20, 2019
Excel Tip - Prevent Large Numbers from converting to Scientific Notation.
August 7, 2019