You can use a template to create lists and organizers, too-look for ones with built in charts if you want help visualizing your data. If you make your own list or tracker, consider creating and customizing a graph or chart to illustrate trends or breakdowns-just select the appropriate information and click the graphic option you want under the Insert tab. If you want to add data about the historical performance of a stock, use the STOCKHISTORY function-detailed instructions can be found here.Įxcel contains useful tools to organize, visualize and keep track of changes in lists and projects. Start by typing in a company name and changing it to Stocks data-if Excel recognizes the company, it links, uploads and updates information in real time about the company’s stock market price and price change. You can track how your investments are doing using Stocks data under the Data tab. =COUNT to count how many cells contain numbers in a range of cells.=MIN to find the smallest number in a group of cells.=MAX to find the biggest number in a group of cells.=AVERAGE to find the average of a group of cells.

Here’s Microsoft’s complete list of all Excel functions, but here are some common ones to get you started: Like with budgets, Excel comes with health templates preloaded with formulas, functions and graphics to make tracking easier. Functions are commands that perform calculations and analysis for you-instead of adding calories together using a formula with a plus sign, you could use the SUM function to add calories for you.

Once you’ve entered your chosen data, you can manipulate it using formulas and functions.

Subtract cells using a dash or minus sign (-)Įxcel can help you track calories, exercise and health goals.

Excel 360