Getting started with Excel formulas and functions. Tapping into formula and function fundamentals ; Saving time with function tools ; Saying "array!" for formulas and functions ; Fixing formula boo-boos -- Doing the math. Calculating loan payments and interest rates ; Appreciating what you'll get, depreciating what you've got ; Using basic math functions ; Advancing your math -- Solving with statistics. Throwing statistics a curve ; Using significance tests ; Rolling the dice on predictions and probability -- Dancing with data. Dressing up for date functions ; Keeping well-timed functions ; Using lookup, logical, and reference functions ; Digging up the facts ; Writing home about text functions ; Playing records with database functions -- The part of tens. Ten tips for working with formulas ; Ten ways to get fancy with Excel ; Ten really cool functions.
Summary:
Describes how to take advantage of the built-in Excel functions that can be used in formulas, covering such topics as calculating loan payments, creating an accelerated depreciation schedule, and predicting future data from existing data. Understand how functions and formulas work together; Use formulas to evaluate and forecast your financials; Practice with step-by-step example functions.
This resource is supported by the Institute of Museum and Library Services under the provisions of the Library Services and Technology Act as administered by State Library of Iowa.