Mastering Excel Formulas and Functions

This training program will aid those who use Excel at a basic level and help them learn to create formulas and use some of its built-in functions effectively. 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 on both Windows and Mac.

Why Should You Attend:

Do you create financial or data models? Excel is the perfect tool for that. In this webinar, attendees will learn how to build the model using formulas and observe the results automatically recalculate as the model is updated.

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. Let Excel do the work for you.

Learning Objectives:

• Learning what formulas are
• Learning how to create formulas
• Learning how to create functions to manipulate text
• Learning how to use Lookup functions
• Learning how to use logical functions
• Learning how to perform calculations for dates and time

Areas Covered in the Webinar:

• 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 for dates and time
• Using the IF function to automate data entry
• The VLOOKUP function
• Creating complex functions the easy way

Who Will Benefit:

• Accountants
• CPAs
• CFOs
• Financial Consultants
• Controllers
• Banking
• Finance
• Insurance
• Education
• Telecom
• IT
• Marketing
• Sales
• Investments
• Pharmaceutical
• Medical Devices
• FDA
• Aviation
• Energy
• Retail
• Human Resource
• Logistics & Supply Chain
• Accounts
• Audit