ComplianceOnline

Microsoft Excel: Breaking Down Complicated Formulae

Instructor: David H Ringstrom
Product ID: 704947
  • Duration: 75 Min
Purchase option for this webinar is currently unavailable. Please contact our Customer Care for more info.

Customer Care

Fax: +1-650-963-2556

Email: customercare@complianceonline.com

Read Frequently Asked Questions

This webinar will discuss and explain in detail the excel advance formulae. The instructor will define how to use the Evaluate Formula feature, apply hide and protect features to preserve key formulae and recall how to find and select all formulae within a worksheet. Participants will learn the F9 keys, IFERROR, N functions and more.

Why Should You Attend:

In this presentation, the instructor discusses and explains Microsoft Excel’s complicated formulae. He demonstrates features, such as the N function for making notes in the formula bar, using the F9 key to evaluate portions of a formula. After attending this webinar, you’ll have many more tricks at your disposal for quickly deciphering even the most complex Excel formulae.

The instructor typically teaches Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate techniques in a specific version of Excel upon request. His detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes a majority of the examples he uses to demonstrate techniques during the presentation.

Areas Covered in the Webinar:

  • Discuss the nature and types of preventive KRIs
  • Identify root causes and event drivers for each of your key risks
  • Quantify risk thresholds in line with risk appetite
  • Find out how indicators shape an organization’s risk culture
  • Decide strategies for effective reporting of risk indicators that lead to management action
  • Be able to discuss and evaluate the effectiveness of draft KRIs you have been considering for use in your organization

Who Will Benefit:

  • CPAs and Accountants
  • Marketing and Management Consultants
  • Bankers
  • CFOs
  • Controllers
  • Financial Planners and Consultants
  • Business Professionals
  • Business Analysts
  • Bookkeepers
  • Human Resources Staff
Instructor Profile:
David H Ringstrom

David H Ringstrom
Owner, Accounting Advisors, Inc

David H. Ringstrom, CPA, is an author and nationally recognized instructor who inducts multiple webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. Mr. Ringstrom’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Follow us :
ComplianceOnline Banking Summit 2016 | Risk Management and Data Security - 80390SEM
ComplianceOnline Medical Device Summit 2017

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading