Excel – Advanced Formulas & Functions
Human Resources
60 Minuts
Saturday, December 17,2022
- Tuesday, January 31,2023
STA2022063
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.
Who should attend?
Any business users who use Microsoft Office and use spreadsheets.
Why should you 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.
What you'll learn?
- Vlookups and Hookups
- Nesting IF statements with other functions
- Text functions
- Single Result Array formula
- SUMIF Function
Speakers
Ms. Jenny Douras
Jenny Douras is the President and founder of Advantedge Training & Consulting and is a national speaker conducting workshops across the country. She has over 25 years of experience in management, employee development, operations, knowledge management, technology, organizational development, and instructional design and training.
She specializes in Managing Remote Employees and has managed teams of up to 300 people across multiple states and countries. She has worked with many Fortune 500 clients and government organizations including Samsung, Lexmark, Burger King, Discount Tire, Microsoft, Fisher Investments, National Park Service, and the SEC.
Jenny sat on the board of directors for the Rocky Mountain Chapter of the American Society for Training and Development for 3 years. She received the STAR award (Strategic Training that Attains Results) from ATD in 2009, for the creation of a program helping the unemployed develop skills to return to the workforce. Her training manuals are internationally sold, and her articles have been published in many locations including the Denver Business Journal and International Association of Business Communications CW bulletin.
Choose Options
