Show as: Mobile

Work in L&D? Contribute to research that will shape our 2021 L&D Report! Take our survey

Mastering EXCEL Formulas and Functions - Part 2

AMA - American Management Association
Training overview
Professional Course
1 Lessons
From 199 USD
Start dates
199 USD
Inquire for more information
AMA - American Management Association

Course description

Mastering EXCEL Formulas and Functions - Part 2

Deploy Time-Savers That Ease Your Data Analysis Chores

Excel includes hundreds of functions designed to save you time — but learning how to use ALL of them can be a challenge. The second part of this webinar focuses on using work-saving functions, spreadsheet-building methods, and other techniques to speed you through your work.

In the second part of this webinar, your instructor will walk you through manipulating and formatting spreadsheet text, using financial functions, taking control of date and time challenges, and using a handful of the latest functions appearing in Excel.

You’ll be armed with the knowledge you need to avoid misinterpreting critical data, losing precious time recalculating, or missing out on additional analysis already at your fingertips.

Attend and expand your analytical capabilities as you master the power of Excel and add a whole new level of depth and analysis to your worksheets!

Who should attend?

This two-part webinar is for anyone who uses Excel at a basic level and wants to learn how to create formulas and use some of the built-in functions.

Training content

Because there are so many functions available for your use in Excel, this webinar has been divided into two information-packed programs. In Part 2, you’ll get step-by-step demonstrations showing how to:

  • Cross-reference data with the table-lookup functions VLOOKUP, INDEX, and MATCH
  • Use frequently-overlooked Text functions to clean and modify the display of your data
  • Adjust your results with ROUND, ROUNDUP, and ROUNDDOWN
  • Apply financial functions including PMT, RATE, and FV
  • Manipulate data with the newest functions, including IFS, CONCAT, TEXTJOIN, MINIFS, and more


Course price for:

  • Non Members: $199.00
  • AMA Members: $199.00
  • GSA: $199.00

Certification / Credits

After completing both parts, you will understand and be able to apply Excel formulas and functions to solve a variety of data analysis problems.

About AMA

About American Management Association International

For over 90 years, American Management Association International (AMA) has been a world leader in professional development. AMA supports the goals of individuals, organizations, and government agencies with a complete range of corporate talent transformation solutions, including public open-enrollment seminars...

Read more and show all training delivered by this supplier

Contact info

AMA - American Management Association

Training reviews

No reviews available

Special Offers
Experience best-in-class virtual...
AMA - American Management Association
Read more

Need help with your search? offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote