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.
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
Speaker
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.Who Should Attend
- Business users who use Microsoft Office and use spreadsheets
