Monday, June 18, 2012

How to Make a Chart in Excel to Show 2009 2010 Data Side

1. Open the Excel 2010 spreadsheet that holds your 2009 and 2010 data.2. Click and hold the mouse on 'A1' above the first column and then drag the mouse to column 'C' and release the button. Right-click 'A' and choose 'Insert,' creating three new columns at the front of the spreadsheet.3. Click cell 'B1' and type '2009.' Then click cell 'C1' and type '2010.' Click cell 'A2' and type in the first period for which you have data. This can be a day, week, month, quarter or any time period, less than a year, that you need. Continue down the column until you have added all your time periods.4....
Read more ►

Sunday, June 17, 2012

How to Unprotect a Password Protected Word Document

1. Open the Word document with the password that was previously set. If you don't have the password, you will not be able to open the document or remove the password.2. Click on 'File' then 'Info.' Under the 'Permissions' area click on 'Encrypt with Password' if you are using Microsoft Word 2010. If using Word 2007, click on the circular 'Office' button, 'Prepare' then the 'Encrypt Document' button. In Word 2003 select 'Tools,' 'Options' then 'Security.'3. Highlight all characters in the password field and delete them. This removes the password from being prompted at start up. Click on the...
Read more ►

How to Create a Map From an Excel Spreadsheet

1. Insert your data into an Excel worksheet. Include a column heading. For example, put a list of city names in column A (with the heading 'City names' in cell A1), and put a list of ZIP codes in column B (with the heading 'ZIP codes' in cell B1).2. Click 'File' and then click 'Save.'3. Click on the top left cell of your data. In the above example, that would be cell A1. Drag the cursor down over your data, to the bottom right corner.4. Click 'Insert' and then click 'Map.'5. Click on the area of the worksheet where you want your map to be. Hold the left mouse button and drag the cursor...
Read more ►

Saturday, June 16, 2012

How to Repeat an Action

1. Start Excel by clicking the Windows 'Start' button and typing 'excel' into the search bar. Click the 'Microsoft Excel 2010' result that appears.2. Click the green 'File' tab, click the 'Help' heading, and then click 'Options.'3. Click the 'Quick Access Toolbar' entry. Click the 'Choose commands from' drop-down box and then select 'Popular Commands.'4. Select 'Repeat' from the list of commands, and then click the 'Add' button. Click 'OK' to close the dialog box.5. Point the mouse cursor to the top of the Excel interface and then click the blue 'repeat' button that has appeared the...
Read more ►

How to Use OLAP in Excel

1. Launch Microsoft Excel. Click the “Data” tab on the main menu ribbon. Click “From Other Sources” in the “Get External Data” group. Click the “From Analysis Services” option in the drop-down list.2. Type the name of the remote OLAP server into the “Server Name” input field in the Data Connection Wizard. Click the check box next to “Use the following User Name and Password.” Enter your database username and password into the applicable boxes. Alternatively, click “Use Windows Authentication” if the remote server is set up to work with your Windows username and password. If in doubt, check...
Read more ►

Friday, June 15, 2012

How to Divide Excel Pivot Table Data Into Separate Spreadsheets Within the Same File

1. Open Excel 2007 and select a workbook. Select the 'Office' button and click 'Open.' Browse your network and click the file. Select the 'Open' button. The workbook opens.2. Highlight the data you want included in your pivot table. Select the 'Insert' tab and click 'Pivot Table.' Select 'Pivot Table' again. The Create Pivot Table dialog appears. Click 'OK.' A blank pivot table appears.3. Add fields to the pivot table by checking field names from the right 'Pivot Table Field List.' Add fields that you want calculated or summarized into the pivot table by checking them. Manually...
Read more ►

How to Convert XLS to PRN Files

1. Use Microsoft Excel to open the XLS file you want to convert.2. Select Print from the File menu. Do not use the Print button on the toolbar because the toolbar button will bypass the print dialog window.3. In the Print dialog window check the Print to file checkbox. Normally this checkbox is off, in which case Excel would print to the printer. Click the OK button.4. In the Print to File dialog window type the Output file name. This will be the name of your file on the disk. Excel does not automatically add the '.prn' to the file name so you must type that in yourself; it will still...
Read more ►

Thursday, June 14, 2012

How to Add ActiveX Control in Excel 2007

1. Open the Microsoft Excel 2007 application from your computer and then click on the “Microsoft Office” button.2. Click on the “Excel Options” button and then click on the box next to the “Show Developer tab in the Ribbon” field. Click on the “OK” button.3. Click on the “Developer” tab and then click on the “Insert” option from the “Controls” group. Click on the “More Controls” option below the “ActiveX Controls” group.4. Click on the ActiveX Control that you want to add from the list of controls in the More Controls dialog box.5. Click the location on your worksheet where you want...
Read more ►

How to Remove Duplicate Lines in Excel

Excel 20031. Open the Excel file that has the duplicate data that you need to remove.2. Highlight the data that you want to work with, then right-click and select 'Copy.' Click on an empty cell on your worksheet, right-click and choose 'Paste.' This step creates a backup copy of all the data.3. Highlight the original data again.4. Click the 'Data' menu and then click 'Filter.' Scroll over and click 'Advanced Filter.'5. Place the radio button next to 'Filter the list, in place' in the 'Advanced Filter' window. Put a check mark next to 'Unique records only.'6. Click the 'OK' button.7....
Read more ►

How to Resize Cells in Excel 2007

1. Click on the cell(s) from the columns you want resized.2. Click on the 'Home' ribbon, and then click 'Format' in the 'Cells' group.3. Click the 'Width' option in the 'Cell Size' graph that appears.4. Type the length you would like the cells to be in the box that appears.5. Click 'OK' to resize the cel...
Read more ►

How to Password Protect Excel Worksheets

1. Go to 'Tools' on the main menu.2. Select 'Options.'3. Select the 'Security' tab.4. Under 'File encryption options for this document,' enter the password in the field called 'Password to open' and click 'OK.'5. In the Confirm Password window, enter the password in the field called 'Reenter password to open' and click 'OK.' In the Confirm Password window, Excel gives two cautionary notes: first, that a lost or forgotten password cannot be recovered; second, that passwords are case-sensitive. This means that a password such as 'abcd' is not the same as 'Abcd.'6. Save the password by...
Read more ►

How to Make Excel 2007 Your Default Program

1. Hold the Windows orb key, and press 'R' to open the 'Run' dialog window.2. Type the exact phrase in the Run dialog window, including quotation marks:'C:\Program Files\Microsoft Office\Office12\excel.exe' /regserverIf you installed Excel 2007 in a different folder, adjust the path accordingly. If you are using a 64-bit version of Windows 7, change 'Program Files' to 'Program Files (x86)'.3. Click 'OK' to have Excel register itself as the default progr...
Read more ►

How to Recover an Excel Work File That Wasn't Saved

File Never Saved1. Reopen Excel.2. Click on 'File' in the upper-left hand corner of the screen. Then click 'Recent.'3. Select 'Recover Unsaved Workbooks.' This will display a list of any workbooks you worked on that were not saved.4. Select your file you were working on. Excel will record the time that the file was last worked on, so you can tell which file is the one you want if the time is close to when you closed Excel without saving or Excel crashed.5. Click 'Open.'6. Click 'Save As' to save your file. You need to name the file and then click 'Save.'Files Previously Saved7. Open...
Read more ►

Wednesday, June 13, 2012

How to Sort Alphabetically in Excel 2003

1. Enter your data into a column or row in Excel.2. Click on the column letter on the top of the spreadsheet or the row number on the side of the spreadsheet that you want to alphabetize.3. Click the button with an A on top of a Z near the top of the window if you want to sort from A to Z or click the button with a Z on top of an A if you want to sort from Z to...
Read more ►

How to Save Print Settings in Excel 2007

1. Open Microsoft Excel from the Windows Start Menu by clicking 'Start' > 'Program Files' > 'Microsoft Excel'. The application will start in a new window.2. Open your spreadsheet from the top pull-down menu. Click 'File' and 'Open...', and then select your spreadsheet file using the file browser window.3. Select the cells you want to print by clicking and dragging your mouse on the spreadsheet to highlight the cells of your choice.4. Open your Page Setup settings from the top menu by clicking 'File' > 'Page Setup...'. Adjust the margins and page orientation to fit what you are...
Read more ►

Blogger news