How to Nest Subtotals in Excel 2003

1. Click and drag your mouse to highlight the three columns---two columns of headings and the third of values.
2. Click the toolbar's 'sort' button. The Sort window will open.
3. Sort the table first by the first column and then by the second column.
4. Click 'Subtotals' from the Data menu.
5. Click the down-arrow in the 'At each change in' drop-down box. Click the first column's heading.
6. Click 'Sum' in the 'Use function' box.
7. Click the down-arrow in the 'Add subtotal to:' drop-down box. Click the third column's heading.
8. Click 'OK.'
9. Click and drag your mouse to highlight the three columns again. Click 'Subtotals' from the Data menu.
10. Click the down-arrow in the 'At each change in' drop-down box. Click the second column's heading.
11. Click 'Sum' in the 'Use function' box.
12. Click the down-arrow in the 'Add subtotal to:' drop-down box. Click the third column's heading.
13. Uncheck the 'Replace current subtotals' box.
14. Click 'OK.'

Read more ►

How to Change the X

1. Open Excel and navigate to the chart for which you wish to change the x-axis range.
2. Move your cursor so that it is directly over the x-axis of the chart, and right-click with your mouse.
3. Select 'Format Axis...' from the menu that appears. The Format Axis dialog box will open.
4. Click so that 'Fixed' is selected instead of 'Automatic' for both the Minimum and Maximum under Axis Options.
5. Select the values you wish to use as the minimum and maximum for the x-axis and enter them in the appropriate boxes. Click 'Close' to finish.

Read more ►

How to Add Headers and Footers to Excel Documents

1. Start Microsoft Excel and open the file you want to change.
2. Open the View menu and select Header and Footer option.
3. In the Page Setup dialog box, click the Custom Header or Custom Footer button.
4. Click inside the Left section, Center section or the Right section.
5. Click the A icon to change the font styles.
6. Click the # icon to insert page numbers.
7. Click the icon to insert the number of pages in the document (so if you wanted the header or footer to read 'Page X of 25,' you'd click the # icon followed by the icon).
8. Click the date, time, file name or tab icon to insert those items.
9. Click OK to accept the changes.

Read more ►

How To Copy Name Ranges in Excel 2003 to Another Workbook

1. Open the workbook you will be copying the range names from. If you do not already have the names set, define the range names. To do so, click on the 'Insert' menu, select 'Name' and then choose 'Define' from the list. Find the names in the workbook box.
2. Locate the name of the second workbook. Make sure that workbook is saved as a Macro-enabled Workbook. The file extension should be .xlsm or .lsm.
3. Hold down the 'Alt' and 'F11' keys. The Visual Basic Editor will open. Click 'Module' in the 'Insert' menu. The module window will pop-up.
4. Type the following code into the window. Change the reference to book2.lsm or book2.xls to the name of the book you are pasting too.Sub Copy_All_Defined_Names()' Loop through all of the defined names in the active' workbook.For Each x In ActiveWorkbook.Names' Add each defined name from the active workbook to' the target workbook ('Book2.xls' or 'Book2.xlsm').' 'x.value' refers to the cell references the' defined name points to.Workbooks('Book2.xls').Names.Add Name:=x.Name, _RefersTo:=x.ValueNext xEnd Sub
5. Close the Visual Basic Editor Window. Click on the 'X' button or hit 'ATL' and 'F11' again to close the window. The macro will automatically save. When you are back at book 1 or the workbook you are copying from, save the workbook. Click on 'File' and choose 'Save' or 'Save as.' Do not change the name of the file in any way.
6. Open the workbook you are pasting to or start a new workbook. Save the workbook as an Excel Macro-Enabled Workbook. Make sure the name is the same as the name for book2.lsm in the code. The spelling capitalization and extension have to be exact.
7. Open the first workbook again and click on the 'tools' menu. Select 'Macro' and click 'Macros.'
8. Click on 'Copy_All_Defined_Names' from the list of macros. Select the 'Run' option. The names will be automatically pasted in the second workbook.
9. Open Book2 or the paste destination workbook. All the names should be pasted.

Read more ►

How to Merge Information From Several Excel Spreadsheets

1. Open the workbook with the spreadsheets you want to consolidate. If you the spreadsheet is not in the workbook, create a duplicate spreadsheet within the workbook by doing a copy and paste.
.
2. Chose Data and then Consolidate. Excel displays the Consolidate dialog box.
3. Specify the range with the Reference box. After you specify the range (or the area of cells on the spreadsheet you want to consolidate) click Add. The reference will appear in the All References list. Continue to add ranges until you have added them all.
4. Click on the Create Links to Source Data box if you want the consolidated data to contain links to the original data. If not, leave blank and click OK to do the consolidation.

Read more ►

How to Create a Bar Graph in Excel 2003

1. Log on to your computer and pull up your Excel worksheet. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Arrange desired data in columns or rows. You only need to enter the numbers at this time.
3. Highlight the cells containing desired data. To select separated data, highlight the first piece. Then hold 'Ctrl' while clicking on the remaining data.
4. Select 'Chart' from the 'Insert' menu or click on the 'Chart Wizard' icon on the toolbar.
5. Choose your chart type. Click 'Next'. Confirm the data range mentally and select if you want your series in rows or columns. Select 'Next'.
6. Enter titles for your chart and axis. Choose the location of your chart. Select 'Finish'.

Read more ►

How to Hide Unhide Cells in Excel

Hide Cells
1. Select the cells you want to hide.
2. Click the 'Format' tab and then click 'Format Cells.'
3. Click the 'Number' tab.
4. Click 'Custom' from the Category List.
5. Type three semicolons ';;;' into the 'Type' text box and then click 'OK.' The cell data will be hidden.
Unhide Cells
6. Reopen the Format Cells dialog box.
7. Delete the semicolons in the Type box.
8. Click 'OK.'

Read more ►

How do I Convert Exel 2007 to 2003?

1. Open Excel 2007 and open an existing Excel 2007 spreadsheet. Select the 'Office' button then 'Open.' Browse your computer for files saved in the .xlsx format. Select the file and click 'Open.' The file with the new Excel 2007 naming format will open.
2. Select the 'Office' button then select 'Save As.' Select the format of 'Excel 97-2003.' If any conflicts appear, the Compatibility Checker will display any losses of fidelity and how many times this has occurred. Click 'Find' to see where these instances occur or 'Help' to see how to work around these issues.
3. Click 'Continue' once you are satisfied with the adjustment made from the Compatibility Checker. Excel 2007 will save this workbook in the older .xls format. Upon successfully saving this workbook, you have converted it to the 2003 format.

Read more ►

How to Remove Lines Around Each Cell in Excel 2003

1. Open Microsoft Excel 2003.
2. Click 'Tools' in the top menu bar and select 'Options.'
3. Click the 'View' tab in the Options window.
4. Uncheck 'Gridlines' in the Windows Options section.
5. Click 'OK' to apply your changes and remove the gridlines.

Read more ►

How to Print Multiple Excel Spreadsheets on One Page

Changing the Printer Settings
1. Select 'Print' from your Microsoft Excel's File menu to display the Print dialog box.
2. Choose the option for 'Entire Workbook' in the dialog box's 'Print What' area.
3. Click the 'Properties' button for Excel to display its 'Properties' dialog box for your printer, along with the selected 'Layout' tab.
4. Set the 'Pages Per Sheet' control depending on how many spreadsheets you want printed on the page. Click 'OK' to close the 'Properties' dialog box.
Changing the Page Setup
5. Select the 'Page Layout' tab in the File menu and locate the 'Page Setup' group.
6. Click on the small square with an arrow pointing out of the square at the bottom right-hand corner.
7. Look inside the 'Scaling' section in your 'Page Setup' box and choose 'Fit to:' By default, you should see the file set to one page wide and by one page tall.
8. Select how many pages tall or wide you want for your spreadsheet when printed.
9. Click on 'Print Preview' to check the up or scaled version of the spreadsheet when printed. Click on 'Print' if you are satisfied with the preview. Select 'OK' to close your Page Setup box.

Read more ►

How to Convert a Julian Date in Excel

1. Click on the cell were you would like your output data to start. For example, if you have a list of Julian dates in column A, you might want your regular dates to start on column B, so click on cell B1.
2. Enter the following formula into the cell. =('1/1/'(IF(LEFT(A2,2)*1
3. Copy the formula into as many cells as you want dates outputted. For example, if you have Julian dates in cells A1 through A50, copy the formula 50 times from cells B1 to B50.
4. Highlight the cells you created in Step 3.
5. Right-click on the highlighted cells and choose 'Format Cells.'
6. Click on 'Date' from the 'Number' tab. This tells Excel to convert the formula's output into regular calendar dates. Choose the date type (for example, 14 December, 2009 or 14 Dec) and click 'OK.'

Read more ►

How to Code a VBA Excel 2007 Macro Consolidation

1. Go to the 'View' tab in the Microsoft Excel toolbar. Click on the 'Macros' button and select 'View Macros' Enter a new macro name for the master macro such as 'All' and click on the 'Create' button to launch the Visual Basic editor.
2. Go to the second line in between the macro name and end of the macro. In our example, it would appear as 'Sub All()' and 'End Sub'. Type 'Call' followed by each of the individual macro names you would like to run in preferential order. For example, we could have a macro named 'Links' that goes through a range of links and copies and pastes data from linked excel spreadsheets into a master sheet. Another macro called 'Format' sorts the data and adjusts the font type and size.Sub All()Call LinksCall FormatEnd Sub
3. Save the code and go back to the Excel template. Click on the 'View' tab and go to the 'Macros' button. Select the name of the master macro and click on 'Run.' This will run the individual macros that were created in order. In our example, it will run 'Links' first. Once it's completed, it will automatically run 'Format' next.

Read more ►

How to Create a Summary Chart in Excel

1. Open Microsoft Excel and create a new workbook by pressing 'CNTL-N.' Press 'CNTL-S' to save the workbook, and name it 'SummaryChartOfBookSalesByPublisher.xls' when prompted.
2. Create several rows of sample data representing the book sales of different publishers, across different types of books. Type or paste the following data into any worksheet in the workbook. Wherever you see a comma in this data, press the 'Tab' key, which will place each item in its own cell.Publisher,Genre,Distributor,Sales
Dolphin Pub. pub,romance,Amazon,$456
Dolphin Pub. pub,romance,Dynamic Dist. dist,$65
Dolphin Pub. pub,how-to,Ma and Mo dist.,$87
Dolphin Pub. pub,how-to,Keemer and Son dist.,$654
Sanford Pub. pub,romance,Ma and Mo dist.,$123
Sanford Pub. pub,romance,Keemer and Son dist.,$789
Sanford Pub. pub,how-to,Ma and Mo dist.,$432
Sanford Pub. pub,how-to,Aunt May dist.,$767
3. Select the data table, then click the 'Data' tab on Excel's main toolbar. Click the 'Sort' icon to display the dialog box with sorting options.
4. Choose the following parameters for the 'Sort' dialog box, to sort the publishing data by publisher names.Select 'Publisher' in the 'Sort by' drop-down list.
Select 'Values' in the 'Sort on' list.
Select 'A to Z' in the 'Order' list.Press 'OK' to exit the dialog box and sort the data by publisher.
5. Press the 'Data' tab on the Excel toolbar again, then click the 'Subtotal' icon to display the dialog box for configuring summary totals for the publisher data. Choose the following options in the 'Subtotal' dialog box:Select 'Publisher' for the drop-down list next to the text 'At each change in:'
Select 'Sum' for the 'Use function' drop-down list.
Check the 'Sales' checkbox for the 'Add subtotal to' list.
6. Check the following checkboxes at the bottom of the 'Subtotal' dialog box:'Replace current subtotals'
'Summary below data'Press 'OK' to create the summary rows for the publisher data. Notice that Excel has inserted boldface rows into the data, to add up the separate sales figures for each publisher.
7. Notice the small numbered buttons ('1,' '2,' '3') in the left pane of the main Excel window. Press the '2' button to hide the detail sales rows of the publisher data, and display only the summary sale data for the two publishers.
8. Select the publisher data, then press 'Insert' on Excel's toolbar to display an array of icons for graphical objects that can be inserted in a worksheet.
9. Click the 'Pie' icon in the 'Charts' group of icons, then select the first 3D-chart icon under the '3D Pie' heading. Drag the resulting blank chart carefully away from the publisher data, then drag the new blue frame so it surrounds just the two sales data rows for 'Dolphin' and 'Sanford' publishing. Don't include the rows with the 'Grand total' or the 'Sales' column header.
10. Notice the slices of the finished pie chart, which now display the summary sales data for both publishers.

Read more ►

How to Import Export Excel Text Into Access

Import in Microsoft Access
1. Open the Microsoft Access application on your computer. Click on the 'File' option for Access 2003 or the 'Microsoft Office' button for Access 2007.
2. Click on the 'Open' option and locate the Access database that you want to import and export data into. Select the database and then click on the 'Open' button.
3. Click on the 'File' or 'Microsoft Office' button again. Move your mouse over the 'Get External Data' option and then click on the 'Import' option. The Import dialog box will then appear on the screen.
4. Select the 'Microsoft Excel' option from the 'Files of type' box. Click on the arrow next to the 'Look in' field and locate the Excel file that contains the text you want to import.
5. Double click the Excel file. Click on the 'Import Data into a New Table' option and then allow time for the importing process to complete. The Excel text will then be imported into your Access database.
Export in Microsoft Access
6. Open the Microsoft Access program on your computer. Click on the 'File' option for Access 2003 or the 'Microsoft Office' button for Access 2007.
7. Click on the 'Open' option and locate the Access database that you want use for import or exporting Excel text. Click on the database file and then click on the 'Open' button.
8. Click on the 'File' or 'Microsoft Office' button again. Click on the 'Export' option and then the Export dialog box will then appear on the screen.
9. Click on the 'Microsoft Excel 97-2003' option from the 'Save as type' box. Click on the arrow next to the 'Save in' box and select the folder you want to save your exported data to.
10. Enter a name for your file into the 'File name' box and the click on the box next to the 'Save formatted' field so that it's selected. Click on the 'Export' button and the data will be exported.

Read more ►

How to Make a Timeline on Microsoft PowerPoint

1. Click on the 'Insert' tab, then click on the 'SmartArt' button in the 'Illustrations' area. Click on 'Process' and select one of the 'Timeline' layouts available. Add text to your timeline by clicking any place that says '[Text]' and typing or pasting in the text you want.
2. Add items to your timeline. Click on the timeline to select it, click on the 'Design' tab, click on 'SmartArt Tools' and click on 'Add Shape.' Delete an unwanted entry by clicking on it and pressing the 'Delete' key on your keyboard. Move an entry by clicking and dragging it to the location you desire.
3. Change the layout of your timeline by right-clicking on the timeline and selecting 'Change Layout.' Any of the SmartArt layouts are available. Your text will remain the same from layout to layout so you can adjust the design without changing the content.
4. Animate the presentation of your timeline to highlight individual events. Click on the 'Animations' tab, then click on 'Animate' and select 'One by One' so that each item on your timeline will be revealed separately during the slideshow. You will need to click your mouse for each event listed on your timeline if you choose this animation style.

Read more ►