![]() 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |