My Shopping Cart
There are no items in your shopping cart.

Master Key Excel Functions: Name Ranges, Goal Seek, Linking, Formula Auditing and More! (IME818B)

Presented by: Roman Kondratiuk
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
1.0 CPE

Boost Your Competency—and Accuracy—with Excel Calculations

When calculating, crunching, and analyzing numbers in Excel is your livelihood, you can’t afford errors. Unfortunately, you can’t effectively or efficiently use the software if you don’t fully understand the key functions. You must know how to apply correct structure and syntax to your formulas and functions—you can’t afford to guess!

Take an hour out of your day to fundamentally upgrade your skill with the help of Excel expert Roman Kondratiuk. In this information-packed webinar, you’ll learn how to use key Excel features—including Goal Seek, HLOOKUP, Formula Auditing, and more—to analyze data more efficiently and accurately. Kondratiuk demonstrates examples of formulas and specific functions, giving you a thorough understanding of what these features can do for your data.

After attending this audio event, you will understand proper formula structure and syntax—for increased accuracy. Plus, you’ll know how to use key features to save time, increase the consistency of your work, and improve data analysis outcomes. In the end, you’ll have gained confidence and a highly marketable Excel skill set—vital to a wide range of professions.

This session is appropriate for Excel users at introductory and intermediate levels.

Session Highlights

This program will teach you how to:

  • Work effectively with fundamental and versatile calculation and analysis Excel techniques
  • Form good formula habits: Use correct structure and syntax
  • Use the Round Function: Round numbers to a specified number of digits
  • Use Goal Seek: Find results by varying an input value
  • Use HLOOKUP: Search for, match, and return values across rows
  • Use names for constant values in functions
  • Define and use named ranges to automate function building
  • Manage links between multiple workbooks
  • Trace and correct more complex functions with Formula Auditing

Who Should Attend

  • Accounting professionals
  • Banking professionals
  • Auditors
  • Business Analysts
  • Economists
  • Financial professionals
  • Insurance professionals
  • Investors
  • Managers
  • Statisticians
  • Valuators
About Our Speaker(s)

Roman Kondratiuk | Microsoft Management Training SpeakerRoman Kondratiuk
Roman has qualifications in Management, Accounting, Training and Assessment and has delivered training to over 15,000 students, consistently receiving outstanding evaluations from his clients who include multi-national corporations and large government organisations. With over 20 years of experience in Learning Develo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Master Key Excel Functions: Name Ranges, Goal Seek, Linking, Formula Auditing and More!
    Presenter(s): Roman Kondratiuk

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team