Article: 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. Excel has been in existence for many years, and every year or so, Microsoft releases a new, updated version. Each of these versions also works a little bit differently. In Excel, rows run horizontally and are ordered by number. 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). 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. 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. 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. On a PC with Windows 7 or newer, click on the Windows icon in the lower left hand corner of your screen. 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." This will bring you to a new, blank spreadsheet. 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. Enter the word "DATE" in cell B1 (column B, row 1). 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 D1 (column D, row 1). Type "PAYEE." This is the person to whom a check was made payable or to whom money was paid. Move one cell to the right to cell E1 (column E, row 1). Type "DESCRIPTION." Record any details you want to remember about the transaction. Move one cell to the right to cell F1 (column F, row 1). Type "DEBIT." This is where you record money that leaves your account, also known as outflow. Move one cell to the right to cell G1 (column G, row 1). Type "EXPENSE CATEGORY." You will leave this blank for now. Options for this column will be created in a later step. Move one cell to the right to cell H1 (column H, row 1). Type "CREDIT." This is where you record money coming into your account, also known as inflow. Move one cell to the right to cell J1 (column J, row 1). Type "INCOME CATEGORY." As with the expense category column, options for this column will be created in a later step. Move one cell to the right to cell K1 (column K, row 1). Type "BALANCE." This is the current amount in your account after all transactions have been recorded. 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. Find the formatting options in the "HOME" tab of the toolbar ribbon. When you open a new workbook, the "HOME" tab is open by default. Select cell B1 (DATE) and drag the cursor across all of the labels, through cell K1 (BALANCE). 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. The default size of some of the columns will likely be too small to hold the data you will put in them. For example, the "PAYEE" and "DESCRIPTION" columns could hold long names or lengthy memos. Also, column A, which has no data and is just a spacer, should be very narrow. Click the header for column A to select the whole column. In the upper right hand corner of the toolbar in the "HOME" ribbon, click on the "FORMAT" button. From the drop down menu, click on "Column Width." Enter the number 2 and click on "OK." Now column A is very narrow. Widen column D, "PAYEE." Select column D by clicking on the header. 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. Repeat the same procedure to widen column E, "DESCRIPTION." 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.
Question: What is a summary of what this article is about?
Get familiar with Excel. Open a blank Excel spreadsheet. Create column labels. Format column labels. Resize some of the columns. Center the register labels.
Article: It will be highlighted in yellow to indicate that it is selected. It's the icon that resembles a speedometer above the previewer. ". It's above the previewer at the top. These buttons are located next to the pulldown menu above the previewer. This will determine how much you speed up the audio by. This will prevent the pitch from raising as the audio speeds up.
Question: What is a summary of what this article is about?
Click an audio clip in the timeline. Click the "speed" icon. Click the pulldown next to "Speed: Click Fast in the pulldown menu. Click 2x, 4x, 8x, or 20x. Click the checkbox next to "Preserve Pitch" (optional).