Session 2: Friday, 7 March, 11h00 - 12h30
Tel: 086 167 3923 Email: Info@SummitSolutions.co.za
December 13, 2018
Have you ever been frustrated when working with dates in Excel?
Watch this Webinar, where Mark covered the critical components of working with Dates and Times in Excel.
December 6, 2018
By default, the greyed-out gridlines in Excel are not printed. What many people do, to “show” these gridlines on a printed spreadsheet, is to add cell borders. However, there is a simpler and more effective way of printing gridlines.
Go to the Page Layout Ribbon and in...
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