Building Effective Budget Spreadsheets in Excel

Authored by David Ringstrom
About this Course
Topics covered include: Preserving key formulas using hide and protect features; Learning how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations; Streamlining formula writing by implementing the Use in Formula command; Using the SUMIF function to summarize data based on a single criterion; Avoiding the complexity of nested IF statements with Excel's CHOOSE function; Learning how the Table feature allows you to transform filtering tasks; Learning a simple design technique that greatly improves the integrity of Excel's SUM function; Improving the integrity of spreadsheets with Excel's VLOOKUP function; Comparing and contrasting IFNA, IFERROR, and ISERROR functions and learning which versions of Excel support these worksheet functions; Going beyond simple rounding with the ROUNDUP and ROUNDDOWN worksheet functions. Upon completing this course, you should be able to: Define how to isolate all user entries to an inputs worksheet, while protecting all calculations and budget schedules on additional worksheets; Identify and apply range names and the Table feature to create resilient and easy-to-maintain spreadsheets; Calculate borrowings from, and repayments toward, a working capital line of credit; Recognize and apply keyboard shortcuts to building an effective budget spreadsheet; Identify what the CHOOSE function returns when Index_Num argument exceeds the number of Index arguments; Describe SUMIF's arguments and returns; Recognize how to improve the integrity of SUM formulas in Excel; Identify which menu in Excel various commands appear; Recognize which part of the formula Excel calculate first, when a portion of a formula is wrapped in parentheses; Identify the character which signifies an absolute reference within a formula; Describe the VLOOKUP function with the following arguments.
$ 30.00
Add To Cart
NASBA Field of Study
Computer Software & Applications
Level
Intermediate
CPE Credits
2.0
Prerequisites
Experience with Excel Spreadsheets Recommended.
Last Updated
11/05/2018
14792