October 23, 2019

As you’ve hopefully discovered, working with genuine Dates in Excel enables us to group Dates by Years, Quarters & Months. This is hugely beneficial when it comes to Filtering Data or Summarising it using Pivot Tables.

What can be frustrating though, is when you need to...

October 9, 2019

Picking up from where the Key Essentials Course left off, the objective of this course is to expose one to the many powerful advanced functions that Excel has to offer, as well as cover some key principles that ensure good practice while avoiding common pitfalls when w...

October 8, 2019

In a previous Tip we showed you the simple solution of extracting Birthdays from a Date of Birth List.

=Text(D4, “dd-MMM”) where D4 references a D.O.B. field.

The problem though is that this only works 99.9% of the time. For most that would be good enough, unless you’re...

Please reload

Please reload

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions