Click and drag with the black cross cursor so that D and E are selected before letting go. On the top right corner of column C, if you hover your mouse it should turn into a black cross. Then select BOTH C and B by holding down the shift key while clicking on the C and B columns. Then click anywhere to stop the selection of all cells.ĭon't ask questions yet and just do this for now (I'll explain later): select the entire column C by click the C at the top of the column before right clicking to set the width to 2". 0.5" looks good to me change as you like. The cells are smaller than I'd like, so to change this I right click the rows on the far left and go down to "row height". To do so, click "wrap text" (second image). Click the arrow in the top left corner of the grid (see first picture) to select all cells, or press ctrl/command + a.įor the formatting, I like to make all cells' text wrap to another line if it's longer than the cell's width. To pre-format all your cells, you'll first need to select all of them. NOW let's finally move onto the expense tracker, shall we? There are others, of course, but these are the ones I see as most useful. ctrl/command + h = hides window from screen (doing illegal business, eh?).ctrl/command + f = find specific cells with keywords.ctrl/command + y = redo the previous command. ctrl/command + z = undo the previous command.ctrl/command + x = cuts the cells you've selected.ctrl/command + c = copies the cells you've selected.ctrl/command + p = open print dialogue window.ctrl/command + n = opens a new blank workbook.(fifth picture)Īdditionally, you may find some keyboard shortcuts handy: Note: Excel is great in that it provides a small box to guide you on how to fill out the formula (the syntax of cell that go into the parentheses).COUNTIF() counts up cells that meet a certain criteria.AVERAGE() averages the cells you selected in the parentheses.SUM() sums up the cells you select in the parentheses.Here are two links: one and two, but the ones I use the most are: There are specific specialized ones for engineering or accounting too. Excel functions: Excel has some built-in functions that automatically sum, count, etc.(any additional number of letter between a and b) of selected cells by clicking on the small box at the bottom of the workbook close to the middle. Easily find out the sum, counts, mean, max, etc.Use a colon to select a range of cells.Minor trick = to stop the shimmering around a selected cell, press esc (selection is still loaded).Track changes in your document (very useful if you shared it with someone else for editing) going to tools > track changes > highlight changes (can reject or accept them too).If I leave out the dollar sign, it'll do B1 - A1, B2 - A2, etc. For example, I want to subtract cell A2 from a whole column so I type " = B1 - $A$2 " into B1 and drag the lower right corner to do that for the column of B. If you don't want a particular cell to change as you autofill, add a dollar sign in front of its coordinates.1 in one cell, 2 in adjacent cell on the right or below) and dragging the bottom right corner once you see the black cross icon for your mouse (see second picture). Autofill cells by typing out enough to define a pattern (eg.This gives you better control, such as only the formatting or the plain text rather than the function.(see first picture) Go to edit (on the top menu bar) > paste special (or right click for this option) to customize what you want to paste.Pressing shift + an arrow key (up/down/left/right) will advance your selection be as many cells as you press for the arrow key (press up twice to select two more cells up, etc.). I've also compiled a short list of little tips and keyboard shortcuts for ease of use: Side notes: votes in contests would be very much appreciated if you like this tutorial. Even if you're an excel wizard, perhaps you'll still find step 10 helpful (I'm fairly proud of the notes I took while I read up on how to use Excel.). But learning how to make and maintain spreadsheets is a valuable skill that can save you time, paper, and brain power (Banking check books work fine, sure, but online copies are quite convenient once you get the hang of it!). I'll essentially be going over basic Microsoft Excel functions and tips as this tutorial progresses, so no need to worry if you've barely opened a spreadsheet before. Even my brother has asked me to send him a template, so I thought this tutorial might come in handy for others too. I've been updating a custom Microsoft Excel (the spreadsheet program of the Microsoft suite) spreadsheet for this purpose, and one day a friend saw it and asked me to teach her how to make something similar. I like to record my monthly spending patterns to get a good feel for how much I'm spending in certain categories, whether I'm going in monthly deficits, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |