Category Archives for Excel

Power Training for Microsoft Excel Users

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

Microsoft Confirm Excel’s Role in Business Intelligence with MCSA Exam 70-779

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

Nested IFs and Russian Dolls

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

INFOGRAPHIC: Nesting VLOOKUP Functions

Combining LEFT, SEARCH and VLOOKUP

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