The Excel ChampSA Finale was held at Microsoft Head Office in Bryanston on 18 Nov 2016,  to find the Super Champ who will represent South Africa in the first ever Excel Global Champs!

Excel Champs

Four candidates went head to head, battling it out to see who would come out on Top. The competition was by no means easy and all were sitting on the edge of their seats in this exciting last round, which would decide the top SA Champ.

Jackie Blommestijn, one of LGIT Smart Solution’s experienced Excel trainers presented videos in the run up to the final round.  Jackie was also given the honour of being a Judge at this prestigious event. After much debating and reanalysing the answers again and again, an undisputed winner was announced. Well done to Corne van Heerden from all of us at LGIT Smart Solutions. Excel Champ second time in a row! You are a worthy winner. LGIT are proud to have been associated with this championship, which has led to your representing SA in the Global Champs to take place early next year.

For all who would love to prove their worth as next year’s Excel SA Champ, click on the VIDEO links below to see Jackie in action, guiding you to becoming an expert in the topics listed:

For all your training needs, do not hesitate to contact us.  Our professional staff will help you to get up to speed.

Phone: +27 11 802 1636
Web: http://www.lgit.co.za
Virtual Learning: http://www.lgit.joburg

Tip of the week – Excel shortcuts

Do you find it takes you forever to move your way round a large spreadsheet?  Making use of these age old shortcuts helps you work smarter – not harder!  CTRL End will take you to the last cell with data.  CTRL Home will take you to the top of your spreadsheet.

To select just the data and not the whole spreadsheet, click inside a cell with data and press CTRL A.   This will select the current region only (to the first blank column and first blank row on either side of the data).


Continue reading

Tip of the week : Absolute Cell Address

Often, when you need to copy a formula down, it must reference one particular cell.  That’s when you put in the dollar sign in the formula, ie you make the cell Absolute.  This is a definite must to ensure that when copying, this cell stays constant.


If you look at the formula above, when copying the formula down, E6 must become E7, which becomes E8 etc.  That is a relative cell address.  But B3 must stay B3.   To ensure that, click in the Formula Bar next to the cell you wish to make Absolute (in this case, cell B3).  Press F4, which will add the dollar signs, making the cell Absolute.  In the above example, B3 is the cell which must stay constant.  So it should read – $B$3.  Now when you copy for the formula down, all formulas will stay constant  and ALL will multiply by B3.

“Watch this space for the next exciting tip.  OR you can beat the rest by contacting us on 011 802 1636 and book your space on our professional training”

#ExcelChampSA : Win A Trip To Seattle, USA

Do you think you have what it takes to be the Excel World Champ?


The very popular Excel competition is back. Last year the Microsoft sponsored competiton #ExcelChampSA was very successful with hundreds of applications received. The grand prize last year was  a DELL Laptop, however this year, the stakes are much higher, as the top prize will be a trip to Seattle, USA!! Continue reading

Battling with VLookup??

VLOOKUP lets you search for specific information in a Worksheet. For example, if you have a list of Product Codes with Prices, you could search for the Price or actual Item for a specific Code.  It also lets you search between different Worksheets.

Its soooo easy when you know how!

  1. Highlight the range you want to analyse (on the OLD sheet) and name the Range. You will then have a range with absolute cell addresses ($ sign) in the formula. Makes copying easy as anything.
  2. Count the columns in the highlighted range before you do the formula.


  • Go to the NEW sheet, click where you want the answer to be.  Insert the VLookup formula.


  • Complete as follows:- Vlookup3
  •  Now copy the Formula down.  And Hey Presto!  You have added the data from the OLD sheet, without you having to do a Find, Copy & Paste – through thousands of lines!

(If you already knew how to do this, please enter the Excel Microsoft Champ of South Africa Competition at #ExcelchampSA)

How To Use Office 2016 For Free

There are various ways you can access Microsoft’s latest Office suite


So Office 2016 is out and you want to get your hands on it so bad, but you are not willing to part with your money . . .just yet? Well there is good news for you : If you’re not a power user and don’t need all the latest and greatest features, then you can access Office 2016 . . .well.  . .for free!

Continue reading

Microsoft Office 2016 Released

Now Generally Available Worldwide


As promised, Office 2016 has been released is now generally available worldwide. The full Office for Windows 2016 suite includes new versions of Word, Excel, PowerPoint, OneNote, Outlook, Project, Visio and Access.  Along with Office 2016 for Windows, Microsoft also released Office 2016 for Mac as a one-time purchase option, along with several new and enhanced Office 365 services. Continue reading