INFOGRAPHIC: Nesting VLOOKUP Functions

Excel Online Training When they hear the term “nested IFs”, a lot of people will visualize a structure whereby you have one parent IF statement with several IF statements nested inside it; and this is not actually the case. A better way of visualising nested IFs is to think of a Russian doll arrangement, whereby…

Microsoft’s MCSE (Microsoft Certified Solution Expert) and MCSA (Microsoft Certified Solution Associate) qualifications do not normally include an assessment of an IT pro’s ability to use Microsoft Excel. However, this has all changed with the inclusion of Exam 70-779 as a requirement for obtaining the MCSA: BI Reporting. The introduction of the Power Pivot add-in…

Excel Online Training To complete this tutorial, you will need to download and UnZip the following file from GoogleDrive; it contains two versions of the workbook used in the tutorial: the start version and the completed version. Download the tutorial workbook(s) In the download tutorial folder, open “04 Manipulating Text”; and then open the Excel…

Microsoft Excel is an essential tool for most modern businesses, providing a dazzling array of features for manipulating and analysing organisational data. The concept of power training for Excel users is not new; and the traditional route to becoming an Excel power user has been to develop a fairly large repertoire of advanced techniques; such…