Microsoft excel 2016 book amazon free.Buy for others
Looking for:
- : Microsoft Excel Step by Step eBook : Frye, Curtis: Kindle Store |
Microsoft excel 2016 book amazon free.Microsoft Excel Data Analysis and Business Modeling, 5th Edition
Microsoft excel 2016 book amazon free
Last Updated: July 28, References Approved. There are 8 references cited in this article, which can be found at the bottom of the page. This article has been viewed , times. It's convenient to record your checking account activity with an electronic check register you create using Microsoft Excel. You can customize your check register to categorize expenses so you can keep track of where your money goes, and create a formula that keeps a running balance of how much money is in your account.
Not only is this a useful project, but it is also simple enough that beginners can use it to learn some basics of how to use Excel. To create a simple checkbook register with Microsoft Excel, open a blank spreadsheet and create column labels that would be in a paper register, like Date, Check Number, and Payee.
Then, format the column headings so that they are bold and easy to read, and adjust the cell formatting to account for currency and dates. Next, create a formula in the Balance column to subtract a debit or add a credit from the opening balance. Then, copy that formula into each cell in that column to keep a running balance. To learn more from our Accountant co-author, like how to password-protect your register, keep reading the article! Did this summary help you? Yes No. Log in Social login does not work in incognito and private browsers.
Please log in with your username or email to continue. No account yet? Create an account. Popular Categories. Arts and Entertainment Artwork Books Movies. Relationships Dating Love Relationship Issues. Hobbies and Crafts Crafts Drawing Games. All Categories. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy.
Cookie Settings. Learn why people trust wikiHow. Part 1. Get familiar with Excel. Excel is a spreadsheet software program that allows users to manage data and perform calculations with formulas. Excel spreadsheets are organized by rows and columns. You can install a desktop version of Excel on your Mac or PC.
Or, you can use a free online app for your smartphone, tablet or computer. Each of these versions functions a little bit differently. Each of these versions also works a little bit differently. 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. For example, a cell in the fifth row of column D is named D5 column D, row 5. A worksheet is a single spreadsheet.
A workbook is an Excel file that contains one or more spreadsheets. Each worksheet in an Excel workbook is in a separate tab. By default, new Excel workbooks have three tabs.
You can add more if needed. To make a basic check register, you only use one tab. To create a function for categorizing expenses in a check register, you will use two tabs. Open a blank Excel spreadsheet. How you open the spreadsheet differs depending on the type of computer and operating system you are using.
On a PC with an operating system older than Windows 7, begin by clicking on the start menu in the lower left hand corner of your desktop. From the popup menu, click on Programs. From the next popup menu, click on Microsoft Office. Then click on Microsoft Office Excel. At this point you will have a blank excel spreadsheet on your desktop. 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. Click on the first template option, Blank Workbook, to open a new Excel spreadsheet.
To open Excel on a Mac, click on Excel in the dock. Click "File" in the menu bar. Click "Open" and then click "New. Create column labels. Use labels that you would find in an ordinary paper check book register. Create columns for the date, check number, the payee and a description or memo. After that, create columns for debits which are payments or withdrawals , credits which are deposits and the balance forward.
This is where you will enter the date of the transaction. Move one cell to the right to cell C1 column C, row 1. Type "ITEM ". Here you will enter the check number or the type of transaction, such as "ATM" or "deposit.
Move one cell to the right to cell E1 column E, row 1. Move one cell to the right to cell F1 column F, row 1. Move one cell to the right to cell G1 column G, row 1. Options for this column will be created in a later step.
Move one cell to the right to cell H1 column H, row 1. Move one cell to the right to cell J1 column J, row 1. Move one cell to the right to cell K1 column K, row 1. Format column labels. To make the column labels easy to read, format them so they are in bold font and give the row of register labels a different background color. To do this, first you select the range of cells that you want to format. Then you select the formatting options. When you open a new workbook, the "HOME" tab is open by default.
In the upper left hand corner of the toolbar, click on the "B" for the bold formatting option. To change the color of the background, click on the paint bucket icon to see the palette from which you can select your background color. Resize some of the columns. The default size of some of the columns will likely be too small to hold the data you will put in them. Also, column A, which has no data and is just a spacer, should be very narrow.
From the drop down menu, click on "Column Width. Hover the cursor over the border between columns D and E. The cursor will change from the arrow to the resizing cursor. The resizing cursor looks like a cross with arrows. When you see the resizing cursor, left-click and drag your mouse to the right to make the column as wide as you want it to be. Center the register labels. Select the entire first row by left-clicking on the number 1 on the left border of the page.
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. Part 2. Input some test data.
In order to see the formatting changes you make, enter four rows of data into the cells. Begin with the opening balance, and then enter three more transactions.
Add three more transactions.
Comments
Post a Comment