How to Convert Integers to Minutes Seconds in Excel

1. Double-click the Microsoft Excel 2010 icon on your computer's desktop with the left mouse button. This will open the program and display a blank spreadsheet.
2. Double-click a cell on the blank spreadsheet that appears after the program opens with the left mouse button. This will place the text cursor into the cell and allow you to enter data.
3. Press the '=' key on your keyboard. This informs Microsoft Excel 2010 that you would like to create an equation in that cell rather than simply display text.
4. Enter the integer you wish to convert to a minutes-and-seconds format using your keyboard.
5. Press the '/' key on your keyboard. This represents the division mathematical function.
6. Type '86400' using your keyboard. This represents the number of seconds in a day.
7. Press the 'Enter' key on your keyboard. This will calculate the equation and convert your integer into a decimal number.
8. Right-click the decimal number calculated in step seven with the right mouse button. This will automatically open a pop-up menu.
9. Single-click the 'Format Cells...' option from the pop-up menu to open the 'Format Cells' screen.
10. Single-click the 'Custom' option listed in the 'Category:' section on the left side of the 'Format Cells' screen with your left mouse button. This will automatically cause the 'Type:' section to appear.
11. Single-click the 'mm:ss' option listed in the 'Type:' section with your left mouse button. This option represents a format of minutes, followed by a colon, then seconds.
12. Single-click the 'Ok' button on the lower-right side of the 'Format Cells' screen. This will close the 'Format Cells' screen and automatically return you to your spreadsheet. The cell you entered data into will now display your integer in a minutes-and-seconds format.

Read more ►

How to Add Percentages to a Chart in Excel

1. Open the Excel 2010 spreadsheet where your chart is located.
2. Click on the first cell in the empty column -- or row if your data is arranged by rows -- next to the data table that makes up your chart. Type in the name of the column or row that you want to display as percentages in your chart, followed by the word 'percentage' or simply the '%' sign.
3. Enter the following formula into the cell just below, or to the right of, your header cell:=A2/sum(A:A)Change 'A2' to the first cell in the column or row that contains the data series you want to display as percentages. Change 'A:A' to the column letter or row number of the column or row where the targeted data series is located. Press 'Enter' to complete the formula.
4. Move your mouse over the fill handle in the lower right corner of the cell with your formula in it. Click and hold the mouse button, then drag your mouse toward the end of your data table. When you reach a cell that is level with the last cell in your data table, release the mouse button. Excel fills the entire row or column with your formula.
5. Click on the column letter or row number where your formulas are located. Click the 'Home' tab, then click the drop-down arrow in the 'Number' area of the ribbon. Choose 'Percentage' from the drop-down menu. The numbers in that column or row all turn into percentages.
6. Click on the data series on your chart where you want to add your percentages, then click the 'Layout' tab at the top of the screen, followed by the 'Data Labels' button in the Labels area of the ribbon. Choose one of the four data label options available in the drop-down menu.
7. Click on the data label attached to the first data point in your chart, then click it again to edit the label. Place your cursor into the formula bar at the top of the spreadsheet. Type in a '=' sign into the formula bar, then click on the cell from the series of percentages that you created which contains the percentage for the selected data point.
8. Press 'Enter.' The percentage appears on your chart. Repeat this process for every data label on your chart.

Read more ►

How to Use Excel's SUBTOTAL Function

1. Learn the syntax for SUBTOTAL. It is SUBTOTAL(function_number, reference_1, reference_2,...reference_i...,reference_n) where function_number is the number corresponding to the function to use for calculating the subtotal and reference_i are up to 29 references for which the subtotal will be calculated.
2. Examine the following function numbers and their corresponding functions: 1, AVERAGE; 2, COUNT; 3, COUNTA; 4, MAX; 5, MIN; 6, PRODUCT; 7, STDEV; 8, STDEVP; 9, SUM; 10, VAR; and 11, VARP. Note that these function numbers will include hidden values. Add 100 to these function numbers if you want the function to ignore hidden values.
3. Expect nested subtotals within the references to be ignored by the SUBTOTAL function to avoid counting them twice. Rows that are not included in a filter's result also will be ignored. SUBTOTAL will return the #VALUE! error value when any reference is a 3-D reference.
4. Enter the following values into the first column of an Excel spreadsheet:Row 1: Data;
Row 2: 110;
Row 3: 15;
Row 4: 165.
5. Look at some examples of SUBTOTAL based on the entries made in Step 4: =SUBTOTAL(9,A2:A4) will evaluate as SUM(110,15,165) or 290 because function 9 is the SUM function; =SUBTOTAL(1,A2:A4) will evaluate as AVERAGE(110,15,165) or about 96.67 because function 1 is the AVERAGE function.

Read more ►

How to Format Numbers in a Concatenate Function in Excel 2007

1. Click the cell in which you want to insert the concatenate function.
2. Type the function in this format:CONCATENATE('This is the contents of cell A1: ', A1, '. And this is the contents of cell B2: ', B2, '.')Anything you put in quotes, including numbers, will be reproduced as you wrote it. Outside of quotes, strings (like A1 above) will be interpreted as cell numbers, and the concatenate function will fill in the contents of that cell. For example, if cell A1 contains the number '123,' and B2 the number '456,' the above function would produce:This is the contents of cell A1: 123. And this is the contents of cell B2: 456.Remember, if you want to use fixed numbers in a concatenate function, enclose them in quotes.
3. Press 'Enter' to complete the addition of the function.

Read more ►

How to Define Cell Names in Excel 2003

1. Go to the Start menu and open Excel.
2. Decide which cells you would like to define. You can do this by highlighting them with your mouse. If you want to define multiple cells that are not next to each other, click on each of them and hold down the 'Ctrl' button.
3. Click on the name box, which is is directly above the 'A1' cell. Once you click on the cell, it will be ready for you to type the new name.
4. Type the new name for the cell(s). For example, if you are making a budget and you want to name the cells accordingly, you might name them 'debit' or 'bill.'
5. Press 'Enter' to save the name into the name box. If you forget to do this, your name will be lost.
6. Use the names to make your formulas simpler. Now you can use 'debit' as a part of your next formula. This simplifies everything.
7. Visit the Help section of Microsoft.com for more information on how to make formulas. There are a few things that you need to know to make your formulas work properly.

Read more ►

How to Replace All Occurrences of a Word in a Microsoft Word Document

1. Scan your document until you find an occurrence of the word that you want to replace.
2. Click your mouse to highlight the word.
3. Click the 'Home' tab at the top of the window.
4. Click 'Replace' in the 'Editing' section of the Ribbon at the top of the window.
5. Click inside the 'Replace With' field at the bottom of the window.
6. Type the word that you want to use as the replacement word, then click 'Replace All.'

Read more ►

How to Insert Page Breaks in Microsoft Excel 2003

1. Select the area where you wish to insert page breaks. To do this you will need to left-click on the area of the spreadsheet where you would like to insert a page break.
2. Insert the desired page break. Scroll to the “Insert” tab on the command bar and select “Page Break” to insert a page break.
3. Check “Print Preview” to see and edit page breaks. Scroll the “File” tab on the command bar and select “Print Preview” which will show you where your page breaks occur and how they will affect the printed spreadsheet. To see page breaks, left-click on the “Page Breaks Preview” and it will show you where your page breaks are.
4. Adjust page breaks as necessary. You can adjust the page breaks in the page breaks print preview menu simply by left-clicking on the corners and holding while dragging the page breaks where desired.

Read more ►

How to Add Chart Legends in Excel 2010

1. Double-click the Excel 2010 file that you want to work with to open up the spreadsheet.
2. Click anywhere on the chart to select it. Then click the “Layout” tab at the top of the screen.
3. Click the “Legend” button, which is located in the Labels area of the ribbon. Choose one of the four direction buttons to place the legend above, to the right, to the left or below the chart. Alternatively, click either of the “Overlay” buttons to place the legend at the right or left side of the chart, overlapping the chart itself.
4. Right-click the legend on the chart, and choose “Format Legend” from the pop-up menu. The Format Legend window will appear.
5. Select any of the options on the left side of the window other than “Legend Options” to adjust how the legend will appear on your chart. These settings will let you add a filled-in background, adjust the border color or style, add a shadow element and adjust the edges of the legend. Click “Close” when you are done adjusting the legend’s appearance.

Read more ►

How to Make a Grid in Excel

1. Decide on the size of each cell, and how many rows and columns to use. This example creates a grid of cells that is nine rows long and seven columns wide with cells measuring 1-inch square.
2.
Click on cell A1 in the upper left and while holding the left mouse button, drag the selection to cell G9 in the lower right.
3. From the 'Format' menu, choose 'Row,' then 'Height' to display the 'Row Height' dialog box. Excel measures the row height in points, with roughly 72 points per inch. Enter a row height of 72, then click 'OK' to close the dialog.
4. From the 'Format' menu, choose 'Column,' then 'Width' to display the 'Row Width' dialog box. Excel measures the column width in the number of standard characters that fit into the width, with roughly 13 characters per inch. Enter a row width of 13, then click 'OK' to close the dialog.
5.
If the grid is too big to fit on one page, reduce the cell dimensions or adjust the page numbers by choosing the 'File' menu, then 'Page Setup.' In this case, the left and right margins of the page are reduced to 0.5 inches each.
6. With the cells still selected, choose the 'Format' menu, then 'Cells' to display the 'Format Cells' dialog box.
7.
Click the 'Borders' tab.
8. Click on a 'Style' in the right 'Lines' box to define the border appearance.
9.
In the left 'Presets' box, click the 'Outline' and 'Inside' buttons to draw borders on the grid.
10. Save or print the grid as needed.
11.

Read more ►

How to Convert XPS Files

1. Download and install an XPS file converter. You can download such a program from sites like 'Verydoc.com/', 'NovaPDF.com' and 'OpenXML.biz/XPSconvert.html'.
2. Launch the XPS converter program. Most likely, there will be a new desktop icon for the program. If not, you can find it under 'Start,' 'All Programs'.
3. Click and drag the XPS file into the main viewing area of the converter program.
4. Select an output location. Depending on the program you are using, there most likely is a browse button that allows you to select any location on your computer as a save location.
5. Select an output format, if you are given the option. Most XPS file converters simply convert the file into a PDF. Click 'OK' and the file is converted to the desired file format.

Read more ►

How to Learn Excel VBA Online

1. Learn Excel VBA. Look for nonmacro solutions before you start messing with VBA. If you don't know Excel's capabilities well, you're likely to write macros that do things you could accomplish instead with good spreadsheet design and a few mouse clicks.
2. Navigate to Microsoft's VBA for Excel 2003 training page. There is no equivalent page for Excel 2007, but you won't need version-specific knowledge until you've mastered the fundamentals of VBA.
3. Watch the introductory videos and work through the textual tutorials that introduce programming with VBA. There are three courses. Complete them, do the practice sessions and take the tests.
4. Complete the VBA tutorials at xlpert.com and xl-vba.com. Xlpert offers a free eight-lesson course, while xl-vba's course has 23 lessons. The writing doesn't sparkle and there's a lot missing (to encourage you to buy a complete course), but the material will reinforce what you learned from Microsoft's site. Repetition is useful when learning a new language.
5. Build a spreadsheet that does something useful for you, then turn it into a macro-driven application. When you feel stymied--and you will from time to time--press the F1 key to activate Excel VBA's help system. You can learn VBA entirely from the help system, but it would be very hard if you're not already a programmer.
6. Visit Microsoft's developers' forums to research problems and ask questions of other programmers. A link below leads to the forums page where you'll find a list of several Excel-related discussion groups.

Read more ►

How to Define a Table in Excel 2007

1. Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
2. Click on the 'Insert' tab at the top of the document.
3. Find the 'Tables' group, then click on 'Table.' The 'Create Table' dialog box will appear.
4. Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
5. Check the 'My Table Has Headers' box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
6. Hit the 'OK' button at the bottom of the Create Table dialog box to create your table.

Read more ►

How to Calculate Population Standard Deviation Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 15.4,13.2,11.1,12.5,11.3 and 13 in A2, A3, A4, A5, A6 and A7.
2. Click on the 'A9' cell for this example. This is the cell where you will calculate the standard deviation. When you calculate another standard deviation, choose any cell at the bottom of the list of numbers you are using.
3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.
4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
5. Click on the drop-down menu of 'Or select a category.'
6. Scroll down the 'Select a function' window. Choose 'STDEV,' which is the function of standard deviation based on the sample.
7. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A7 is populated. If A2:A7 is not populated, enter A2:A7 manually. Click 'OK.'
8. The standard deviation has been successfully calculated in the 'A9' cell. In this example, the calculated value of the standard deviation is 1.560449.

Read more ►

How to Insert a Checkbox in Excel 2007

1. Click on the 'Developer' tab.
2. Click 'Insert' then 'Check Box' under 'Form Controls.'
3. Click where you want the check box to appear on the spreadsheet.
4. Click 'Properties' on the 'Developer' tab. Edit the properties you want to have on your check box.

Read more ►

How to Select Multiple Entries From the List in Excel 2003

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' in the list of programs, then click 'Microsoft Excel' to open the software.
2. Click the 'File' ribbon tab at the top of the Excel software. Click 'Open' to view the 'Open' dialog window. Double-click the Excel file you want to use.
3. Click the first cell you want to select. Hold the 'Ctrl' key and use the mouse to click each cell you want to select.
4. Right-click one of the selected cells and select 'Copy.' The cells' contents copy to the Windows clipboard. You can now move the content to a new program window or copy the cells to a new spreadsheet.

Read more ►