Excel – Advanced Formulas & Functions

Jenny Douras

Date:
Sept. 4, 2025
Duration:
60 Minutes
Time:
11 AM EST | 8 AM PST | Thursday
Speaker:
Jenny Douras

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded

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. Understand Excel deeper and boost your confidence when using this common business platform through this webinar.


Why you should Attend:

Excel is a platform that is used by most if not all businesses in today’s busy world. It is essential that you have a deeper understanding of this platform to thrive in the ever-changing technical business world. Excel allows you to organize data, such as sales figures, taxes or commissions into different formats within a spreadsheet. It has many other features as well that allow you to enter, calculate and analyze the data you are working with.

If you are ready to take Excel further than just basic formulas, this webinar 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.


Agenda:

• Vlookups and Hlookups
• Nesting IF statements with other functions
• Text functions
• Single Result Array formula
• SUMIF Function
• Function helpers
• Using Validations for more advanced automation
• Date functions
• ISBLANK function

Who Will Benefit:

Business users who use Microsoft Office and use spreadsheets.

Live Version:

Recorded Version:

Combo Offers

Live + Recorded

Live + Recorded


Instructor:

Jenny Douras

Speaker

Jenny Douras is 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 has written over 40 courses on Microsoft Office and Professional Development topics, that have been sold around the world.