Microsoft Excel. You can customize your check register to categorize expenses so you can keep track of where your money goes. Create a formula that keeps a running balance of how much money is in your account. Columns run vertically and are ordered by letter. Each box where a row and column intersect is called a cell. The cell is named according to its row and column. To do this, a cell in the fifth row of column D is named D5 (column D, row 5).Understand the difference between a worksheet and a workbook in Excel. A worksheet is a single spreadsheet. A workbook is an Excel file that contains one or more spreadsheets. Then click on the Microsoft Excel tile to open Excel. You will see a page with your recent files listed on the left and template options for new documents on the right. For example, first you select the range of cells that you want to format. Hover the cursor over the border between columns D and E. The cursor will change from the arrow to the resizing cursor. In the upper left hand side of the toolbar on the “HOME” ribbon, click on the “center” formatting button. This action centers all of the data in the selected cells. You will notice that the column labels are now centered in their cells.
