Sales Ended

Excel Essentials: Deciphering Complicated Formulas

Event Information

Share this event

Date and Time

Location

Location

Online Training Courses

Friends Who Are Going
Event description

Description

Excel Essentials: Deciphering Complicated Formulas

Speaker : David H. Ringstrom, CPA


In this illuminating presentation, Excel expert David Ringstrom, CPA, explains various ways to make sense of complicated formulas within Excel. Oftentimes, formulas can grow out of control, or, more likely, you’ve inherited spreadsheets from others that you’re to take ownership of. After participating in this webcast, you’ll have lots of tricks at your disposal to quickly decipher even the most complex Excel formulas.

Learn from Excel expert David Ringstrom, CPA, how to gain control of writing and understanding complex worksheet formulas in Excel.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
  • Comparing and contrasting IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions.
  • Finding and selecting all formulas within a worksheet with just a couple of mouse clicks.
  • Getting a rundown on what the various # sign errors in Excel mean.
  • Learning how mindfulness with regard to worksheet names can have a dramatic impact on comprehending your formulas.
  • Learning how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations.
  • Learning how to trace dependents and precedents, both with Excel features and keyboard shortcuts.
  • Learning the risks of linked workbooks, determining if a workbook contains links, and seeing how links can hide within Excel features.
  • Learning two ways to instantly display all formulas within a worksheet.
  • Moving through formulas in slow motion with the Evaluate Formula feature.
  • Preserving key formulas using hide and protect features.
  • Seeing the pros and cons of using the F9 key within Excel’s formula bar to evaluate a portion of a formula.
  • Simplifying formula auditing by way of the Apply Names feature.
  • Simplifying repetitive tasks by creating your own keyboard shortcuts.
  • Streamlining formula writing with the Use in Formula command.
  • Tracking down the ripple effect of errors in spreadsheets with Excel’s Trace Error command.
  • Using the N function to annotate formulas within the formula bar when a cell comment won’t suffice.
  • Utilizing the FORMULATEXT function in Excel 2013 and later to display a formula from one cell in another.
  • Understand various ways that will help you understand complicated Excel formulas.
  • Learn the benefits of using range names.
  • Understand how to streamline formula writing.
  • Learn to create keyboard shortcuts to reduce repetitive tasks.
  • Learn two ways to instantly display all formulas within a worksheet.
  • Understand how to simplify formula auditing.
  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel Users
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers

Please Click Below Link For Registration:

https://www.demystifiedsolutions.com/trainingDetails/Excel-Essentials-Deciphering-Complicated-Formulas-DEMY051445


Share with friends

Date and Time

Location

Online Training Courses

Save This Event

Event Saved