3-hour interactive workshops
Attend our new 3-hour interactive workshops each month:
- Learn to work with tools that are job specific
- Save costs
- Spend less time out of office in great learning environment
- Work with an Excel Master with real world experience
The contemporary business environment is a place of constant changes, with diverse personalities and points of view each striving to establish some kind of dominance in a continuously competitive space.
It’s a pressure cooker of stress, under which the ever urgent demand to deliver best practice and service is to perform, consistently. It’s a highly complex and ambiguous setting, one in which, we spend more and more of our time, with less and less distinction between career and life.
We are accelerating into a life/work future with more uncertainty than ever before.
Microsoft has announced Intune for Education, a new tier of its existing enterprise application and device management service that’s specifically meant for shared learning environments. Continue reading
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!
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
Virtual Learning: http://www.lgit.joburg
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
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!
- 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.
- 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:-
- 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)
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.