Session 2: Friday, 7 March, 11h00 - 12h30
Tel: 086 167 3923 Email: Info@SummitSolutions.co.za
February 28, 2019
We can use the Wrap Text feature in Excel to display all cell content over multiple lines. At times though this does not have the completely desired effect.
alt + Enter enables one to put a Line Break at the exact point required irrespective of the Column Width.
Excel Tip - No. of Days between 2 Dates
September 9, 2020
Excel Tip - Fixing Incorrect Dates
August 26, 2020
Excel Tip - Storing ID Numbers as Text
August 12, 2020
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