Mastering Excel Formulas and Functions

OVERVIEW:  
Using formulas turns Excel into the world's most powerful calculator. 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.

Product Id : 501149

Instructor : Mike Thomas

Tuesday, March 28, 2017   |   10:00 AM PST | 01:00 PM EST   |   Duration: 90 Minutes

WHY SHOULD YOU ATTEND:
Although it is perfectly possible to use Excel without ever creating a formula or using a function, if you don't, you're missing out on a huge part of the application's power. Formulas and functions will automate your calculations and save you a ton of time. No more using your fingers. No more mental arithmetic.

AREAS COVERED IN THE SESSION:

• Creating formulas to perform mathematical calculations
• Copying formulas and the difference between absolute and relative references
• Assigning names to cells and using them in formulas
• 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 function
• Creating complex functions the easy way

WHO WILL BENEFIT:

• Any Excel user who needs to go beyond the basics of using formulas or simply wants to become more comfortable and productive in using Excel formulas and functions.
• 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 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.

Others Details

For more details and updates please visit webinar website