Overview:

Excel is an amazing program that can do some complex and advanced calculations to help automate your spreadsheets and make your job easier.

This webinar will focus on some of the more commonly used complex formulas in the business world. If you already know how to do simple calculations and write a basic IF statement, then this course will take you to the next level by showing you how to create Lookup functions, nest IF statements with other functions, and show you some other useful functions to apply to your spreadsheets.

Why you should Attend: If you are ready to take Excel further than just basic formulas, this course will teach you how to work with more complex functions. Learn the functions most commonly used in business spreadsheets that can help you get more automation.

Areas Covered in the Session:

• Vlookups and Hlookups
• Nesting IF statements with other functions
• Text functions
• Single Result Array formula
• SUMIF Function

Who Will Benefit:

• Business users who use Microsoft Office and use spreadsheets