Master Excel: Building Resilient and Effective Budget Spreadsheets 2017

Topics

• 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

Who should Attend

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