All in the mind


all in the mind

 

The following statement sounds incredibly much like common sense. Persistence and effort only deliver returns when we truly believe that we can make change happen. You have to be in it to win it. Your own assumptions about what you can achieve, also called your mindset, have profound implications on how you navigate your path and as a result how much you will flourish in the future. At LGIT Smart Solutions, we believe that as the Fourth Industrial Revolution rolls on, the right mindset will be critical for not being left behind. Let’s look at this concept of mindset in a bit more detail.

According to Dr Carol Dweck, a world-renowned Stanford University psychologist, there are two types of mindset. Each has the power to light up or disable the dreams and goals we set in life and at work. The first type of mindset is the fixed mindset. As the title implies, this mindset is shored up by a core belief that our abilities are relatively static and stable, and will not change significantly over time, no matter what we do. Abilities, talents and intelligences are all seen much like a hand that is ‘dealt’ in life. Achievements or right answers are proof of your talents. Failures show you up for what you lack. Because you don’t believe that you can change your hand much, ‘failures’ can have a crippling effect on the positive sense of self. The core belief ‘I cannot change anything’ may lead to a fear or avoidance of new experiences and risky situations.  People with a fixed mindset may feel as though they constantly need to prove themselves to others. Continue reading

Part 1: Will you be replaced by a robot? Here’s how to upskill yourself…


Data

The alphabet soup that has emerged in the world since Tim Berners-Lee started the World Wide Web 20 years ago this year, is astounding. From IT to AI to AR to VR, we’re all playing catch-up and the fantasy world that Star Wars and Star Trek made us believe in movies is finally coming true.

We already have Alexa and Siri, but it seems that before we have Data, R2D2 and C-3PO, we will probably have systems like Mother, the computer from Aliens, or HAL on The Discovery from 2001, or simply Computer from Star Trek.

So although the ubiquitous robot is still some way off (which is not the case in countries like Japan), the algorithm and the bot are here now, changing the way the world works. With such great progress, many articles have been written on which jobs will become obsolete the fastest. Think your IT job is secure? Think again…

Continue reading

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.