1. Open the Excel file that you want to place the PDF into.2. Click on the cell you want to insert the PDF on. The upper left corner of the PDF will align against the upper-left corner of the cell you have selected, although you can move it later if you want.3. Click the 'Insert' menu from the top the Excel window.4. Select 'Object.'5. Click on the 'Adobe Acrobat Document' in the 'Object type' section and then click the 'OK' button.6. Navigate to the PDF that you want to insert.7. Click the PDF and then click the 'Open' button. Your computer will open the PDF in Adobe Reader and...
Browse » Home » Archives for October 2012
Sunday, October 28, 2012
How to Use the Range.sort Method in VBA
1. Open the Excel 2010 spreadsheet that you want to sort using VBA. Press 'Alt' and 'F11' simultaneously to bring up the VBA editor.2. Double-click on the module, which is located on the left side of the editor, where you are writing your VBA code. Your code will appear on the right side of the screen. Place your cursor into an empty line of code where you want to use the Sort method.3. Enter the following code into the VBA editor, without quotes: 'Range('A:B').Sort key1:=Range('A1'), Order1:=xlAscending'. Change 'A:B' to the Excel range that you want to sort and change 'A1' to the first...
How to Reverse the Order of a Chart in Excel 2003
1. Click the axis for the categories, series or values that you want to change the order of.2. Click the 'Format' tab, click 'Selected Axis' and then click the 'Scale' tab.3. Check 'Categories in Reverse Order,' 'Values in Reverse Order' or 'Series in Reverse Orde...
How to Convert Quattro Pro Files to Word Documents
Converting Quattro Pro with Microsoft Excel1. Go to “Start->Settings->Control Panel” (or “Start->Control Panel” in Windows XP).2. Choose “Add/Remove Programs,” highlight “Microsoft Office” or “Microsoft Excel,” and click “Add/Remove.”3. Click on “Add/Remove Features,” locate and run “Quattro Pro Converter 5.0” to install the converter, and click “Update Now” to complete.4. Open Microsoft Excel. Go to “File->Open” and select the Quattro Pro file you wish to convert.5. Go to “File->Save As,” select “Microsoft Excel (*.xls)” under “Save as type” and click “Save.”Converting...
Saturday, October 27, 2012
How to Put Small Caps in MS Excel Vista
1. Open Microsoft Excel. Choose 'View' from the menu bar and click 'Toolbars' from the drop-down menu. Select 'Formatting' to view the formatting toolbar. There should be a check mark on its left side to indicate that the toolbar is on, and it should appear below the standard toolbar, which you will recognize by 'Print' and 'Save' icons among many others.2. Activate the cell or cells that you would like to apply the small caps effect. Write all of the text that you would like to have in small caps in uppercase, or capitalized, letters.3. Highlight the letters that you would like to apply...
How to Use Variables in Excel
1. Select the cell with the result that you want to declare as a variable.2. Click on the Formulas menu item, and choose Names (Excel 2003 and earlier) or Name Manager (Excel 2007 and Excel 2010).3. Enter the name of the variable in the dialog that comes up. From this point on, in this workbook, you'll be able to refer to the contents of this cell by entering its na...
How to Flow a List Across Multiple Columns
1. Choose the two columns you want to merge. You can also merge several columns on the spreadsheet. Once selected, click the first column and drag the mouse across the others. This will highlight multiple columns at once.2. Click the 'Merge and Center' button in Microsoft Excel 2007. In Excel 2003, click the 'Format' menu item and select 'Merge and Center' from the list of options.3. Select 'Merge Across' from the menu list in Excel 2007. In Excel 2003, select 'Merge.' You will notice that the cell lines across the columns disappear. This indicates that the columns have been merged.4. ...
How to Create Excel 2007 Custom Properties
1. Start Excel by clicking on the icon labeled Microsoft Office Excel 2007. It may be located on your start menu, quick launch bar or desktop.2. Click on the menu item labeled 'File' with your left mouse button, then select the line labeled 'Properties' to bring up the file properties screen. Select the Custom tab to display the Custom panel. Enter a name for the custom property or select one from the drop-down box labeled 'Name.'3. Look at the 2 buttons on the right. They are grayed out, which means that they are not functional at this point because you have not entered a value for the...
Friday, October 26, 2012
How to Add Borders to Cells in Microsoft Excel 2003
1. Select the cell that you want to add borders to. You will first need to select and activate the cell that you wish to add a border to. Do this by left-clicking on the desired cell.2. Select the border type. Adding a border is very easy to do. Once you have selected the cell that you wish to add a border to, right-click on it and select “Format Cell.”3. Add the border. A cell formatting properties box will open. Left-click on the “Border” tab. There are several different types of borders that you can add, which are displayed as icons in the “Borders” tab. You can outline the cell, create...
Thursday, October 25, 2012
How to Remove a Password Protected Cell
1. Open Microsoft Excel. Open the Excel spreadsheet file from within Excel.2. Find the security options in Excel. It will most likely be in the 'Tool' menu under 'Options.' Look under the 'General' tab and the 'Security' tab if there is one. Look for password settings.3. In the password protect field select the asterisks and then the delete button. There may be a second password field for modifications, if so delete that password as well. You may be required to enter the password before you can delete the old password.4. Exit out of the menu choices. Select the cell that was password protected...
How to Create a Balance Sheet in Excel
Find Template Through Excel1. Open Excel and click 'New' from the 'File' tab at the top of the screen, then scroll through the 'Templates' list at the left of the screen to view templates that came pre-loaded with your program and available on the Office website.2. Click 'I Accept' on the right hand side of the page to accept the terms and conditions, if necessary. Browse under the 'Budget,' 'Expense Reports' and 'forms' categories to locate different kinds of balance sheet templates.3. Click 'Download' to download and open a desired template in Excel.4. Fill out your balance sheet.Find...
How to Delete a Page in MS Excel 2007
1. Click the 'Worksheet' tab at the bottom of the Excel window that you want to delete. For example, click on 'Sheet 2.'2. Click on the 'Home' tab in the 'Office' ribbon.3. Click on the down arrow next to the 'Delete' icon in the 'Cells' group.4. Scroll down in the drop-down menu and click on 'Delete Shee...
How to Create Graphs Embed in Spreadsheets
1. Open the saved Excel worksheet.2. Click and drag to select the range of data for the chart. For example, select the categories and the values to appear on the chart.3. Click the 'Insert' tab on the command ribbon.4. Click the preferred 'Chart' button on the 'Charts' group. Click the window launcher arrow in the group's bottom right corner to open a more extensive chart list. A chart appears over the worksheet. The 'Chart Tools' ribbon appears with additional format options.5. Click the preferred formats on the various ribbon tabs, such as 'Design,' 'Layout' or 'Format.' Create a custom...
Wednesday, October 24, 2012
How to Prevent Julian Dates in Excel 2003
1. Click on the cell with the Julian date.2. Type '=RIGHT(YEAR(A1' into the 'Find what?' text box.3. Search for the Excel formula that converts standard dates to Julian dates. The full formula is '=RIGHT(YEAR(A1),2)TEXT(A1-DATE(YEAR(A1),1,0),'000')' where 'A1' is the cell location of the Julian date.4. Click on the cell with the formula, then press the 'Delete' key to remove the formu...
Tuesday, October 23, 2012
How to Change the Orientation of a Worksheet to Landscape in Microsoft Excel
1. Connect your computer to a printer if you have not set up a printer yet for your computer. You do not need an active printer connection to change the page orientation, but you do need a printer setting entered into the computer. Otherwise, Excel will gray out the page orientation option because it only applies to printing. Connecting a printer via USB will automatically launch the setup wizard. Follow the onscreen instructions to install the printer driver until the setup is complete.2. Launch Excel and open your workbook to the worksheet you want in landscape mode.3. Close out of any...
How to Calculate Percentages in Excel 2007
1. Open Excel, and in cell A1 type the numerator. In cell B1 type the denominator. For example, for 75 percent, in A1 type '3' and in B1 type '4.'2. Type '=a1/b1' in cell C1. In the example, C1 will result in 0.75.3. Right-click cell C1, then click 'Format Cells.' Under the 'Number' tab, click on 'Percentage.' Choose how many decimal places you want to take the percentage to. Hit OK. The number is now formatted as a percenta...
Monday, October 22, 2012
How to Format the Toolbar Font Drop Down Menu in Excel 2007
1. Open Microsoft Excel 2007 on your computer screen.2. Click on the circular button at the top of the screen that contains the 'Office' logo.3. Click the 'Excel Options' button followed by the 'Customize' menu option.4. Use the 'Customize' menu on-screen to make the necessary changes to both your main toolbar as well as to the font drop down-menu in Excel 2007. If you want to remove something from either menu, click on its name and click 'Remove.' To add a command to either menu, click on its name and click 'Add.'5. Click 'OK' to save the changes you've just made to your Microsoft Excel...
How to Find Hidden Macros in an Excel Spreadsheet
Finding Macros with the Macro Tools in Excel1. Open Excel normally.2. Click on the 'Developer Tab.'3. Click on the button labeled 'Macros.' A dialog box will pop up. The dialog box will have all the Macros available on all open workbooks. You can select 'Macros' there and delete them.Finding Macros with the Visual Basic Editor4. Open Excel normally.5. Click on the 'Developer Tab.'6. Click on the button labeled 'Visual Basic.' The Visual Basic editor will pop up. On the left hand pane, there will be a list of every single Macro that Excel has loaded; this will include Macros that...
How to Update Microsoft Excel
1. Use the update feature in Excel. Click the 'Office' logo in the top left corner. Click 'Options.' Click the 'Resources' tab. Click 'Check For Updates' under the 'Get Updates' title. The program will automatically search for updates and download them.2. Use Microsoft Windows Updater. Click the 'Start Menu,' and type 'Check For Updates' in the 'Start Search' bar. Hit 'Enter' on the keyboard. Windows updater will open. Click 'Download Updated.' Windows Updater will download updates for Excel, Windows and all other Microsoft programs.3. Upgrade Excel. Excel will only update the version of...
How to Open a Protected Excel 2003 in Excel 2007
1. Click “Start,” select “All Programs,” open the “Microsoft Office” folder and then click “Microsoft Excel” to open Excel 2007.2. Click “File” and then click “Open” to access the files on your computer.3. Browse through the files on your computer for the password protected Excel 2003 worksheet you want to open in Excel 2007.4. Select the file in question and click “Open” to open the worksheet.5. Type in the password for the protected worksheet and then click “OK' to access the file. If you don’t know the password, you’ll have to ask the creator of the file for it or download a password...
How to Create a Legend for a Spreadsheet
Chart Legend1. Create a chart from existing data within a Microsoft Excel spreadsheet. Note that legends aren’t recommended for use with pie charts. Labels should be used instead.2. Go to “Insert” and select “Chart.”3. Select your chart type. Press “Next.”4. Select your data range. Either enter the range of cells manually or press the small button to the right of the range box. Highlight the cells you wish to include in your chart. Choose the “Series” tab to further customize your data range. Press “Next.”5. Enter a title for your chart, X axis and Y axis.6. Select the “Legend” tab....
Sunday, October 21, 2012
How to Change the Vertical Axis on an Excel Bar Chart
1. Click on the vertical axis of the bar graph.2. Click on the 'Layout' tab under 'Chart Tools.'3. Click on 'Format Selection.' The first tab in the pop-up window, 'Axis Options,' allows you to change general options like the interval between tick marks and placement of axis labels. For example, if you want the vertical axis labels to appear in front of the bars (as opposed to sitting in the middle), click on the 'Between tick marks' radio button under 'Position Axis.'4. Select the placement for the vertical axis from the 'Axis Options' tab. For a vertical axis below the bar graph, choose...
Saturday, October 20, 2012
How to Recover Unsaved Word Documents if a Computer Turns Off
Turn on the AutoSave Option1. Open the Word file.2. Click the 'File' tab on the command Ribbon. A list of basic commands opens.3. Click the 'Options' button. A dialog window opens.4. Click 'Save.' This link appears in the left pane. A dialog window opens.5. Click to select the check box for 'Save AutoRecover information every 'X' minutes.' This option appears in the 'Save documents' section.6. Type the number of minutes, such as 10, to specify the timed intervals.7. Click to select the check box for 'Keep the last autosaved version if I close without saving.'8. Click 'OK.'Access...
How to Convert Rows Into Columns
1. Open Excel and input the following data going across in cells 'A3 through L3' the months January through December. In cells 'A4 through L4' enter random figures as shown in the illustration. (NOTE: You can use an existing chart of your own, instead.)2. Highlight the range starting from cells 'A3 through L4'. Do this by placing the mouse pointer in cell A3 and left-clicking the mouse once. While still holding down the mouse pointer, drag it to cover the last cell position in the range of data which is column L and row 4 (L4) and then let go of the mouse.3. Select 'Edit' and then choose...
Friday, October 19, 2012
How to Make My Excel Spreadsheet Interactive
Use the 'Share Workbook' Command1. Open the Excel file.2. Click the 'Review' tab on the command Ribbon.3. Click 'Share Workbook' in the 'Changes' group. A 'Share Workbook' dialog box appears.4. Click the 'Editing' tab on the 'Share Workbook' dialog box.5. Click to select the check box for 'Allow changes by more than one user at the same time. This also allows workbook merging.'6. Click the 'Advanced' tab in the 'Share Workbook' dialog box.7. Select the radio buttons for options, such as 'Track changes' and 'Conflicting changes between users.'8. Click 'OK.'9. Click 'Save' on the...
How to Delete All Unprotected Cells in Excel Spreadsheet
1. Open the spreadsheet containing the unprotected cells that you want to delete. Go to the 'Edit' menu in Excel 2003 and select 'Find.' Go to the 'Editing' group on the 'Home' tab in Excel 2007 or 2010 and click 'Find and Select.' Choose 'Find' from the drop-down menu. You can also use the keyboard shortcut 'Ctrl F' to open the 'Find' dialog box.2. Click the 'Options' button to expand the 'Find' dialog box. Click the 'Format' button to open the 'Find Format' dialog box.3. Go to the 'Protection' tab of the 'Find Format' dialog box.4. Clear the 'Locked' check box by clicking inside it to...
How to Convert Wb3 Files to Xls
Quattro Pro Users1. Launch Quattro Pro.2. Go to 'File,' 'Open' and double-click the WB3 file you wish to convert.3. Go to 'File,' 'Save As' and choose 'Microsoft Excel 97/2000/2002/2003' from the drop-down list, then click 'Save.'Excel 97 or 2000 Users4. Download and install the Quattro Pro converter from Microsoft for Excel 97 or Excel 2000.5. Launch Excel.6. Go to 'File' 'Open' and select the WB3 file you wish to change into an XLS file.7. Go to 'File,' 'Save As' and choose 'Excel Workbook (*.xls)' from the drop-down menu, then click 'Save.'Excel 2003 Users8. Launch Excel.9....
How to Compare Cells in Excel
1. Open a new Excel worksheet. Enter or import the first set of data into column A.2. Enter or import the second column of data into Column C of the same worksheet. Leave Column B empty.3. Type this formula in cell B1: '=IF(ISERROR(MATCH(A1,$C$1:$C$#,0)),'',A1)', replacing # with the row number of the last value in column C.4. Select cells in column B, starting at B1 and dragging your mouse down to the cell that corresponds to the last row in columns A and/or C.5. Go to the Home tab, click on 'Fill,' then select 'Down' from the drop-down menu to finish comparing the cells. Any duplicate...
Thursday, October 18, 2012
How to Learn Microsoft Office Excel
1. Open up Excel on your computer. You'll be greeted with a fresh spreadsheet. Play around with the software by typing data into blank cells. To get a quick understanding of Excel, some people dive right in to the process. Not every person learns by reading a book, so get an idea of what you can do before moving on to tutorials. Excel shouldn't be seen as on-the-job drudgery. You can balance checkbooks, use it for taxes and even create word puzzles. You can find lots of games to play on websites such as www.willard.k12.mo.us/co/tech/msexcel.htm that will teach you the basics while having fun.2....
How to Remove Everything After a Character in Excel 2007
1. Start Excel 2007. Open the worksheet you want to use by clicking 'Open' in the menu linked to the round 'Office' button.2. Identify the cell you want to trim. The cell's name is a combination of the letters printed across the top row of the worksheet and the numbers printed at the leftmost column. By default, the first cell in your spreadsheet will be 'A1.' The currently selected cell is always listed just above the first row containing the cell labels.3. Choose a blank cell close to the cell you want to remove characters from and click on it to make it the currently active cell.4. ...
How to Change the Decimal Place in Cells in Microsoft Excel 2003
1. Highlight the cell in which you wish to change the decimal place. Simply left-click on that cell with your mouse.2. Access the cell-formatting menu. Scroll to the “Format” tab on the command bar and select “Cells.” A cell-formatting-properties box will open.3. Access the number submenu. Scroll to the “Number” section in the drop-down menu of the cell-formatting-properties box and left-click.4. Change the cell decimal place. A “Decimal Places” subsection will appear to the right. Click on the up and down arrows to modify the decimal places. Then click on 'OK' to implement these chan...
How to Fill an Excel Cell With Two Colors
1. Right-click the Excel cell you wish to format and select 'Format Cells.'2. Click the 'Fill' tab.3. Click 'Fill Effects' under the color picker section.4. Click 'Two colors' at the top-left, and choose the two colors from the right-hand drop-down menus.5. Select the 'Shading styles,' and view the preview to get the effect you want.6. Click 'OK' twice to exit both windo...
How to Calculate CPK With Excel
1. Launch Microsoft Excel and type “Data” in A1, “Upper Limit” in B1, “Average” in C1, “StDev” in D1, and “Cpk” in E1.2. Type “1” in A2, “2” in A3, “3” in A4, “4” in A5, “5” in A6, “6” in A7, “7” in A8, “8” in A9, “9” in A10, and “10” in A11. Type “15” in B2.3. Add the following formula in C2 to calculate the average for the data:=AVERAGE(A2:A11)4. Add the following formula in D2 to calculate the standard deviation for the data:=STDEV(A2:A11)5. Calculate CPK using the upper limit, average, and standard deviation values by adding the following formula in E2:=((B2-C2)/(3*D...
How to Do Name Badges With Microsoft Excel
1. Launch Excel. A blank spreadsheet will appear.2. Populate a column with names. If you want to include titles on the badge, populate a second column with this information. Click 'File' and select 'Save.' Give your list a name, and click 'OK.'3. Launch Microsoft Word.4. Click 'Tools.' Point to 'Letters and Mailings,' and click on 'Mail Merge Wizard.'5. Click 'Labels.' Select 'Label options.' Select your name badge size.6. Click 'Use an existing list' under 'Select recipients.' Click 'Browse.' Select the Excel file with your name badge information. Click 'Open.'7. Click your Excel...
How to Use VBA Userforms
1. Display VBA by choosing the 'Tools' menu, then 'Macro' and finally, 'Visual Basic Editor.' The VBA window appears.2. Choose the 'Insert' menu and 'Userform.' A blank userform with handles appears on the right and a 'Toolbox' window appears below that. A userform icon appears in the 'Project' window in the upper left. The 'Properties' window in the lower, left changes to display the userform properties. If these windows are missing, choose them from the 'View' menu.3. Resize the userform by clicking on a handle, holding down the left mouse button and dragging the handle.4. Rename the...
Wednesday, October 17, 2012
How to Create a Cumulative Frequency Distribution Chart in Excel 2003
1. Click cell A1 and type 'Class Limits'.2. Click cell B1 and type 'Frequency'.3. Click cell C1 and type 'cumulative frequency'.4. Type the class limits (categories) for your data in column A, starting in cell A2 and continuing down the column. Enter one set of class limits per cell. For example, if your study is about IQ scores you might have class limits of 0-50, 51-100, and 101-150. Type '0-50' in cell A2, '51-100' in cell A3 and '101-150' in cell A4.5. Type the frequencies in column B, starting in cell B2 and working down the column. A frequency is how often a particular item was...
How to Use Cells in Countif on Excel 2003
1. Run the Microsoft Excel application and open the worksheet that you wish to edit.2. Determine the cell addresses of the range that you want to count. For example, to count all instances of an object in the first 50 rows of column A you refer to cells A1:A50.3. Click a cell that you want to use to perform the COUNTIF calculation and display the observed value.4. Type the following in the cell:=COUNTIF(A1:A50, 7)Substitute the cell addresses of your range in place of 'A1:A50', and substitute the value that you wish to count in place of '7'. You can search for either a number value or...
How to Balance Your Checkbook Using Microsoft Excel 2010
Create a Register Template1. Open a new spreadsheet in Excel 2010. Leave cell A1 empty, and label the various columns you will need beginning in cell B1. Common examples of column headers to add to your spreadsheet include date, check number and transaction information. The last three column headers should be debit, credit and balance.2. Apply any desired formatting to your register. This includes changing font size and adding a colored background to your column headers so they stand out more. You should also adjust the size of the columns to compensate for the information that you will enter...
How to Define Cell Ranges in Excel 2003
1. Open Excel from the Start menu.2. Choose your cell range. For example, highlight 'F5' through 'F28.' (Letters represent columns while numbers represent rows.) To highlight cells, just click and drag. To select a group of cells that are not touching, click each cell separately and hold down the 'Ctrl' key.3. Click on the name box, which is directly above the 'A1' cell.4. Type the new cell range name. For example, on a schedule, you might name all the time that you are commuting to work 'Commuting.' Hit the 'Enter' key.5. Use the cell range names in your next formula. These names can...
Tuesday, October 16, 2012
How to Use the Freeze Pane Command in Excel to Create Static Headings
1. Open a spreadsheet file.2. To freeze the top horizontal pane, select the row below where you want the split to appear.3. To freeze the left vertical pane, select the column to the right of where you want the split to appear.4. To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.5. Open the Window menu and select Freeze Panes. When you scroll through the worksheet, the area you selected remains on the scre...
How to Format the Values of Vertical Axis Currency in Excel
1. Click and drag to select the cells for the vertical axis. To select the entire row or column, click the cell header.2. Click the 'Home' tab on the command ribbon.3. Click the down-arrow for the 'Accounting Number Format' button in the 'Number' group. This button displays a currency symbol. A list of currencies and symbols appears.4. Click the currency, such as U.S. dollar or the Euro.5. Click the arrow in the bottom-right corner of the 'Number' group. A window entitled 'Format Cells' opens.6. Click the 'Number' tab.7. Click the 'Currency' option. The selected currency appears...
How to Change the Orientation of Text in Excel Cells
1. Start Microsoft Excel and open the file you want to change.2. Select the cells in which you want to format the text.3. Open the Format menu and select Cells.4. In the Format Cells dialog box, select the Alignment tab.5. In the Orientation box, increase or decrease the number of degrees, or drag the indicator to the angle you want.6. Select OK to accept the chang...
How to Create a Drop Down Menu in Excel 2007
1. Switch to a different sheet in the workbook that is being used by clicking a tab on the bottom of the window. This helps prevent the list from being confused with a data-entry area.2. Type a list of items on the sheet using cells that are on top of one another (e.g., A1, A2, A3 and A4). Leave no spaces between the items and type them in the order that they should appear on the drop-down menu.3. Use the mouse to draw a box around the cells you used for the list.4. Click inside the text-entry box at the top of the screen, to the left of the formula area. To confirm that you have the correct...
Monday, October 15, 2012
How to Use the Excel Chart Wizard
1. Enter your data into an Excel spreadsheet.2. Start the chart wizard. Click on the 'Insert' button on the toolbar and then select 'Chart.'3. Select the type of chart you want from the 'Chart type' list in the chart wizard dialog box. Different versions of the chart you have selected will appear in the 'Chart sub-type' window on the right. Select one and click the 'Next' button.4. Examine the preview of your chart. The 'Data range' tab shows you the range of data from your spreadsheet that is being displayed in your chart. If you want to change the range of data or the labels, click in...
How to Calculate Time Cards in Excel
1. Go to 'Start,' 'Programs,' 'Microsoft Office' and 'Microsoft Excel.' If you have used Excel recently, go to 'Start' and 'Microsoft Excel.' Click 'New' to open a new document.2. Go to 'Timesheets,' click on 'Weekly timesheets with breaks,' then click on 'Download' at the lower right-hand corner of the screen. The time card will have a place for the Company name, time in and time out.3. Enter '9:00 AM' in the 'Time In' cell (E11) for Sunday. Enter '12:00 PM' in the 'Time Out' cell (E12) for Sunday. The total hours calculated before the break is 3.00.4. Enter '1:00 PM' in the second 'Time...
How to Make a Fitness Chart
Excel 20101. Click the 'File' tab and select 'New.' Type 'Fitness chart' in the search box. View the available fitness charts. Download the chart by clicking the chart image and the 'Download' icon.2. Replace the default measurements in the spreadsheet with your measurements. Review the available tabs on the bottom of the spreadsheet and click the 'Chart' tab. Depending on the template, the tab may be called 'Measurements' or something similar.3. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar.Google Documents4. Access the Google Documents website. Type 'Fitness...
How to Disconnect a User From a Shared Workbook
1. Click on the 'Review' tab in Microsoft Excel. Select 'Share Workbook' in the 'Changes' section.2. Click the 'Editing' tab. Review the listing of user names under 'Who Has This Workbook Open Now.'3. Click to highlight a user's name. Click on the 'Remove User' button.4. Click the 'View' tab. Select 'Custom Views' in the 'Workbook Views' group.5. Click to highlight a user's name in the 'View' list. Click the 'Delete' butt...
How to Create a Pie Chart in Excel
1. Launch Excel and open the file which has the data that you want to base your pie chart on. The data can be created by simply entering the numbers, formulas, or by calling it in from other programs.2. Highlight the data that you wish to base your chart on. The last cell that you wish to include will not be highlighted but it will have a bold outline around it.3. Click 'Insert', 'Chart' and a Chart Wizard window will appear. Scroll down the right side column of Chart Type and click on 'Pie.' This will bring up several sub-types of pie charts on the left hand side of the window. Pick the...
How to Use the Chart Wizard in Access to Create a Chart
1. Open the Access database. Right-click the report or form to which you want to add a chart, and select 'Design View' to open it in Design View, which is a window showing the underlying design of your form or report that displays the details and properties of the boxes, buttons and other items in your object. Using Design View makes it easier for you to make changes to the way an Access object looks and acts.2. Go to the 'Insert' menu and click 'Chart' in Access 2003. Click the 'Chart' button in the 'Controls' group of the 'Design' tab in Access 2007 or 2010. Click on the form or report where...
How Do You Limit the Number of Rows in an Excel Spreadsheet?
1. Open Microsoft Excel from the 'Start' menu.2. Press 'Alt' and 'F11' at the same time to open the visual basic editor.3. Click 'View' on the top toolbar then select 'Project Explorer' from the drop down menu.4. Click 'View' again then select 'Properties Window' from the drop down menu.5. Select the name of the spreadsheet you are working with from the list in the explorer window on the left side of the screen.6. Change the value in the 'ScrollArea' category to limit the number of rows allowed on the spreadsheet. For example, in order to limit the spreadsheet to 365 rows, you would...
Sunday, October 14, 2012
How to Train in Microsoft Excel 2007
1. Talk to your employer. If you need to use Microsoft Excel 2007 for work, your employer may have a training program in place or may be willing to start one to help train employees.2. Work with your instructor. If you need to use Microsoft Excel 2007 for a class, your instructor may be able to help you understand what you need to know to complete assignments. Tutoring services might also be available through your school.3. Go through the Microsoft Excel 2007 intermediate level tutorial. This is a free service offered by Microsoft that takes you through all the basic functions of Excel and...
How to Use VBA to Save in Excel As a PDF
1. Double-click the Excel file name from My Documents or Windows Explorer, or launch Excel and use the 'Open' command from the start button. Browse to your file and click 'Open.'2. Press the 'Alt' and 'F11' keys simultaneously to open the Visual Basic editor. Use the Project Explorer to browse to the module where you need to automate saving the spreadsheet as a PDF file. Place your cursor in your Visual Basic code where you want the save to occur.3. Use the 'ExportAsFixedFormat' function to perform a 'Save to PDF.' This function can be invoked from any worksheet (e.g., ActiveSheet.ExportAsFixedFormat)...
How to Put a Check Box in Excel 2003
1. Open the specific Excel 2003 worksheet that needs to have a check box added. Locate the 'Forms' toolbar at the top of the screen, which shows a series of boxes corresponding to different forms available to be created.2. Click the 'Check Box' icon in the 'Forms' toolbar, which shows a square blue box with a black check mark. Click the starting point anywhere inside the spreadsheet where you want the check box to appear. Drag your pointer down and toward the right to set the borders of the check box. Release your mouse button to create the check box.3. Click the 'Check Box 1' text appearing...
A Line Won't Delete in Microsoft Excel
1. Check to see if you are highlighting the correct line to delete in your document. Point your cursor on the line number on the right side and left-click to highlight. Once highlighted, you should be able to delete the line.2. Remove any document protections. If the Excel document is protected, this may prevent editing including removal of lines. On the 'Review' tab, click to see 'Changes' group to see if there are protections on the worksheet or workbook. These may have to be removed or a password inserted to continue.3. Investigate the explanation of any error messages you receive when...
How to Make a Graph on Excel 2003
1. Open the spreadsheet you want to graph in Excel 2003. Select 'Insert' and 'Chart' from the toolbar. The chart wizard appears.2. Select the type of chart you want to create in the 'Standard Types' tab. To see a sample of how the chart will look, click the 'Press and Hold to View Sample' button and click 'Next.'3. Click the button on the right of the 'Data range' text box to select the area of your spreadsheet you want to graph. The 'Source Data - Data range' toolbar appears.4. Drag your mouse over the area of your spreadsheet that will be graphed.5. Click the button on the right of...
Saturday, October 13, 2012
How to Edit a Calculated Field PivotTable
1. Open Excel 2010 and open a workbook containing a PivotTable.2. Click the worksheet containing the PivotTable. Click the PivotTable. The PivotTable Tools Tab appears. Click the 'Options' tab and 'Fields, Items, and Sets.' Select 'Calculated Field.' Your calculated fields are displayed.3. Select the calculated field formula that you want to edit. Click the 'Formula' box and select 'Modify.' Edit the formula and click 'OK.' Your calculated field is edited in your PivotTab...
How to Use Excel's ZTEST Function
1. Learn the syntax for the ZTEST function. It is: ZTEST(array,u0,sigma) where array of data to test the given value against, u0, is the given value to test and sigma is the known standard deviation. ZTEST returns the #N/A error value if array is empty.2. Calculate ZEST when sigma is supplied as follows: ZTEST(array,u0) = 1 - NORMSDIST(x - u0)/(sigma/square root of n)).3. Substitute the sample standard deviation if sigma is omitted as follows:ZTEST(array,u0) = 1 - NORMSDIST((x - u0)/(s/square root of n)).4. Note that x is AVERAGE(array)), s is the known standard deviation and n is the...
Friday, October 12, 2012
How to Use Excel to Make a Queue
1. Open a new Excel 2010 spreadsheet. Click the 'File' tab at the top of the screen and choose 'Options' on the left side of the screen. Select 'Customize Ribbon' from the left side of the new window. Find the 'Developer' listing on the list on the far right side of the window. Click the check box next to 'Developer' to add a check and click 'OK.'2. Select cell 'A1' and type in 'Name.' Select cell 'B1' and type in 'Time.' Click the 'B' at the top of the second column. Right-click anywhere in the column and choose 'Format Cells.' Select 'Time' from the list on the left side of the window. Select...
Thursday, October 11, 2012
How to Password
Microsoft Excel 20101. Open Microsoft Excel 2010.2. Click 'File' on the top menu bar. Choose 'Info.'3. Select the option to 'Protect Document.' Choose 'Encrypt with Password' from the list.4. Enter a password. Click 'OK.' Retype the password. Click 'OK.'Microsoft Excel 20075. Open Microsoft Excel 2007.6. Click the 'Microsoft Office' button. Select 'Prepare' from the list. Choose 'Encrypt' from the menu.7. Enter a password. Click 'OK.' Retype the password. Click 'OK.'Microsoft Excel 20038. Open Microsoft Excel 2003.9. Click 'Tools' on the top menu bar. Choose 'Options' and then...
How to Create a Check Box in Excel 2007
1. Open Microsoft Excel 2007.2. Click the 'Office' button located in the left corner of the window represented by the Microsoft Office Logo.3. Click 'Excel Options' located along the bottom of the menu on the right.4. Click the tab titled 'Popular' and select the check box next to 'Show Developer tab in the Ribbon.' Click 'OK' when you have finished to exit.5. Click the 'Developer' tab along the Office menu. Click 'Insert' and select the check box from the set of options.6. Click-and-drag your mouse to draw the check box to your desired si...
How to Alphabetize a Listing in Excel 2007
1. Click on the Start button on the lower left-hand side of your screen. Point to All Programs at the bottom, to Microsoft Office, and then click on 'Microsoft Office Excel 2007.'2. Click on the top-left circular Microsoft button and click on the second option, Open. Search for the excel spreadsheet you want to sort alphabetically on the left hand panel and double-click the folder it is located in with the main, right-hand panel. Double-click on the file name and click on Open.3. Determine if the column of text you want to sort alphabetically corresponds to the any or all of the columns...
Subscribe to:
Posts (Atom)