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.
February 14, 2019
By default, when we edit a cell and press the Enter Key, Excel shifts the focus to the cell below and makes that the Active cell. If we want to replicate the cell that we’ve just edited, we then need to reselect the cell in order to do so.
Holding down the Ctrl key when...
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