Session 2: Friday, 7 March, 11h00 - 12h30
Tel: 086 167 3923 Email: Info@SummitSolutions.co.za
September 20, 2019
Mark - Summit Solutions
Ever had issues when trying to Sort Birthdays in the correct order?
Changing the Format of a D.O.B to dd-MMM doesn’t work. When you sort, it still orders by Birth Date (age) and not Birth Day because the Year component still exists even though it does not display.
September 11, 2019
In Excel, subtracting an Earlier Date from a Later one will calculate the number of Days in between - which can be very useful.
However, we may need to calculate the number of Working Days between 2 Dates. If that is the case then NETWORKDAYS() is your go-to function. (...
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
Excel Tip - How to calculate the number of Working Days between 2 Dates
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