Note that data from different sheets in the same workbook can be referenced for formulas. For example, if you have two sheets, Sheet1 and Sheet2, you could bring Sheet2 data into Sheet1. If you wanted cell A1 in Sheet1 to equal the A1 in Sheet2, youd enter this formula into A1: “=Sheet2!A1”. The exclamation mark calls on the previous sheet referenced before locating the data.
However, spreadsheets have grown from simple grids to powerful tools, functioning like databases or apps that perform numerous calculations on a single sheet. You can use a spreadsheet to determine your mortgage payments over time, or to help calculate the depreciation of assets and how it will affect your businesss taxes. You can also combine data between several sheets, and visualize it in color_coded tables for an at_a_glance understanding. With all the new functionality, using a spreadsheet program can be intimidating for new users.
There are cases where what you see in the Formula Bar is different than whats in the cell. For example, lets say A1 = 1 and A2 = 2. If you create a formula in A3 that equals A1 + A2, then the A3 cell in your worksheet would show “3,” but the Formula Bar would show “=A1+A2.” This is important when youre trying to move cells to other parts of your worksheet _ remember that the display “value” of a cell isnt necessarily what the cell contains.
Excel also has close tie_ins with Microsoft Access, a database program, which can add power. In general, Excel integrates best with databases and any dataset requiring many calculations per workbook.