Master Excel: Building Resilient and Effective Budget Spreadsheets 2017

  • 06 Jul 2017
  • Webinar

Description

Master Excel: Building Resilient and Effective Budget Spreadsheets 2017 is a webinar that covers topics such as:

  • Streamlining formula writing by using the Use in Formula command
  • Avoiding the complexity of nested IF statements with Excel`s CHOOSE function
  • Comparing IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions
  • Improving the integrity of spreadsheets with Excel`s VLOOKUP function
  • Learning a simple design technique that greatly improves the integrity of Excel`s SUM function
  • Going beyond simple rounding with the ROUNDUP and ROUNDDOWN worksheet functions
  • Learning how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations
  • Using the SUMIF function to summarize data based on a single criterion
  • Preserving key formulas using Excel`s hide and protect features
  • Learning how the Table feature allows you to transform filtering tasks

Master Excel: Building Resilient and Effective Budget Spreadsheets 2017 is intended for:

  • CPA`s
  • Accountants
  • Controllers
  • CFO`s
  • Income Tax Preparers
  • Excel Users

Past Events

Important

Please, check "Master Excel: Building Resilient and Effective Budget Spreadsheets" official website for possible changes, before making any traveling arrangements

Event Categories

Business: Finance

Other Events with Similar Categories

Other Events with Similar Location or Organizer

Featured Conferences & Exhibitions