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
Course is unavailable for purchase.
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
This Site uses cookies to store information on your device. Some are essential to make our Site work properly; others help us improve the visitor and user experience. By using the Site, you consent to the placement of these cookies. Read our privacy policy to learn more.