Building Effective Budget Spreadsheets in Excel 2017

Topics

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

Who should Attend

• CFOs
• Accountants and CPAs
• Controllers
• Financial consultants
• Human Resources Personnel
• Accounting Personnel