1. Open a new Microsoft Excel 2010 spreadsheet. Click on the top-left cell in the spreadsheet.2. Type your data set into the first column of cells. Each number should have its own cell.3. Click on cell 'B1.' Type in '=quar' to open a pop-up menu with three options. Double-click 'Quartile.exc' to use the newer version of the quartile function. Double-click 'Quartile.inc' to use the older version of the function. If you need this worksheet to work with earlier versions of Excel, double-click the 'Quartile' function. 'Quartile' and 'Quartile.inc' are the same, but only 'Quartile' works on earlier...
Browse » Home » All posts
Monday, November 28, 2011
How to Create a Calendar Using Excel
1. Open Microsoft Excel. Click on the 'Tools' menu, point to 'Macro' and click on 'Visual Basic Editor' if using Excel 2003 or earlier. For Excel 2007/2010, click on the 'Developer' tab and then click on 'Visual Basic.' If you don't see the 'Developer' tab, click on the 'Office' button and then 'Excel Options.' On the first screen, click on the check box next to 'Show Developer tab on the Ribbon' and then click 'OK.' The 'Developer' tab should show now.2. Click on the 'Insert' menu item in the Visual Basic Editor. Click on 'Module' to start a new code module.3. Copy the first part of the...
Sunday, November 27, 2011
How to Change the Text Orientation in Cells in Excel 2003
1. Open your Excel worksheet.2. Select the text cells you wish to change. Hold down the left mouse button and drag across the cells or hold the 'Ctrl' key down as you click on individual cells.3. Click 'Format' on the top menu to access the dropdown list of formatting options.4. Select 'Cells.' A new window will appear with cell formatting options.5. Click on the 'Alignment' tab for options on how to align and orient text in your cells.6. Under 'Orientation,' change the angle of your text cells until they are oriented.7. Click 'OK' to implement your changes. Then save your wo...
How to Change the Cursor in Microsoft Excel
1. Open Excel.2. Navigate around the spreadsheet. The mouse cursor remains as a white plus sign whenever the cursor is located over a cell in any of the program's rows or columns.3. Hover the mouse over a cell that is currently selected to change the cursor to other designs that reflect certain actions. Selected cells have a dark black border around them, and their contents are also displayed in the program's formula bar above the spreadsheet grid. When the mouse is placed along any of the cell's borders, it turns to a quadruple arrow. When displayed, this cursor may be clicked and dragged...
Saturday, November 26, 2011
How to Group and Outline Data in Microsoft Excel 2003
1. Select the data that you wish to group and outline. The fastest way to select data for this operation is by clicking and holding the mouse button as you drag the cursor over the desired data and highlight it; release the mouse button when you are finished and the data will remain highlighted.2. Access the 'Group and Outline' menu. Scroll to the “Data” tab on the command bar and select “Group and Outline Data.”3. Group and outline the data. From the submenu that opens, scroll to and select “Group Data.” This will group the data and outline the rows and columns of the data that you just...
How to Calculate Payback on Excel
1. Open a new Microsoft Excel worksheet and type 'Initial Investment' in cell A1. Put the cost of the project in cell B1. For example, assume a project costs $500.2. Type 'Annual Cash Inflows' in cell A2. Put your estimated cash inflows each year in cell B2. In the example, assume you receive $60 a year from the project.3. Type 'Payback' in cell A3.4. Type '=B1/B2' in cell B3. In the example, B3 will say 8.333333333. The project will take about eight years and three months to cover its cos...
How to Change the Background Color in MS Excel
1. Select the cell or cells in which you wish to change the background color. In Excel 2007, click on the 'Home' tab to view the 'Home' ribbon.2. Click on the arrow next to the paint bucket icon in the 'Font' section. This is the 'Fill Color' button. In Excel 2003, the paint bucket icon is located in the 'Formatting' toolbar. This toolbar is typically located just above the actual spreadsheet and under the main menu.3. Select the color you want from the menu that appears. If the color you want is not in the menu, click on 'More colors.' Under the 'Standard' tab you can select from a larger...
Friday, November 25, 2011
How to Restore Data on Microsoft Excel
1. Run 'Detect and Repair' if you are using Excel 2003 or earlier. Go to the 'Help' menu and select 'Detect and Repair.' Clear the checkboxes and click start. Detect and Repair will scan the program and make certain repairs, which may restore the missing data.2. Run 'Diagnostics' in Excel 2007. Start Excel and click the 'Office Button.' Select 'Excel Options.' Select 'Resources,' 'Diagnose,' and then 'Continue.' Click on 'Start Diagnostics.' Diagnostics will scan Excel for potential problems and repair what it can.3. Recover data when Excel stops responding. Go to the 'Start' menu, point...
How to Create Spread Sheets in Excel 2007
1. Click on the 'Office' button. This is the round button with the Microsoft logo at the upper left-hand corner of the ribbon menu.2. Click 'New' to create a new spreadsheet.3. Click on the icon for 'New Blank Workbook' in the center pain of the menu that pulls up. If there is no icon for 'New Blank Workbook,' make sure that 'Blank and Recent' is highlighted. You can also click on the button at lower right that reads 'Creat...
How to Calculate Time Duration in Excel 2007
1. Format the relevant cells as time by selecting them and choosing 'Time' from the Number group drop-down menu in the Home tab.2. Enter a start time and an end time in different cells, such as the start time in cell A1 and the end time in cell B1. Ensure Excel hasn't misinterpreted either time, such as making '9:15 pm' read '9:15 am.' If necessary, type 'am' or 'pm' after the times or use a 24-hour clock, typing '21:15' instead of '9:15 pm.' Investigate Excel's Help menu on 'time of day' if necessary to learn more about these formats.3. Subtract the start time from the end time to calculate...
How to Learn Excel 2007
1. Purchase a copy of Microsoft Excel or download a 60-day free trial of Microsoft Office Professional, which includes Excel 2007.2. Visit the Microsoft Office website to access dozens of free online Excel 2007 training courses. Take the free 40-minute course called 'Up to speed with Excel 2007.' This course teaches the basics, such as how to use common commands and save workbooks. Take the test at the end of the course to assess how much you have learned.3. Take the online Excel course called 'Get to Know Excel 2007: Create your first workbook.' The course will teach you how to create a...
How to Install Analysis ToolPak for Excel 2003
1. Open any Excel document.2. Navigate to the 'Tools' menu. Click on 'Add-Ins.'3. Select the check box next to Analysis ToolPak under 'Add-Ins.' Click 'OK.'4. Click 'Yes' to install Analysis ToolPak if you see the message 'Analysis ToolPak is not currently installed on your computer.' Analysis ToolPak will be installed.5. Click on 'Tools' under the menu bar. Open a new Excel document. You will see that the data analysis command listed, which indicates the program has been added proper...
How to Combine Column and Scatter Charts in Excel
1. Open the Excel worksheet with the data you wish to chart.2. Click and drag the cursor to select the data series and the categories.3. Click the “Insert” tab on the command ribbon.4. Click the “Column” menu to display a gallery of column thumbnail images.5. Click the preferred image. The worksheet data converts to an embedded column chart.6. Right-click on one data series in the plot area that you wish to convert to a scatter chart.7. Click the “Change Series Chart Type” option. The “Change Chart Type” dialogue window opens with a gallery of chart images.8. Click the “X Y (Scatter)”...
How to Change the Order of the Legend in an Excel Chart
1. Right-click on one of the names listed on your legend.2. Click on the 'Select Data' option from the list that appears.3. Click on the entry you want to move in the 'Legend Entries (Series)' box.4. Click the 'Up' or 'Down' arrows in the box to change the position of the legend. Click 'OK' when finished to save your chang...
How to Create a Searchable Database in Excel
1. Type the following data into a new spreadsheet, pressing 'Tab' in place of the commas. This data is for a hypothetical art supply store. Click your mouse on the data's top left cell, then drag down to the bottom right cell to select the data. Type 'ArtProducts' in the left text box above the worksheet grid. This action names the table, which makes it easier to identify in database queries.product, pricepaintbrush, 1.98Gesso, 3.452. Click the 'File' menu's 'Close' command, then click 'OK' to indicate you want to save the workbook. Type 'ArtProduct' for the file name, then click 'Save' to...
Subscribe to:
Posts (Atom)