Label Data1. Type 'Fixed Costs' into cell A1.2. Type 'Unit Expense' into cell A2.3. Type 'Unit Revenue' into cell A3.4. Type 'Units' into cell C1.5. Type 'Revenue' into cell D1.6. Type 'Expense' into cell E1.Input Data7. Input your fixed costs of a production into cell B1. For example, if rent for the factory is $25 per month, then type '25.'8. Input the cost of each unit you produce into cell B2. For example, if each widget costs you $5 to manufacture, type '5.'9. Input the revenue you make for selling each unit into cell B3. For example, if each widget sells for $10, type '10.'10....
Browse » Home » All posts
Wednesday, March 14, 2012
How to Extract Data Onto a Table Using Excel 2007
Create a Table1. Open the spreadsheet and highlight the data you want to put into a table.2. On the 'Insert' tab, click 'Table.' If you want to include the headers in your data, choose the box next to 'My Table Has Headers.' Click 'OK.'3. Your data will appear as a table. If you've excluded any data, it will still appear. If this isn't what you had in mind, try creating the table again, this time including all your data. Then, when your table is created, choose in the next step to exclude and hide any additional data.4. Format the table by using the drop-down boxes that appear next to...
How to Change the Color of a Cursor in Excel
1. Click the 'Start' button in Microsoft Windows.2. Click 'Control Panel.'3. Click the 'Ease of Access' category.4. Click 'Ease of Access Center.'5. Click the 'Make the Mouse Easier to Use' link under 'Explore All Settings.'6. Select the color scheme you want to use for the mouse cursor. Choose from a selection of white, black or inverting, in different sizes.7. Click 'Apply.' Click 'OK.'8. Open Microsoft Exc...
Tuesday, March 13, 2012
How to Make Excel Calculate Division With Remainders
1. Launch Microsoft Excel and open a new, blank worksheet.2. Enter the top number of a fraction or the number to the left of the division sign (the dividend) into cell A1. For the division problem '9/4,' type '9' (no quotes) and press 'Enter.'3. Enter the bottom number of a fraction or the number to the right of the division sign (the divisor) into cell B1. If you are solving '9/4,' type '4' (no quotes) and press 'Enter.'4. Use the Quotient function to find the integer portion of the result. Type the following into cell C1:=QUOTIENT(A1,B1)Press 'Enter.' For the problem '9/4,' you see a...
How to Compare Two Excel Spreadsheets
1. Open Excel and use 'File,' and then 'Open' to open the first file to use for comparison.2. While the first document is still open, use 'File,' and then 'Open' to open the second file.3. Select the 'View' tab, and then select 'New Window.'4. Select 'View Side by Sid...
How to Make a Timeline in Excel
1. Plan your timeline ahead of time. Sketch it out on a piece of paper so you can refer to it as you design the timeline in Excel.2. Open a new worksheet in Excel.3. Go to 'File' then 'Page Setup' and change the page orientation to landscape. This will turn your worksheet horizontal.4. Drag your cursor from the first cell to the length you expect your timeline to take up. Click 'Format,' 'Cells,' 'Alignment' and then check the box next to 'Merge Cells' and click 'OK.'5. Place your cursor in the merged cell you just created and type the title of your timeline. Click the center alignment...
Monday, March 12, 2012
How to Use a Subroutine in Excel Visual Basic
1. Open the Visual Basic Editor. In Excel 2003, from the menu, select 'View,' 'Toolbars,' 'Visual Basic.' From the new toolbar, click the Visual Basic Editor icon. In Excel 2007, on the Developer tab, in the Code group, click 'Visual Basic.'2. Insert a new module. From the menu, click 'Insert,' 'Module.' You will see the new module listed in the Project Explorer with the name 'Module1.'3. Insert a new procedure. From the menu, click 'Insert,' 'Procedure.'4. In the 'Add Procedure' pop-up box, type a name for your new subroutine. Use underscores, rather than spaces, to separate words.5....
How to Use the Excel Monthly Household Budget Template
1. Open Excel. If you are using Excel 2007, click the 'Office Button' and then click 'New.' In Excel 2003, click 'File' and then 'New.' Type 'Family Monthly Budget' in the 'Search Online For' box and click 'Go.'2. Click 'Family Monthly Budget Planner' to select that template. Click the 'Download' button. The template will open as a new Excel worksheet.3. Start in the 'Projected Cost' column. Type in what you expect the costs to be for each item listed that month. You can round off your costs to whole numbers, or put in exact numbers and the template will round them off for you. If you are...
How to Darken the Selection in Microsoft Excel
1. Select the column or columns of data with your mouse. If you want to select all of the columns, position your mouse on top of the first column letter (usually column A), click, and drag it across to the last column. This will select everything in your spreadsheet.2. Click the 'Home' tab and select the 'Cell Styles' option. You will see a listing of various cell themes.3. Choose one of the cell themes that are listed at 20 percent opacity from the list of cell style options. From now on, when you select the cells in your worksheet, the selection box will be darker and easier to distinguish....
How to Merge Excel Spreadsheets to Find Duplicates
Complete the Merge1. Identify the duplicate values you are searching for. Identify the data type and make sure it is the same in both spreadsheets. For example, if you would like to identify duplicate dates, make sure the dates are recorded in the same format (9/12/2034) across spreadsheets.2. Confirm the spreadsheets have the same number of columns. To merge spreadsheets, make sure they have the same number of columns. If not, make sure the column headers match until it no longer matters. For example, if spreadsheet A has four columns and spreadsheet B has six columns, make sure the first...
How to Open Excel 2007 Files With Office 2003
1. Visit Microsoft's online Download Center. Search for 'Microsoft Office Compatibility Pack for Word.'2. Click on the 'Microsoft Office Compatibility Pack for Word, Excel and PowerPoint File Formats' link.3. Click on the 'Download' link. Click on 'Save' to save the file to your computer.4. Click on the downloaded FileFormatConverters.exe file. It should be located in the downloads file on your computer.5. Click on 'Run' to start the installation process. Once the installation is complete, you will be able to open and edit files made in Excel 2007 in your Office 2003 suite of applic...
How to Enter a Series of Dates in an Excel 2007 Spreadsheet
1. Open the worksheet.2. Click on a cell that will contain the first date. Enter this date. For example, 5/12/11.3. Point on this selected cell's lower right corner. A black ' ' symbol will appear over the tiny square in this corner. This symbol is the fill handle.4. Drag the fill handle across the adjacent cells to fill them with the sequence of dat...
Sunday, March 11, 2012
How to Use Excel to Subtract From the Total
1. Open the document you would like to make the changes to in Microsoft Excel.2. Locate the cell that contains the total and make note of the cell number --- for example, 'E2' or 'F15.'3. Select the empty cell in which you would like to have the subtracted result shown.4. Type '=X - Y' where X is the number of the cell containing the total and Y is the number or cell you would to subtract from the total.5. Press 'Enter' and the cell will now show the subtracted tot...
How to Make the Cursor Stop Highlighting
1. Launch the Microsoft Excel project in which you wish to stop the cursor highlighting.2. Select a single cell with your cursor. The cursor highlights a range of cells only if extended-selection mode is turned on.3. Turn extended-selection mode off by pressing the 'F8' key.4. Select a single cell with your cursor. The cursor will highlight only the individual cell. Extended-selection mode has been turned off.5. Restart your system if the problem persis...
How to Combine Worksheets Inside an Excel Spreadsheet
1. In Excel 2007, click on the 'Data' tab and choose 'Consolidate' from the Data Tools group. For earlier versions of Excel (97-2003), click on 'Data->Consolidate.'2. Define the reference ranges using the Reference box. Specify the first range you want to consolidate.3. Click 'Add.' The reference you defined in Step 2 will appear in All References.4. Repeat Steps 2 and 3 until you have defined everything you want to consolidate. Then click 'O...
Subscribe to:
Posts (Atom)