SUBSCRIBE FOR FREE EXCEL TIPS

Excel Automation - Session 1 (26 July 2019)

Most of us who work in Excel do what we call repeatable tasks. Each Day, Week or Month we clean up the same data, merge the same files or create the same report. Each time the process is the same but with different data. Wouldn’t it be great if we could get Excel to do most of that repeatable work for us? The good news is that we can, and we don’t need to be Computer Programmers to achieve it either! By combining Excels Advanced Tools of Power Query and Macros (VBA), This course will expose you to the time saving world of Excel Automation. This is a 6-week course of 1.5 hours each. In the first 4 weeks we will use generic solutions to introduce these powerful tools and their capabilities. In

Excel Essentials - Session 1 (26 July 2019)

Whether we are self-taught, or relatively new to Excel, we invariably have gaps in our Essential Excel Skill Set. We often end up plugging away the best we know how, even though there is this nagging feeling that there must be a simpler and more efficient way. Take time out to sharpen your Excel tools with this Excel Essentials Webinar course. Combining content from our standard Beginner and Intermediate Daily Courses, this online course systematically works through all the Key components of Excel in 6 weekly sessions of one and half hours each. Each subsection is presented using a carefully designed spreadsheet that enables one to follow along using practical examples, but also contains Key

Excel Tip - Verifying Personal Details using the SA ID Number

Its pretty well known that the first 6 digits of your South African ID Number is your Date of Birth. Un-beknown to many though, the SA ID Number has a few other Personal Details hidden within its 13 digits! This is the breakdown {YYMMDD}{G}{SSS}{C}{A}{Z} YYMMDD: Date of birth G: Gender. 0-4 Female; 5-9 Male. SSS: Sequence No. for DOB/G combination. C: Citizenship. 0 SA; 1 Other. A: Usually 8, or 9 (can be other values) Z: Control digit. Using this information and some neat Excel Formulas we can maximise the use of the ID Number to Verify and/or extract this key Personal Info, as well as validate the ID Number itself. Click here to Download this handy Spreadsheet that will enable you to do al

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

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

Email: info@summitsolutions.co.za 

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

2020 | Copyright | Summit Solutions