How to Do Stacked Charts in Excel

1. Enter the data for the stacked chart into an Excel spreadsheet. Clearly label the data in the first row so that it is easier to identify when you are making the chart.
2.
Highlighting the data tells Excel which data to include in the chart.
Highlight the data you want to include in the stacked chart. Include the data labels (typically placed in the first row). You can highlight by clicking your left mouse button, holding it down, and dragging to include all pieces of data. Alternatively, to include the entire spreadsheet in the chart, press 'Ctrl-A' to highlight everything.
3. Open the chart interface. In Excel 2007, click the 'Insert' tab, then click the down arrow under Column, and click 'All Chart Types.' In Excel 2010, click the 'Insert' tab and click 'Chart.'
4. Choose the chart type by clicking or scrolling to the corresponding section. The most common type of stacked chart is column, but you may also choose bar.
5. Choose stacked chart style by clicking the corresponding stacked style under the chart type. Verify that the style you have chosen is stacked by hovering over it and looking for 'stacked' in the tool tip description. Choose a 100 percent stacked style if you want all bars to be full and display the composition breakdown. Choose the style that most clearly displays your data and fits your taste.
6. Press 'OK' and verify the data.

Read more ►

How to Audit Formulas in Excel 2007

1. Open an existing Microsoft Excel document to audit. Double click on the 'My computer' icon on the operating system desktop. Then locate the existing Excel document and double click on that file.
2. Select the 'Microsoft Office Main Menu Button' located in the top right hand corner of Microsoft Excel. From that menu click on the 'Excel Options' button located at the bottom of the menu dialogue box.
3. Click on the 'Advanced' options button on the Excel options dialogue box.
4. Check all the options under the 'Display Options for This Workbook' section. Also, make sure that the 'For Object: Show' option choose 'All.'
5. Show all the formulas in an Excel worksheet by selecting all the cells. Do this by clicking on the top left hand corner of the worksheet. Once they are all selected click on the 'Formulas' tab and choose 'Show All Formulas' from the formula auditing section of the formulas tab.
6. Audit the formulas by choosing the 'Error Checking' button in the formula auditing section of formula ribbon. A user can also trace dependents and precedents by choosing the 'Trace Dependents' and 'Trace Precedents' option from the very same section of the formula auditing section of the formulas ribbon.

Read more ►

How to Subtract Dates in Excel 2007

1. Open Excel 2007 and enter the current date in cell A1. Enter another date in cell B1.
2. Highlight cells A1 and B1. Click the 'Home' tab and locate the 'Numbers' group. Change the number format to 'Short Date.'
3. Click cell C1 and enter a subtraction formula. Enter 'A1-B1.' Press the 'Enter' key to see the results.

Read more ►

How to Create a Toggle Switch in Excel 2003

1. Open Microsoft Excel 2003. Click the 'Microsoft' button on the top left corner of the window. Click the 'Excel Options' button in the lower right corner of the dropdown menu.
2. Click the 'Popular' tab. On the box to the right, check the 'Show Developers tab in the Ribbon' box. Click the 'OK' button on the bottom right of the window.
3. Click the 'Insert' button in the top center of the window. Click on the 'Toggle' button on the bottom right corner of the dropdown menu.
4. Click the left mouse button anywhere on the screen. The toggle button appears. Click and hold the left mouse button on the 'Toggle' button to move it. Your toggle switch is now created.

Read more ►

How to Merge Two Macros in Excel

1. Create a master macro by clicking on the 'View' tab in the toolbar. Click on 'Macros' and select 'View Macros.' Type the name of the master macro, such as 'Master,' in the 'Macro name' box. Click on the 'Create' button to launch the Visual Basic editor.
2. Place the cursor in the second line under the subroutine. For example, if the name of the macro you created is 'Master,' the first line is 'Sub Master().' Under this line, type 'Call,' followed by the name of the first macro you would like to run. For example, if you created a macro called 'GetWebQueries' that loops through a list of URLs, opening each one and copying and pasting the data from a table into a new worksheet, you would type 'Call GetWebQueries().'
3. Press 'Enter' to go to the next line. Type 'Call,' followed by the name of the second macro, such as 'Call Format(),' which would run the Format macro that formats each worksheet in a specified manner. Save the macro and close the Visual Basic editor.
4. Run the master macro by clicking on the 'View' tab. Click on 'Macros' and select 'View Macros.' Select the master macro and click on the 'Run' button. The master macro will run 'GetWebQueries' and the 'Format' macros in the specified order.

Read more ►

How to Filter Excel for Duplicate Names

1. Open your Excel spreadsheet.
2. Select one or more columns in which you suspect there are duplicate values.
3. Click on the 'Data' tab at the top of the screen, then the 'Remove Duplicates' icon.
4. Check the boxes with suspected duplicates in the dialog box that opens.
5. Click 'OK.' Another box will appear, telling you how many duplicates have been removed and how many unique values remain.

Read more ►

How to Remove All the Blank Rows in Excel 2007

1. Open Excel 2007 and select a workbook. Select the 'Office' button and click 'Open.' Search your network for the workbook. Click the workbook and select 'Open.' The workbook opens.
2. Select the first column header in your workbook. Select the 'Home' tab and click 'Filter' from the 'Sort Filter' button in the 'Editing' group. Notice the dropdown icons that appear in your column headers.
3. Select a column header that may contain blank data. Click the dropdown icon. Scroll down in the list and locate 'Blanks.' Remove the check. The blank rows from this column are removed.
4. Repeat this step for each column that may contain blank data. Once you have done this for each affected column, all of the blank rows will be removed from your Excel 2007 workbook.

Read more ►

How Do I Count Distinct Records in an Excel Pivot Table?

1. Add a column to the database with which you are working; give it a text heading of your choice and add this field to your pivot table.
2. Enter the following formula in the first cell of the column you created:=IF($A$2:$A2=A2)>1,0,1)where A is the column which you are searching and 2 is the first row of data in your pivot table.
3. Copy the formula down the entire column you created and the cells in that column will display the number of distinct records in that row.

Read more ►

How to Combine Contents of Two Rows of Cells in Excel 2007

1. Click the 'Start' button from the desktop on your computer, and then click the 'All Programs' option. Select the 'Microsoft Excel 2007' application from the list of programs.
2. Click the 'Microsoft Office' button from the top right corner of the program followed by the 'Open' option. Select the Excel 2007 worksheet file you want to combine cells with, and then click the 'Open' button.
3. Select the two rows of cells that you want to combine with your mouse. The cells should be highlighted.
4. Select the 'Home' tab, and then click the 'Merge and Center' option from the 'Alignment' group. The cells will then be merged together.
5. Click the 'Merge and Center' button again at any time to split the merged cells if you no longer want the contents to be combined.

Read more ►

How to Hide/Unhide in Excel 2007

1. Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet.
2. Select a cell within the row or column you wish to hide. Click on the 'Cells' group and choose 'Format'.
3. Go to the 'Visibility' section and choose 'Hide' or 'Unhide' from the menu.

Read more ►

How to Make a PERT Chart in Excel

1. Launch Microsoft Excel 2010.
2. Click 'Insert' at the top of the window.
3. Click the 'Shapes' drop-down menu in the Illustrations section of the ribbon. Select your desired shape from the Flowchart section.
4. Click your mouse at the location in the spreadsheet where you wish to insert the object, and then drag the mouse until the outline of the shape is the desired size.
5. Click the 'Text Box' option in the Insert Shapes section of the ribbon. Click inside the shape you just created and use your mouse to draw a text box inside the shape. Note that you can also click a color for the shape from the Shape Styles section of the ribbon.
6. Type the necessary text for the object.
7. Insert additional shapes from the Shapes drop-down menu on the Insert tab, and then add text boxes to each shape as needed.
8. Click your desired connector arrow from the Insert Shapes section of the ribbon.
9. Click the shape that will serve as the anchor for the arrow, and then drag the arrow to the target shape for the arrow.
10. Add additional arrows to your chart as needed.
11. Add outlying text to your chart by clicking the 'Insert' tab at the top of the window and then clicking the 'Text Box' button in the Text section of the ribbon.
12. Click in the desired location on your spreadsheet for the text box, and then drag the mouse until your desired text box shape is displayed.
13. Type your text into the text box.
14. Add additional text boxes to your chart until the chart is complete.

Read more ►

How to Create a Microsoft Calendar

1. Open Microsoft PowerPoint, Word, or Excel. In PowerPoint, Word or Excel 2010, select 'File' and 'New.' In PowerPoint, Word or Excel 2007, click the Microsoft Office button on the ribbon and select 'New.'
2. Select the 'Calendars' heading under Office Online templates to find a template type. A list of calendar templates will appear. The calendar templates in PowerPoint and Excel 2010 and 2007 include calendars from 2007 to 2010, academic calendars and even an Advent calendar. Word 2010's templates also include 2011 calendars.
3. Click on the calendar type you want and, within the calendar types, select a specific template design by double clicking it to begin the download. The download will automatically begin without leaving the application.
4. Customize your calendar. In PowerPoint you can change colors and font themes by going to the 'Design' tab and selecting a different design template. In Word and Excel, theme changes are made from the 'Page Layout' tab. The new design theme will apply to the entire calendar.
5. Add in text and graphics. Insert birthdays, social gatherings and appointments by positioning your cursor to the appropriate day and start typing. You can select the 'Insert' tab to place photos, pictures or clip art in your calendar. All graphics can be moved and resized as you desire. Customization can be made from month-to-month and printed as 'current page only' for month by month printing or in its entirety as a wall calendar.

Read more ►

How to Import Excel Into MS Word

1. Select the data in Excel you want to import into Word. Press 'Ctrl-C' to copy the data. You can also right-click on the selected data and click 'Copy' from the context menu.
2. Select the location in your Word document to enter the copied data. Click the 'Paste' drop-down menu and select 'Paste Special.'
3. Select the 'Paste link' radio dial, choose 'Microsoft Excel Worksheet Object' from the list and click 'OK.'
4. Adjust the formatting of the new table to meet your needs.

Read more ►

How to Link Bloomberg to Excel

1. Close Excel. Download the Bloomberg Excel add-in (www.bloomberg.com). Click the 'Download' link, which will open a separate window. Click the 'Run' button.
2. Install the Bloomberg Excel add-in. Click the 'Start' button and select the 'All Programs' option. Click 'Bloomberg' and select 'Install Excel Add-In,' which will open a separate window.
3. Click the 'Install' button and then close the window when the installation process has completed. Open Excel to view the 'Bloomberg' tab on the menu bar.

Read more ►

How to Use Data Analysis in MS Excel

Excel 2007
1. Open Excel and navigate to a blank or existing spreadsheet file. Locate the Data Analysis tool by clicking the 'Microsoft Office' button, located in the top left-hand corner of your open spreadsheet. This opens a menu with a series of commands. Click the “Excel Options” button at the bottom of this menu.
2. Choose the “Add-ins” option, located in the column on the left side of the Excel Options menu. This will display a set of available add-ins that can be installed in your Excel program. Click the “Analysis ToolPak” add in, which often appears first on the list of add-ins. After selecting this add-in, click “OK.” The Data Analysis tool should appear in your Excel 2007 tool bar, located at the top of an Excel workbook file.
3. Select the Data Analysis tool to analyze a set of data in Excel by clicking the tool in your toolbar. This will open a smaller window that displays a set of statistical procedures and analysis tools.
4. Select the analytical procedure you want by clicking on it, then choosing “OK.” This will take you to the window for that procedure. Here you must specify the range of data you want analyzed by clicking and dragging across the cells, rows or columns that contain the data.
5. Indicate whether you want your results displayed on the same worksheet, in a new worksheet or in a new workbook by choosing the appropriate option. Click “OK.” Excel will then run the analysis and display the results in the manner you selected.
Earlier Versions of Excel
6. Unlock and install the data analysis tool by clicking the “Tools” menu, found in the toolbar at the top of an open Excel workbook file. This will display a drop-down menu of available options.
7. Select “Add-ins” from the Tools menu. This opens a small menu that displays the add-ins that can be installed for use. Choose 'Analysis ToolPak' by clicking the check box next to it, then click “OK.” The tool “Data Analysis” should then appear in the Tools drop-down menu, ready for use.
8. Select the Data Analysis tool to analyze a set of data in Excel by clicking the tool in your toolbar. This will open a smaller window that displays a set of statistical procedures and analysis tools.
9. Select the analytical procedure you want by clicking on it, then choosing “OK.” This will take you to the window for that procedure. Here you must specify the range of data you want analyzed by clicking and dragging across the cells, rows or columns that contain the data.
10. Indicate whether you want your results displayed on the same worksheet, in a new worksheet or in a new workbook by choosing the appropriate option. Click “OK.” Excel will then run the analysis and display the results in the manner you selected.

Read more ►