If you were tracking spending, you would put the cost of the item in the category it falls under, and leave other cells blank. My Excel workbook would then look like the 1st picture. In cell A3 I would write "Crackers', in cell B3 I would type in "2", in cell C3 I would type in "11", and in cell D3 I would type in 6. Input the corresponding value for that category Example: Let's say I eat some "Crackers" with 2.0 grams of protein, 6.0 grams of fat, and 11.0 grams of carbohydrate. Type the name of the item (For my example, I typed in that I ate "Crackers" under "Food Name"ģ. Note: You are not limited to only three cells to sum you can make your border as many rows as you like in the previous step, and sum as many cells as you think you need to track a day of eating, or a month of spending, etc.īefore we create our pie chart, let's input some data.Ģ. Once completed, your Excel workbook should look like what is shown in the 3rd picture. Note: The equations for cells C6 and D6 should respectively look like Repeat steps 1 through 6 for the C Column (Select cell C6 and sum the cells C3 through C5) and the D Column (Select cell D6 and sum the cells D3 through D5). Press the "Enter" key on the keyboard Note: If done correctly, the value in the sum cell (Cell B6) should be 0, and the equation in the cell should beħ. Drag the cursor down to cell B5 (At this point, Cells B3 through B5 should have a moving dashed-line around them, as can be seen by the call-out in the 2nd picture).Ħ. the word 'SUM' is a built in command in Excel that will sum all the values in a determined amount of cells.Ĥ. Note: the equals sign means that we want to assign a value or a function to this cell. Type in "=SUM(" without the quotation marks (Shown by the call-out in the 1st picture). Click on cell B6 (The first cell below the border in the B-column).Ģ. In this step, we will create the cells that sum all the values in one category.ġ. Since my original goal for making these instructions was to help people pay attention to what they eat, I will use the example of tracking the amount of protein, carbohydrates, and fat that are in foods eaten. Just by making some simple alterations to the steps that will be shown, you can use this Excel format to measure and track just about anything! This Excel format could be used to track other things, like how much money you are spending on different types of goods, or how much time is spent on different tasks. What making this spreadsheet will allow you to do, is to input the number of grams of each category, and see what your daily intake of each of these categories are in percentages (shown by a pie chart). Let's say that you want to make sure that you're getting a healthy balance of protein, carbohydrates, and fats each day 20% protein, 50% carbohydrates, and 30% fat, for example.
How to use microsoft excel 2010 to male schedule how to#
For shorter time periods, use an hourly schedule template or a time schedule template.įully customizable and easy to use, you’ll eliminate unneeded stress when you use any of our free schedule templates.The goal of these instructions is to walk you through step-by-step on how to make your own personal Excel spreadsheet that will allow you to track percentages of different things. Do the same to maintain your office, with a schedule template that specifies the frequency required for each task. Maintain your home and all its elements, including plumbing, electrical, appliances, and interior and exterior amenities with a household management scheduling template. Use a schedule maker to track vacations, personal days, sick days, or other time off. Manage homework assignments or group projects with an Excel schedule template.Įnsure adequate shift coverage with an employee schedule template. Use a schedule template to track your fitness goals, work projects, or chores.Ī weekly schedule template is great for routine items or special events, like conferences, training programs, or travel plans. Creating a schedule is easy with preformatted weekly planner templates. You’re just a click away from staying on track with a schedule template that’s sure to help you maintain a consistent calendar. Keep yourself on track and organized with a weekly schedule template