EXCEL CHAMPSA – 18 NOV 2016


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

New Microsoft MTA Exams Coming : Javascript & Python


download

The story of Microsoft’s love affair with open source technologies continues, In just over 3 years ago, Microsoft’s chief Satya made the (once seemingly impossible) announcement that Microsoft loves Linux and was planning to build tools that would deepen Microsoft technologies’ relationship with similar open source platforms and technologies. In confirmation of this development,  Microsoft Press will soon release an MTA training manual for Python. 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.

Vlookup1

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

Vlookup2

  • 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)

Last Chance : Win a DELL E7470 Laptop


CeImVN_WoAAkeJS

With less than 24 hours to go, you can test your Microsoft Excel skills and win a DELL Laptop! #ExcelChampSA  is a competition, provided to you by Microsoft and powered by LGIT Smart Solutions. How does it work? The idea is is download an Excel spreadsheet, which contains 3 excel related tasks you need to complete. The spreadsheet contains a timer which measures how much time you complete the exercise. The person who takes the least time to complete the test wins the laptop! Competition ends on the 30th March 2016 at 12noon, South African time. To learn more, click here.

Top Web Trends For 2015 [Infographic]


Trends Shaping Website Designs Worldwide

Top-5-Web-Trends-Infographic-Top-750x420

The web has changed dramatically over the past year, with an accelerated move to mobile first designs. Google’s Search algorithm update on the 21st of April 2015 now ranks mobile-ready websites higher. Other than just S.E.O focused trends, web design has also changed notably in 2015, with a wider adoption of Google Fonts, to enable better web experiences. The full infographic follows: Continue reading