Excel - Advanced Formulas & Functions

Jenny Douras
Instructor:
Jenny Douras 
Duration: 60 Minutes
Webinar ID: 70461

More Trainings by this Expert

Price Details
Recorded Webinar
$199 One Attendee
$399 Corporate Recorded

Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)

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


Speaker Profile
Jenny Douras is President at AdvantEdge Training & Consulting. She has over 25 years of experience in management, employee development, operations, instructional design and training. Jenny has managed teams of up to 300 people across multiple states and countries, working with several Fortune 500 clients. From this experience she developed her Remote Employee Management Class. She also sat on the board of directors for the Rocky Mountain Chapter of the American Society for Training and Development for three years, and is an active member of the Colorado training community.


You Recently Viewed

Subscribe to our Newsletter