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