Best Mastering Excel Formulas and Functions 2019

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

Event Fee: One Dial-in One Attendee Price: US $290.00

Contact Detail:

Compliance4All DBA NetZealous,

Phone: +1-800-447-9407

Email: compliance4all14@gmail.com

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.