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
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).
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”
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)