Sunday, August 28, 2011

How to Plot a Time vs. Growth Graph in Excel 2007

1. Open Microsoft Excel 2007.2. Place all the 'Time' values in one column, for example, column A. Place all the 'Growth' values in an adjacent column, column B. The 'Time' values become the x-axis values while the 'Growth' values are the y-axis values.3. Click the first cell included then drag your mouse towards the last included cell to select the range of values to be included.4. Click the 'Insert' tab from the menu bar. Go to the 'Charts' menu and click 'Scatter.'5. Click 'Chart Area' to display the 'Chart Tools,' 'Design,' 'Layout' and 'Format' tabs.6. Go to the 'Design' tab and...
Read more ►

Saturday, August 27, 2011

How to Put Bullets in an Excel Spreadsheet

1. Open the Excel 2010 spreadsheet in which you want to add bullets.2. Click on the cell where you want to add bullets. If there is already text in the cell, you will need to click on the formula bar above the spreadsheet. Place your cursor where you want the first bullet to go.3. Hold down the 'Alt' button and press '7' on the numeric keypad. This will not work with the numbers above the keypad, so if you have a laptop without a dedicated numeric keypad, you will need to hold down the 'Function' button as well and type the letter that has 7 as an alternate. The bullet point appears.4. ...
Read more ►

How to Hide Column Letters Numbers in Excel

1. Open your document in Microsoft Excel.2. Click the 'View' tab on the Office ribbon.3. Uncheck the 'Headings' check box to hide the column and row headin...
Read more ►

How to Create a Time Chart

1. Double-click on the Excel 2010 icon to open up the program. The program will start with a new spreadsheet.2. Click on cell A1 and enter the column header for the time column. This will generally be 'Year,' 'Month,' 'Day' or simply 'Time,' although you can make the header anything you want. Then click on cell B1 and enter the header for your data column.3. Enter your time information into column A, starting at cell A2. Then enter the data you are tracking into column B, starting at cell B2.4. Click on cell A1 and hold the mouse button as you drag the mouse to the last entery in column...
Read more ►

Thursday, August 25, 2011

How to Create a Macro in Excel 2010

1. Identify a complex series of commands you frequently give Microsoft Excel. For example, you could create a macro for formatting a group of cells with 8-point, blue Times New Roman font.2. Choose the 'File' tab. Click 'Options' and 'Customize Ribbon.' Select the 'Developer' check box in the 'Main Tabs' list to easily access the macro creation tool.3. Click 'Macro Security' on the 'Developer' tab. Enable macros under the 'Macro Settings' area.4. Click 'Record Macro' to open a window and create a new macro in Excel.5. Enter a unique name for your macro. Choose a name that begins with...
Read more ►

How to Create a Budget in Excel

1. Go online to the official download website for Microsoft Office.2. Scroll down the page to the 'Browse Templates' section. Click 'Budgets.'3. On the left column of the site, navigate to the 'Filter by Product' section. Select 'Excel' from the drop-down menu.4. Browse the available budget templates. Choose a template with a layout and design that suits your budgeting needs.5. Click the link for your selected budget template and click the 'Download' button. Once you accept the Microsoft Service Agreement, your template will begin downloading.6. Open your downloaded template in Microsoft...
Read more ►

How to Create a Spreadsheet on Microsoft Excel

Using Microsoft Excel 2003 or earlier1. Open Microsoft Excel.2. Click 'File' in the top menu bar and select 'New.'3. Select the 'General' tab and double-click the 'Workbook' item to create a blank spreadsheet. Alternately, select the 'Spreadsheet Solutions' tab to view the program's default templates. Create a new spreadsheet based on a template by double-clicking its icon.4. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.5....
Read more ►

How to Make a 3x5 Note Card on Excel

1. Click 'Start,' and then click 'Programs.' Click 'Microsoft Excel 2010.'2. Click 'Page Layout,' and then click 'Page Setup.'3. Click Size,' and then click 'Custom.'4. Specify the width to be '3' inches and the height to be '5' inches. Click 'O...
Read more ►

How to Delete Multiple cells in Microsoft Excel 2003

1. Decide on the cells that you wish to delete. Make sure that you know what cells you want to delete and where they are located in the spreadsheet.2. Highlight the multiple cells. To highlight the cells that you wish to delete, left-click and hold on the first cell and then drag the mouse cursor over the additional cells to highlight them.3. Access the cell sub-menu. Once you have highlighted the multiple cells that you wish to delete, right-click to access the cell sub-menu.4. Delete the highlighted cells. Scroll to “Delete” and left-click in the cell sub-menu, which will bring up a...
Read more ►

Wednesday, August 24, 2011

How to Password

1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.2. Select the worksheet where the password protection will be applied. Click the 'Review' tab and select 'Protect Sheet.' The Protect Sheet dialog box appears.3. Type the password in the provided 'Password' field. Click 'Ok.' When prompted to confirm the password, retype the password. Click 'Ok.' Notice the ribbon has grayed out areas. These areas will not be accessible unless the user knows the passwo...
Read more ►

How to Check If a Cell Is Empty in Excel Program?

ISBLANK Function1. Open the Excel worksheet with the data you want to check.2. Enter an appropriate header in the first empty column.3. Input '=isblank(B2)' on the row corresponding to the first data you want to check and press 'Enter.' This formula says, 'Cell B2 is empty.' If that statement is true, it returns a value of 'TRUE.' Otherwise, it returns a value of 'FALSE.'4. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.5. Select the 'Data' tab on the menu and select the 'Filter' button.6. Click the filter...
Read more ►

How to Protect Cells in Excel 2003

1. Open Excel on your computer and select the spreadsheet that you want to protect.2. Click the 'Select All' icon in the upper-left corner of the spreadsheet. The icon is a gray rectangle located adjacent to the A1 cell.3. Select 'Cells' from the format menu and choose the 'Protection' tab. Uncheck the box next to 'Locked.'4. Choose the cells that you want to protect. To select multiple cells, hold down the 'Control' key while you click on each cell. To select a large block of cells, hold down the 'Shift' key while you click on the first and last cells in the block to be protected.5. ...
Read more ►

Excel 2003 Macros Won't Run

1. Click on 'Tools,' then click on 'Macros,' then click on 'Security.' Check to see if the 'High' radio button is selected. If it is, this is likely preventing your macros from running. Click on the 'Medium' button for the security level and then click on 'OK.'2. Save your worksheet if Step 1 didn't work, then close Excel completely. Restart Excel and reopen the worksheet.3. Repeat Step 1 and Step 2. This should resolve the quirk preventing the macros from runni...
Read more ►

Tuesday, August 23, 2011

How to Graph Complex Functions With Excel

1. Open a blank workbook in Microsoft Excel.2. Enter 'x' in cell A1. Press 'Tab' to go to the next column over. Enter 'y' in cell B1.3. Select cell A2. Enter the first value of x you want to use for the horizontal axis. For instance, to span the negative and positive axes, enter '-5,' and in each cell below, enter the next value in the series, up to 5. Enter '-4' in cell A3 and onward...-3, -2, -1, 0, 1, 2, 3, 4, 5.4. Select all the x values in column A by highlighting A2 and dragging your cursor down to the last cell. You need to define the name of the values, so Excel knows that each...
Read more ►

How to Edit a UDF File

1. Right-click on the UDF file.2. Click on 'Open with.'3. Select the 'Choose Default Program' option.4. Select Microsoft Excel.5. Click on 'Browse' only if Microsoft Excel is not on the list. Then, search for it and click on 'Open.'6. Click on 'OK.' Your UDF file will open.7. Click on 'File.'8. Click on 'Save as.'9. Select the file extension you wish to convert the UDF file to.10. Click on 'Save.' Your UDF has been edit...
Read more ►

Monday, August 22, 2011

How to Use the IF Function in Excel 2007 With Absolute References

1. Enter the 'IF' formula into a cell of your choosing, following the format '=IF(comparison,true_value,false_value)'. As an example, to test if cell A1 is zero, you might enter '=IF(A1=0,'zero','not zero')'. This solely uses relative references.2. Add a dollar sign in front of the cell column letter to prevent the column reference from changing, but allow the row number to change. In the example, it would look like '=IF($A1=0,'zero','not zero')'. This uses an absolute reference for the column, but a relative reference for the row.3. Add a dollar sign in front of the cell row number to...
Read more ►

How to Publish an Excel Workbook

Excel 20101. Click the green 'File' tab at the upper left part of your screen while you have the workbook open. This will bring you to the Microsoft Office Backstage view.2. Click the 'Save and Send' tab in the menu column on the left side of the page. This will bring up the Save and Send options.3. Choose 'Save to Web' to publish to your SkyDrive account, or click 'Save to SharePoint' to save the workbook to a SharePoint account.4. Click 'Publish Options' to choose specific parts of the workbook to publish. You can also just click 'Save As' to publish the whole workbook.Excel 20075. ...
Read more ►

How to Crack/Hack Password Protected Excel Spreadsheets

1. You can do anything with the right tool, only if the right tool existed. In this case the right tool does exist. Brute Force Attack Program will help you easily gain access to the password protected Excel Spreadsheet. It tries every possible password until it gets the one that works. It can take minutes to months depending on how hard you make the password.2. First go to the link below in 'Resources' and download the Brute Force Attack program. It comes with a trial so you can try before you buy. The good news is the program can help you brute force attack/hack/crack Word Documents and...
Read more ►

How to Change Excel 2007 Column Headings

1. Navigate to the folder that contains the Microsoft Excel workbook that you want to edit. Double-click the file to open the workbook in the Microsoft Excel 2007 application.2. Highlight row 1 in the worksheet to which you wish to add column headers. Right-click the row and choose 'Insert' to add a column header row. Skip this step if there are already column headers typed in row 1 of the worksheet.3. Type the heading for each column.4. Click on cell A2 if your worksheet contains only column headings. Click on cell B2 if your worksheet contains both column and row headings.5. Click...
Read more ►

How to Change the Default Page Margins in Excel

1. Open Microsoft Excel and click 'File' on the top of the window. Select 'New' from the File menu. This will open a new Excel workbook.2. Click 'File,' 'Page Setup' and 'Margins.' Enter a size, in inches, for each margin including the sides, header and footer. Click 'Save' on the bottom of the page.3. Click 'File' on the top of the window and select 'Save As.' Type 'Book.xlt' into the box beside 'File Name' and select 'Template' from the drop-down menu for the file type.4. Choose the location to which you are saving this template by navigating to the 'XLStart' folder in the window above...
Read more ►

How to Use Excel's TRUE Function

1. Learn the syntax for TRUE: it is TRUE(). This function does not require any arguments. Similarly FALSE() always evaluates to FALSE.2. Use TRUE with the IF function. TRUE might be used for testing purposes to force a certain value to be returned. For example, consider the IF statement: IF (logic_test;true_value;false_value). If logic_test evaluates to TRUE, true_value is returned, otherwise false_value is returned.3. Look at the following IF statement:IF (TRUE();'is true';'is false')This IF statement will always return the first value. This might be useful during testing if we were not...
Read more ►

How to Format a Web Address Hyperlink in Excel 2010

1. Right click the cell that you want to format and click 'Hyperlink.' The 'Insert Hyperlink' dialog box appears on your screen.2. Click 'Existing File or Web Page' under 'Link to.' Enter the web address in the 'Address' field.3. Enter the text you want Excel to display in the cell in the 'Text to display' box.4. Click the 'OK' button.5. Click the 'Home' tab and click 'Cell Styles' in the 'Styles' group.6. Right click 'Hyperlink' from the 'Data and Model' heading.7. Click 'Modify' and then 'Format' (in the 'Style' dialog box). Change the hyperlink's font, style, size and color on...
Read more ►

Sunday, August 21, 2011

How to Create an XLSX File

Create XLSX files in Excel 20071. Open Microsoft Excel 2007.2. Click the round 'Office' button at the top-left corner of the Excel window and select 'New.' Choose your preferred document or template type and then click 'Create.'3. Click the 'Office' button and select 'Save' when you are ready to save your spreadsheet data. Select the 'Save as type' drop-down menu, choose the top-most option labeled 'Excel Workbook' and then click 'Save.' Your document is saved in XLSX format.Create XLSX files in Excel 2000, Excel XP or Excel 20034. Open a Web browser window and navigate to http://update.microsoft.com/....
Read more ►

How to Remove Adobe in Excel

1. Open Microsoft Excel.2. Click on the program's 'Office' logo button (where the 'File' menu typically is in other Windows programs) at the top of the screen.3. Click 'Excel Options.'4. Select the 'Add-in' category from the 'Options' menu. Clear the check box next to the listing for your Adobe add-in and click on the 'OK' button. This will remove the Adobe add-in from your copy of Microsoft Exc...
Read more ►

How to Use the Exponential Function in Excel

Direct Calculations1. Launch Microsoft Excel and open a blank workbook if one does not automatically open.2. Click a cell to select it. Press the '=' to begin to create a formula for the cell.3. Type 'Power(2,3)' and press 'Enter' or 'Tab' to save the contents of the cell and move to the next cell down or to the right, respectively. Notice that the cell now displays the answer to the first number in parentheses raised to the second number in parenthesis, or 'Two raised to the third power,' which is equal to '8' in this case.Referenced Cells4. Launch Microsoft Excel. Open a blank workbook...
Read more ►

Saturday, August 20, 2011

How to Sort by Cell Color in Excel 2003

1. Press 'Alt and 'F11' together from the Excel worksheet you want to sort. This opens the Visual Basic Editor (VBE).2. Click 'Insert' and then click 'Module.'3. Cut and paste the following code into the blank window:Sub SortByColor()On Error GoTo SortByColor_ErrDim sRangeAddress As StringDim sStartCell As StringDim sEndCell As StringDim rngSort As RangeDim rng As RangeApplication.ScreenUpdating = FalsesStartCell = InputBox('Enter the cell address of the ' _'top cell in the range to be sorted by color' _Chr(13) 'i.e. 'A1'', 'Enter Cell Address')If sStartCell > '' ThensEndCell = Range(sStartCell).End(xlDown).AddressRange(sStartCell).EntireColumn.InsertSet...
Read more ►

How to Insert Hyperlinks into Excel 2007 Without Changing Text Format

1. Open the saved spreadsheet.2. Click to highlight the text where you wish to insert the hyperlink.3. Click the Insert tab on the ribbon.4. Click on the 'Hyperlink' button in the Links group. A dialog box entitled Insert Hyperlink will appear.5. Click a file from the Look In list. If the hyperlink leads to a website, click the Address box and enter the URL.6. Click the 'OK' button. The colored hyperlink appears on the selected text.7. Change the text that contains the hyperlink, if you wish. For example, to change the hyperlink color to match the original font color of the text,...
Read more ►

How to Find Row Number of Active Cell For VBA

1. Press 'Alt' and 'F11' together from inside the worksheet where you want to find the active cell's row number. This action opens the Visual Basic Editor (VBE).2. Click 'Insert' and then click 'Module' to open a blank module window.3. Cut and paste the following code into your worksheet:Sub RowNum()MsgBox 'The active cell row is ' ActiveCell.RowEnd Sub4. Press 'F5' to run the routine. The macro will return the active cell's row in a message b...
Read more ►

How to Make a Graph in MS Excel

Instructions1. Input the graph data. For the purposes of this example, type 'Month' in cell A1, and type the months January through December in cells A2 through A13. In cell B1, type 'Applications.' For each month, increase the 'Applications' number by 200. In cell B2, type '200,' in cell B3 type '400' and so on. The last figure in the 'Applications' column -- '2,400' -- is in cell B13.2. Place the cursor on a cell within the data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Go to the 'Insert' tab. Click on the down arrow under the...
Read more ►

Friday, August 19, 2011

How to Create Quality Control Charts in Excel

1. Distribute your data to revolve around a mean (average). Ensure your measurements are independent of each other. Create a subgroup for each data point and measurement number.2. Add all your measurements in the subgroup and divide by your number of measurements. Calculate the mean of all the means; this will determine your over all mean. Determine the standard deviation of your data points by using this command: 'Standard deviation: =STDEV(data points).'3. Tally the upper and lower control limits (UCL, LCL). Enter this formula: 'UCL = CL 3*S', 'LCL = CL -- 3*S.' This conveys 3 standard...
Read more ►

How to Convert XML to an Excel 2003 Spreadsheet

Converting the XML File Directly Using Excel 20031. Click on the Microsoft Excel 2003 icon on your computer's desktop to open the application. Or click 'Start,' 'All Programs,' 'Microsoft Excel 2003,' if you are using Windows. On a Mac, click on the Excel icon in the Applications folder of your Mac's hard drive.2. Click 'File,' then 'Open.'3. Click on the down arrow next to the box labeled 'Files of Type.' Select 'XML files (*.xml).'4. Click on the down arrow next to the box labeled 'Look In.' Navigate to the directory containing the XML file you would like to convert to a spreadsheet.5....
Read more ►

How to Make a Large Organizational Chart on Microsoft

1. Open the Excel, Outlook, PowerPoint or Word program to display a new document.2. Click the “Insert” tab on the command ribbon.3. Click the “SmartArt” button in the “Illustrations” group. A gallery of thumbnail images appears.4. Click the “Hierarchy” option in the left pane to display “Hierarchy” charts in the middle pane.5. Click a thumbnail image to preview an enlarged view and chart description.6. Click “OK.” The chart template copies to the new document. The “SmartArt Tools” ribbon displays two tabs: “Design” and “Format.”7. Click the “Design” tab on the “SmartArt Tools” ribbon.8....
Read more ►

How to Create a Family Budget Using Microsoft Excel

1. Open Microsoft Excel.2. Click cell 'A1,' then type 'Item.'3. Click cell 'A2,' then type the first item in your budget. For example, 'Grocery.'4. Click cell 'A3,' then type the second item in your budget. For example, 'Rent.' Continue entering your budget items in column A, moving down the column.5. Click cell 'B1' and then type 'Amount.'6. Click cell 'B2,' then type the amount that corresponds with the item in cell A2. In this example, cell A2 contained the item 'Grocery.' If you spend $600 per month on groceries, type 600.7. Click cell 'B3,' then enter the amount that corresponds...
Read more ►

Thursday, August 18, 2011

How to Add Dates in Microsoft Excel

1. Right-click on the cell you want to format.2. Choose 'Format Cells' from the list.3. Click on the 'Number' tab.4. Choose 'Date.'5. Click on the date option from the list box. For example, click on '5-Jul' to format all dates in that particular cell that way.6. Press 'O...
Read more ►

How to Make a Rubric in Excel

1. List the achievement levels across the first row, one level per cell. Reserve column A for the category titles and begin the achievement headings in column B. The achievement levels may be academic grades, place rankings or any other scoring system.2. Click on the row header to highlight the entire row. Then select the 'Home' tab from the ribbon and click the 'Bold' button in the 'Font' group. Making the text bold allows the user to more easily distinguish the headings from the criteria.3. Type the category headings down the first column, one category per cell. For instance, a rubric...
Read more ►

Wednesday, August 17, 2011

How to Turn Off Auto Save

Instructions1. Turn off AutoSave in Visio. Go to the 'Tools' menu and select 'Options.' When the new window comes up, click on the 'Save/Open' tab. Uncheck the box next to 'Save AutoRecover information.' Click 'OK' at the bottom of the window.2. Turn off AutoSave in Word, Excel or PowerPoint. Click on the button at the top left of the program's window that looks like the Windows logo. Look for a button that says 'Word Options,' 'Excel Options' or 'PowerPoint Options' at the bottom right of the window that appears. Click on 'Save' in the list at the left. Uncheck the box next to 'Save AutoRecover...
Read more ►

How to Create a Scatter Plot With a Microsoft Word Spreadsheet

1. Open the Word document.2. Click on the 'Insert' tab on the command Ribbon.3. Click on the 'Chart' button in the 'Illustrations' group. A dialog box will display the different charts.4. Click on an 'XY (Scatter)' chart button. Click on the 'OK' button. An Excel worksheet and a chart template will appear.5. Enter the values on the worksheet. Click the 'Enter' key. The data will convert on the scatter chart.6. Format the scatter chart for a custom look. For example, the 'Design' tab includes chart styles. The 'Format' tab includes colored outlines.7. Save this docume...
Read more ►

How to Create a Form Using Microsoft Excel

1. Insert form. Open a new workbook in Microsoft Excel. Press the 'Alt' and 'F11' keys on your keyboard to open Microsoft Visual Basic. Double click on 'Sheet 1' (Sheet 1) under Microsoft Excel Objects in the left window pane under VBAProject. Go to the Insert menu and select 'UserForm' to insert a form.2. Name form. Go to the Properties window in the left window pane and click on 'UserForm1' next to (Name). Type a new name for your form. Hit 'Enter.'3. Add text box. Click on the 'Textbox' button in the Toolbox toolbar. Click on a place in the form where you would like to add a standard-sized...
Read more ►

Tuesday, August 16, 2011

How to Create a Pivot Table From External Data in an Excel File

1. Save your external data into a file. The most common type of file is an external database.2. Pull up a blank spreadsheet within Excel 2003. Click 'Data' in the drop-down menu and scroll down to 'PivotTable.'3. Click 'External Data Source' and select 'PivotChart Report with PivotTable Report.' Once you make these selections, another pop-up menu will appear.4. Select 'Get Data,' which will bring up another window. Select the file or database you will be choosing from. These include Access, Excel, dBase, and ODBC.5. Click OK and close. Use default value for all other prompts and click...
Read more ►

How to Copy Formulas Down in Excel Lightning Fast

1. Open the Excel 2010 spreadsheet where you want to add your formula.2. Select the first cell where you want the formula to appear and type in your formula. Press 'Enter' when you are done.3. Move the mouse to the cell where you just entered your formula. Move the pointer over the bottom-right corner of that cell and it will change into a ' ' sign.4. Click and hold the mouse button. Drag the mouse down the spreadsheet until you reach the last cell where you want the formula to appear. Release the mouse button, and the formula will instantly copy itself down into every ce...
Read more ►

Monday, August 15, 2011

How to Use a Financial Calculator to Get Compound Interest

1. Use the compound interest financial calculator on Moneychimp (moneyChimp.com). Fill out the boxes on screen with information about your current loan including the principle, the interest rate, the annual addition and the years to grow. Input the number of times your interest is compounded. Click 'Calculate' to view the total amount of your loan or investment with compound interest added in.2. Use the financial calculator on 1728.com. Fill out the boxes at the bottom of the financial calculator page with information about your current loan, savings account or investment (whichever applicable)....
Read more ►

How to Create CSV Files in Excel 2007

1. Open your spreadsheet. Click on the 'Office' button in the upper left-hand corner.2. Select the 'Save As' option from the pull-down menu. Click on the 'Other Formats' button.3. Choose the 'CSV (Comma delimited)' option.4. Type a name for the CSV file.5. Check the location of the file, making sure you remember where the file will be saved.6. Click on 'Save.' You can now close the Excel file.7. Open the CSV file to make sure there weren't any problems with the expo...
Read more ►

Sunday, August 14, 2011

How to Make a Graph in Excel Edit the Legend

Create a Chart1. Open the Excel worksheet that contains the data for the chart.2. Click and drag to select the data for the chart.3. Click the “Insert” tab on the command ribbon.4. Click the arrow for the preferred chart type in the “Charts” group. Examples of chart types include 'Column,' 'Line' and 'Pie.' A gallery of chart thumbnails appears.5. Click to select the chart type. A chart displays over the Excel worksheet. The “Chart Tools” ribbon shows three tabs: “Design,” “Layout” and “Format.”6. Format and style your chart with the commands on the “Design,” “Layout” and “Format”...
Read more ►

How to Automatically Shade Every Other Row in Excel 2007

1. Open the spreadsheet you want to shade the rows of in Excel.2. Hold the 'Ctrl' key on your keyboard and press 'A,' releasing both keys.3. Click 'Home' on the top menu in Excel 2007.4. Click 'Format as Table' under 'Styles' and click 'OK.' This shades the rows for you automatical...
Read more ►

How to Make Excel Reports

1. Open the Excel program to display a new worksheet.2. Click the “File” tab on the command ribbon to display a list of commands.3. Click “New,” then a gallery of “Office.com Templates” appears.4. Click the “Reports” link, then a list of folder icons appears.5. Click the preferred folder such as “Financial Records,” “Logs” or “Human Resource Records.” A gallery of thumbnail images appears.6. Click the preferred report image to display a larger image in the preview pane to the right.7. Click “Download” in the right pane. The template copies to the new worksheet.8. Click in a cell...
Read more ►

How to Set Margins in Excel

1. Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.2. Choose the 'File' menu and click 'Page Setup' to open the 'Page Setup' dialog box. The 'Page Setup' dialog box can be used to set up your page just how you would like it to appear.3. Click on the 'Margins' tab at the top of the 'Page Setup' dialog box to show the margins for the spreadsheet that you currently have option.4. Set the 'Left,' 'Top,' 'Right,' 'Bottom,' 'Header' and 'Footer' margins by clicking within the text box underneath each option to highlight the current margin setting.5....
Read more ►

Saturday, August 13, 2011

How to Create a Currency Converter With Microsoft Excel

1. Select the currency you want to convert to.2. Find the current conversion rate. Sites such as Yahoo's currency converter will list the latest currency conversion rate for the various international currencies. Several sites offer this service, so perform an Internet search for the site you feel most comfortable with.3. Open Microsoft Excel. Label the first three columns in the Excel spreadsheet as 'Current Currency,' 'Currency Conversion Factor' and 'Converted Currency.' You don't have to label the columns as indicated here, but for instructional purposes, it makes it easier to identify...
Read more ►

How to Import More Than 65,536 Rows in Excel 2003

1. Click 'Tools,' select 'Macro' and choose 'Macros.'2. Type a name for your macro in the 'Name' field, such as 'LargeFileImport,' and click 'Create.' The Visual Basic Editor will open automatically.3. Double-click '(Name) Module' in the 'Properties' window and type 'LargeFileModule.'4. Click the ' ' icon next to 'Microsoft Office Excel Objects.'5. Double-click 'LargeFileModule' to open the 'Code' window.6. Copy and paste the following into the 'Code' window:Sub LargeFileImport()'Dimension VariablesDim ResultStr As StringDim FileName As StringDim FileNum As IntegerDim Counter As Double'Ask...
Read more ►

How to Restore All Hidden Columns in Excel

1. Open the spreadsheet in Excel.2. Click on the arrow in the top left corner of the Excel spreadsheet. This highlights all data in the workbook.3. Click 'Format' in the 'Cells' menu along the top of the page. A drop-down menu appears.4. Click 'Hide Unhide' under the 'Visibility' heading, then click 'Unhide Columns.' Changes are applied instantly and all columns are visib...
Read more ►

Thursday, August 11, 2011

How to Create a Simple Checkbook Register With Microsoft Excel

1. Open Microsoft Excel. Type in 'Check Register' in cell A1. Center this across the columns you will be using, from A through G. Select cell A1, hold down the shift key and select cell G1. After you highlight it, go to 'Format' and 'Merge Cells.' Then select 'Center' which is under 'Format' and 'Cells.'2. Skip a row and make the headings starting in cell A4. Type in 'Item Number,' move to the next column and type in 'Date,' move to the next column and type in 'Description of Transaction,' continue moving and typing the headings as follows: 'Payment,' 'Done,' and 'Deposit.' Go to cell G3 and...
Read more ►

How to Number the Rows in Excel 2007

Fill Column1. Select the first cell in spreadsheet.2. Type the starting value in that cell.3. Type another value in the next cell to start sequence.4. Select cells with values that you've typed inside.5. Drag 'fill handle' to include number of cells that you want in your sequence.ROW Function6. Type '=ROW(A1)' into the first cell of the range you want to sequence. This will give you the number 1 in that cell.7. Type specific number after '=ROW(A1)' to start numbering at a certain point. For example, typing '=ROW(A1),'2010-000' will create a starting number of 2010-001.8. Drag...
Read more ►

How to Use MS Excel 2007 to Calculate Sum

1. Enter values into a row or column of cells.2. Navigate to the cell you want the sum to appear. You may pick any cell, even one nowhere near the cells you want to sum.3. Click the 'AutoSum' button in the Editing Box at the far right of the Home tab. Excel will enter the Sum Function in the active cell, including a range of cells to add.4. Make certain the cell range is correct (notice the dashed box for a visual representation of the cell range). Press the Enter key to confirm the Sum function.5. Drag through another range of cells if the range Excel entered is not the range you need...
Read more ►

How to Copy Formulas in Excel

1. Determine what formula is to be copied and to what location it is to be copied. Carefully consider the cells that are to be referenced in the formula and that they are indeed the cells that contain the information to be acted upon by this formula.2. Highlight a cell that has the formula in it and click the right mouse button. Select the 'Copy' option.3. Move to the new destination cell for this formula, right click the mouse button and select 'Paste.'4. Check the first cell to make sure the correct calculation has been performed. If not, check the formula that appears in the cell that...
Read more ►

How to Write Simple Macros in Excel

1. Go to the worksheet you want to insert a macro on.2. Click 'Record New Macro' after clicking 'Macro' on the Tools menu.3. Name the macro with keyboard shortcut or assign it to a toolbar. You can also add a description of the macro for reference later. These are all optional commands that you can do in the dialogue box, the next step in the wizard. If you don't want to do any of these things, you can skip the step all together and click 'OK' to start recording the macro. New macros are saved in the global template named Normal.dot by default and you can always assign a name or toolbar...
Read more ►

How to Determine Y Axis Values in an Excel 2003 Line Graph

1. Highlight the entire range, including the x-axis and y-axis values.2. Click 'Insert' from the menu bar. Click 'Chart.' This launches the Chart Wizard. Alternatively, click the icon of a bar graph from the toolbar.3. Select 'Line' under 'chart type.' Pick a sub-type from the right pane. Click 'next.' The wizard will generate a preview of your chart, guessing which values you want on the y-axis. The window will change to 'Step 2 of 4.' If the wizard correctly determined your values, click 'finish' to insert the chart.4. Click the 'series' tab. One box will contain the cell numbers of...
Read more ►

Blogger news