Conference Description:

Whether you need to calculate loan repayments, generate a profit-and-loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you’ll find that Excel is the best tool for the job.

Areas Covered in the Session :

>. Using functions to combine text strings from multiple cells
>. Using functions to change text from lowercase to uppercase and vice versa
>. Using functions to perform calculations on dates and times
>. Using the IF function to automate data entry
>. The VLOOKUP MATCH and INDEX functions
>. Creating complex functions the easy way

Who Should Attend:

This training is suitable for those with a sound working knowledge of Excel who want a greater understanding of more sophisticated formulas & functions within Excel.

The training will be delivered using Excel 2016 for Windows however much of the functionality is also available to users of earlier versions of Excel