Understanding the financial impact your vehicle has can literally save you thousands of dollars. I have personally used this tracker for years to help me understand what I have and have not done to my vehicles.
Here are just some of the reasons why it is extremely beneficial to track your vehicle expenses:. You can prevent getting ripped off on repairs by looking back and seeing what you paid in the past for the same repair. You will know if you have accomplished milestone maintenance items such as engine flushes, so you don't accidentally pay for them twice. You have a printable log of your vehicle's history which will add value and assurance to your vehicle when you try to resell it.
You will have reminders of warranties and where to go to take advantage of them. There are many more benefits to tracking your vehicle expenses, but those previous four points have saved me a tremendous about of money and have given me confidence during my trips to the mechanic.
Knowledge is truly power! I am all about keeping things as simple as possible. Through the years I have personally used this log spreadsheet, I have narrowed down the pieces of information to just 5 fields of data you truly need. Immediately after you have a repair done, all you need to do is take your receipt to your computer and log these 5 things.
It may give you an option to replace existing data, or to create a new sheet. Choose the best option for your situation. This spreadsheet shows the number of murder victims in each year from to in five columns, with the columns labeled by year in cells B4 to F4. Below that the spreadsheet shows the weapon used in the murders in 18 rows of data, with the rows labeled by type of weapon in cells A5 which is the overall total for all weapons to A You can improve the display of the data in a spreadsheet by increasing or decreasing the width of a column or the height of a row.
Note for Excel: if you narrow the width of a column displaying a number too much, you will see a series of pound signs displayed in the cell:. You can also speed up the resizing of columns and avoid making them too narrow by moving your mouse cursor to the border separating two columns in the gray bar at the top and double-clicking on the border.
This will automatically resize the column to the left, making it just wide enough to fit the longest entry on any row in that column. To delete a row, hover your mouse cursor over a row number in the gray area to the left, in this case row Right click and in the pop-up menu select Delete row. Hover your mouse cursor over a column letter in the gray area at the top, right click and in the pop-up menu select Delete column you also can click on the tiny downward-pointing arrow to get this pop-up menu.
If you want to add a column or row, again hover your mouse cursor over the appropriate column or row in the gray area above or to the left, right click and in the pop-up menu select one of the Insert options. With a spreadsheet you can insert a formula that will instantly add, subtract, multiply or divide numbers in columns or rows.
A formula then has a symbol for what kind of calculation you want to perform add, subtract, multiply, divide, etc. The symbols a spreadsheet uses for calculations are:. In the spreadsheet for types of weapons used in murders that we downloaded from the FBI website, the spreadsheet already included the total number of homicides in which any kind of firearm was used each year from to Those numbers are in row 6.
This would require totaling up for each year the column of numbers for the five weapon types in the spreadsheet:. This tells the spreadsheet to add up the number of murders committed with handguns B7 , rifles B8 , shotguns B9 , other guns B10 , and firearms, type not stated B11 for the year If we now wanted to calculate the total number of gun related homicides for the other four years, we could repeat the process of typing an addition formula into each cell in the rest of row But a spreadsheet has a much faster way of accomplishing this — by letting you simply copy the formula to one or more of the other cells in the same row.
Pass your mouse cursor over the bottom right corner of cell B23 and notice your cursor changes from an arrow pointer to a thin crosshairs. Click on that crosshairs , hold down your mouse button and drag your mouse to the right over the rest of the cells in row Release your mouse button and the total number of homicides involving firearms for each year from to will appear in row The spreadsheet has calculated these totals for you by applying the formula you first typed in cell B23 to the rest of the cells in row You can double click on the cell to display the formula in the cell and then edit or retype it there.
To edit the formula you can click in the formula bar where the formula for this cell is displayed. Cells can display their data in many different ways. For example, you can format a cell to display data as currency, as a date, scientific notation, or several other formats.
For example, in the case of currency format, the cell data could have several decimal places. But when formatting for currency, a dollar symbol will display and the cell will only show the hundredths place 2 decimal points , even if the actual data in the cell has is more exact and has more decimal points.
The way to understand what the actual data is in a cell is to look at the formula bar. This will sometimes show you the raw data. The cell format is generally used to make thing more human-readable. But sometimes this can be the cause of consternation, especially when using formulas. This could especially be tricky when using dates. This next section will describe how to calculate a percent change between two numbers.
A percent change is calculated by finding the difference between the two numbers, and comparing that difference by the first number. In our spreadsheet on murder weapons, we can calculate how much each weapon increased or decreased between to This formula tells the spreadsheet to find the difference of homicides by subtracting the total homicides in from After that, divides the results to the original value.
Note: The parentheses in this formula are also important to define the correct order of operations. The total number of homicides by all types of weapons declined by 9.
But to make it into a more human-readable format, we can change the data format of the cell to a percentage.
If you want to be able to edit the file as a spreadsheet in the future, it's a good idea to select Microsoft Excel. Navigate to the destination folder. This is the folder to which you'll be saving the file. Click Save. The Sheets file will now download to the selected folder in the selected file format.
Include your email address to get a message when this question is answered. Related wikiHows How to. How to. About This Article. Written by:. Nicole Levine, MFA. Co-authors: 2. Updated: September 6, Categories: Google Applications. Finally, there are the functions. Calling cells in formulas is also somewhat more difficult in Word. If you have a single row table, then every cell will be row 1 - A1, B1, C1, etc.
The other relevant item to spreadsheets that can be created in Word is the chart function. In the Insert tab, click the insert Chart button to access this feature. Once you choose a style, it will open Excel so you can edit the chart data. The functionality works exactly the same as in the Excel tutorial above.
However, once the chart is in Word, two new tabs in the Ribbon , in place of Table Design and Layout. They become Chart Design and Format. Use these tools to add extra important elements to your chart, either individually with Add Chart Element , or all at once using the helpful presets with Quick Layout.
Use these tools to adjust the style of your chart without changing its layout too much. You can adjust colors, drop shadows, background, and more. Manipulate data in the chart with this set of tools. Select Data takes you back into your Excel session to choose data set you want represented in the chart. Edit Data in Excel allows you to change anything you like about the data in Excel. You can also go into Excel by double-clicking your chart.
When you return to Word, click Refresh Data to update your chart to reflect any changes made to the data in Excel. Change Chart Type allows you to switch from a pie chart to a line graph and so on, using the same set of data. You can select the Plot Area where the graph is stored, the Chart Area where all the axis labels exist, or any other element. Use this to insert shapes into your chart, just like inserting any other object into Word.
Use these tools to color every element on your chart, which can include how you want to fill in lines, the text color, and more. These are all your style options for text in your charts that handle adding WordArt, a fill color, and more. The positioning tools work similarly to positioning other objects in Word.
You can make the text wrap around the chart with Wrap Text , and place it behind or in front of any other element on the page.
Use these tools to numerically change the height and width of the entire chart. This opens the Format Pane , which has some of the same tools found in the Ribbon , but they are larger and easier for some to access. When you open Word, this screen appears. The New tab on the left side lets you create a new document, Recent surfaces recently opened documents, Shared shows documents that other Word users have sent to you, and Open opens a file browser for selecting an existing document.
On the New tab, you can see a number of templates which you can use to jump straight into making different types of documents like resumes, blogs, and research papers. Once your document is created, save it by clicking the save icon shown above, and select a location to save it.
This opens a file browser window, where you can select the Simple Budget spreadsheet you created earlier, for instance. Open it. Step 4: Resize Spreadsheet to Fit. A spreadsheet as large as the one we created is too large for a standard Word document at its normal size.
To shrink it, click once on the imported spreadsheet, and hold down the Shift key. While pressing Shift , select a corner of the spreadsheet and drag it towards the center of the object a few times.
Feel free to add text below the spreadsheet, as well. However, all of your formulas and formatting will remain intact. You can still work with the rest of the document, typing words and inserting pictures around the spreadsheet.
To edit the data, double-click the spreadsheet to open the spreadsheet in a new Excel window. Here, you can edit any data. It updates in real-time, meaning that as soon as you make the change in Excel, the change will be reflected in Word. In this way, you can bring fully-functional spreadsheets straight into Word. Note: When you double-click on an inserted object like an Excel workbook, you have access to the entire workbook, not just the first sheet which appears as an object in Word.
The newer version of Word lets you simply copy and paste cells and other Excel elements from an Excel workbook into a Word document. In your Word document, right-click on your mouse and click Paste to paste your chart and your selected Excel worksheet content into your Word document, one at a time.
Step 4: Format Your Data. Charts in Word behave a lot like charts in Excel. When you single-click a chart to select it, it opens the Chart Design and Format tabs so you can manipulate information for example, the design and layout. You can also hover over areas of this pie chart to surface additional information such as how many dollars the blue portion represents.
A lot of the formatting as is kept intact, but you lose almost all the formulas. For example, notice the months in the header are no longer angled 45 degrees upward. If you click on the Formula button while keeping your cursor in any cell, the formula that cell contains should appear. You can re-enter this formula, and it will insert the new sum, but it will treat the rest of the text inside this cell as just text, squeezing the new sum in with it.
The conclusion? Copying tables directly from Excel can be a quick way to get a visual table into Word. Charts, however, are fine to copy and paste into Word, as they are still editable in Excel with their full functionality. Step 2: Insert New Excel Elements. This time, open the Insert tab and go to Insert Object , then click either Microsoft Excel Chart to insert a chart, or Microsoft Excel Worksheet to insert a full worksheet. Click OK. Either option will open Excel.
The Microsoft Excel Worksheet will open a blank Excel sheet. You can enter whatever information you want into it, following the same process as you used in the Excel tutorial above.
You cannot change anything about the data in Word, and will again have to double-click the object to open Excel to make edits. If you find you have extraneous cells, you can also double-click to open Excel, select the data you want, then right-click and select Copy. Delete the original object. Charts will work as described in the previous section on copying Excel charts.
Adding a chart will open an Excel file that has one sheet with the chart, and one with the data. Once you save the chart in your Word document, the data will stay in Excel with only one sheet, and the chart will appear in the Word document.
You can change the data in Excel at any time by double-clicking the chart, and changing the styling of the chart in Word. The other way to insert a chart into Word is to click the Insert tab, then click Chart , and select the type of chart and design you want. Then, you will be taken to Excel to enter your data from scratch, which will update your chart in Word. Step 3: Change Alignment and Text Wrapping.
First, shrink the size of the chart by clicking the corner of the object and moving it inward. This action creates a more manageable size. To move your chart or table more freely, single-click on your table or chart, and click the Layout tab on the Ribbon.
Select Wrap Text , and click Tight to drag-and-drop the object anywhere on the page. The final way to create spreadsheets in Word is to create a table from scratch. Step 2: Insert a Table. Click the Insert tab, and click Insert Table to see a grid. You can hover over the small squares to create a table of any height and width. Step 3: Create Headers. Now we have a blank table with a set amount of cells.
The cursor appears in the first cell of top row. Start typing to create column headers. Step 4: Enter the Data. Enter your data for each day, consisting of your necessary tasks and the hours they require. Sometimes text might be longer than a cell, causing it to split into two lines. Change the width of the cells with longer content by grabbing the left or right edge of a cell, and dragging it as you see fit.
Step 5: Apply Styles. To make the schedule visually appealing, apply quick styling presets to it. Click the Home tab.
Select your entire table, then choose a preset you like from the Ribbon. Since you have a heading row, make sure to choose a style that makes it visually distinct. Now you have a simple, nicely-designed table you can use for day to day scheduling. To extend it and add more items to your to-do list, click a row and then right-click on your mouse and choose Insert: Rows Below.
See a complete list of keyboard shortcuts in Microsoft Word. This section will cover all the basics for working with Google Sheets.
Google Sheets is a spreadsheet app that lives in the cloud, meaning you never have to download anything, and you can update Sheets from any computer or smartphone. Google Sheets is not quite as robust as Excel in terms of functionality. What Google Sheets does have, however, is quite good for basic users: real-time collaboration abilities. Sheets integrates with all other Google products, allowing you to insert Google Forms data automatically. Sheets you create will be saved to your Google Drive account, and you can quickly insert any images you have in Google Photos.
This takes you back to the Google Sheets hub page, which contains your most recent Google Sheets and a number of templates. Use this area to name your Sheet. Click Untitled Spreadsheet and type a title for your sheet. Clicking on the folder icon shows you where this file is located in your Google Drive, and allows you to move it. All the icons along this grey section are your main toolbar. They include simple formatting options, alignment options, commenting, filtering, and some function tools.
You can enter and view different formulas for cells here. The Comments button opens all comments and allows you to leave comments on the current cell or range of selected cells. It also lets you choose notifications settings: get notified every time you make a change made, every time any user makes a change, or never. When you click it, you can enter in the email addresses of everyone you want to receive the Sheet. Start typing the name of someone in your Google Contacts, and Sheets will recognize and autofill it.
You can also lock down more permissions in Advanced Settings. This is your workspace. It functions very similarly to Excel, with columns A-Z and beyond, and rows 1-any number you like. Each cross-section is a cell with a unique address, like A1 highlighted here. This is important for formulas. Use these tabs to access the multiple sheets in one Google Sheets document.
Hovering over this icon surfaces Explore. Clicking on this brings up a righthand pane that generates unique information about any selected group of cells, charts, or tables. This section will cover where to find all the spreadsheet tools in Google Sheets. These are some basic functions, including the print tool, undo and redo, and the format paintbrush.
Click the drop down to see more currency, date and time formats, and other options hidden in another menu.
0コメント