When you sign up for these savings plans, your company will give you a list of options as to how your money can be invested, and you choose the type of investments you would like the company to make on your behalf. In addition to the tax benefits afforded by such plans, many employers match a percentage of your monthly savings or deposit money into your retirement account as an added form of compensation. These plans allow you to deduct money from your paycheck every month, tax-free, and invest it. Many companies offer employees retirement savings benefits through 401(k) or 403(b) Employee retirement savings plans offered by businesses and by public and private institutions. Although it may seem that managing investments is a specialized career choice, the reality is that almost everyone will become an investor at some point in their lives. This section reviews the use of logical functions in Excel through the construction of an investment portfolio.
HOW TO USE VLOOKUP IN EXCEL TO ASSIGN LETTER GRADES HOW TO
Learn how to set a conditional format rule so formatting commands are automatically applied based on the value in a cell location.Review the construction of nested IF functions for evaluating data using more than one logical test.Learn how to use the AND function within an IF function to evaluate the data in a cell location using multiple logical tests.Learn how to use the OR function within an IF function to evaluate the data in a cell location using multiple logical tests.Learn how to use the IF function to evaluate the data in a cell location using a logical test.Learn how to construct a logical test to evaluate the contents of a cell location.Understand the construction and use of formulas, basic statistical functions, and financial functions.Learn how to use the Freeze Panes command to lock specific columns and rows in place while scrolling through large worksheets.In this chapter we look at how you can decide where to invest your money and how to analyze the performance of those investments. In the personal budget project, we analyzed the impact of investing money in an account that provides a continuous rate of return. This theme builds on the personal budget project introduced in Chapter 2 "Mathematical Computations". We will demonstrate the skills for this chapter through the construction of a personal investment portfolio.
These functions are used to find data in one worksheet and display it in another. The last section of this chapter demonstrates the use of two lookup functions. These functions combine the logical test feature of the IF function with the mathematical computation features of statistical functions (which were reviewed in Chapter 2 "Mathematical Computations"). The second type of logical function that we will look at are statistical IF functions.
The OR and AND functions also use logical tests to evaluate the contents in a cell location and are often used within the IF function. The first is the IF function, which uses a logical test to evaluate the contents in a cell location. We will look at two types of logical functions in this chapter. Logical functions are used to assess the contents within cell locations and produce custom outputs or mathematical computations. This chapter takes you beyond basic Excel computations by introducing logical functions and lookup functions. Going beyond the basic computational tools of Excel unlocks unlimited potential for processing and analyzing data.
0 kommentar(er)
