Overview:
Functions are built-in formulas that have been programmed to perform a specific calculation. They range from the simple such as SUM and AVERAGE (used to calculate the total and average of numbers in a range of cells) to the powerful IF and VLOOKUP.
Why should you Attend:
How to create formulas will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic. No more using the calculator app on your Smartphone! Let Excel do the work for you!
Areas Covered in the Session:
VLOOKUP, HLOOKUP, INDEX and MATCH
GETPIVOTDATA
Trapping Errors - Using functions to bullet-proof your worksheets
Creating complex functions the easy way
Who Will Benefit:
Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar
Speaker Profile:
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 He founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.
Event Fee: One Dial-in One Attendee Price: US $290.00
