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 ►

How do I Add Information on Excel Worksheets to a Summary Sheet?

Excel 2003
1. Open Microsoft Excel and open the sheet you wish to summarize. Click on the 'Tools' menu and choose 'Scenario.'
2. Click on the 'Summary' option and choose 'Scenario Summary.' Go to the 'Result cells' tab.
3. Enter the cells you wish to summarize. You can simply place your cursor on the first cell and drag it to the last cell to create your range.
Excel 2007
4. Open Microsoft Excel and find the spreadsheet you want to summarize. Go to the 'Data' tab.
5. Go to the 'Data Tools' group and then the 'What-If Analysis-Scenario Manager.' Click the 'Summary' button.
6. Choose the 'Scenario Summary' option and enter the range of cells you wish to summarize. You can select the cells by highlighting the first one and dragging your cursor to the last one.

Read more ►

How to Protect Sales in Excel 2007

Protect an Entire Worksheet
1. Click on the bottom tab to select the worksheet that you wish to protect.
2. Click on the 'Review' tab on the menu ribbon.
3. Click 'Protect Sheet' in the 'Changes' panel of the 'Review' tab.
4. Enter a password if you want the worksheet to be password-protected. If not, leave the 'Password to unprotect sheet' box blank.
5. Click the 'OK' button and the entire worksheet will be protected from future changes.
Protect Cells Within a Worksheet
6. Click on the bottom tab of the worksheet you want to protect.
7. Click-and-drag the cursor to select the cells containing the data you wish leave unprotected. You can also hold the 'Ctrl' key down and click on multiple individual cells. Entire rows or columns can also be selected.
8. Click the 'Home' tab and then click 'Format Cells.' You can also right-click on a selected cell and select 'Format Cells' from the contextual menu.
9. Click 'Protection' and then uncheck the 'Locked' option.
10. Click 'OK' to apply the changes and close the dialog window.
11. Click on the 'Review' tab and then click on 'Protect Sheet.'
12. Enter a password for the worksheet if desired. Leave the input box blank if you don't want to password-protect the worksheet cells.
13. Click the 'OK' button. All cells except the ones selected in Step One will be protected from future changes.

Read more ►

How to Use Freeze Panes in Excel

Freeze the Top Row or Left Column
1. Open the Excel spreadsheet.
2. Navigate to the 'View' tab on the top menu.
3. Click on 'View,' then click on 'Freeze Panes.' A drop-down menu opens.
4. Select the 'Freeze Top Row' option to freeze the top row.
5. Select the 'Freeze Left Column' or 'Freeze First Column' option to freeze the left column.
6. Freeze the top row by using the keyboard and sequentially pressing the keys 'ALT, W, F, R.' Ignore Steps 3 through 7 if using this choice.
7. Freeze the left column using the keyboard by sequentially pressing the keys 'ALT, W, F, C.' Ignore Steps 3 through 7 if using this choice.
8. Unfreeze panes by repeating Steps 3 through 5 and selecting 'Unfreeze Panes' or sequentially press the keys 'ALT, W, F, F.'
Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9. Open the Excel spreadsheet.
10. Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.
11. Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.
12. Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.
13. Navigate to the 'View' tab on the top menu.
14. Click on 'View,' then click on 'Freeze Panes.' A drop-down menu opens.
15. Select the 'Freeze Panes' option. You have now frozen the columns or rows, or columns and rows you designated.
16. Freeze panes using the keyboard by sequentially pressing the keys, 'ALT, W, F, F.' Ignore Steps 5 through 8 if using this choice.
17. Unfreeze panes by repeating Steps 5 through 7 and selecting 'Unfreeze Panes' or sequentially press the keys, 'ALT, W, F, F.'

Read more ►

How to Do a Paired Two Sample T

1. Enter your first set of data in column A. Enter your second set of data in column B. Make sure you only put one data result in each cell.
2. In cell C1 type '=TTEST(.' Do not hit 'Enter.'
3. Highlight your first data set and type ',.'
4. Highlight your second data set and type ',.'
5. Type '2,1).' Press 'Enter.' You formula in the cell should look like '=TTEST(A1:A5,B1:B5,2,1).' The cell returns the t Test result.

Read more ►

How to Create a Command Button in Microsoft Excel

1. Open the Excel worksheet in which you will be installing the command button.
2. Click the Microsoft Office logo located in the top left-hand corner of the screen and choose 'Excel Options.' Check 'Show Developer Tab' under the Top Options tab, and click 'OK.'
3. Click the 'Developer' tab on the main menu ribbon. Open the 'Insert' drop-down menu, and click 'Command Button.' Select the area of the worksheet where you want to insert the command button, and click on it. The command button will appear.
4. Click the 'Developer' tab on the main menu ribbon and select 'Design Mode.'
5. Right-click on the command button that you just created and select 'Properties.' Select 'Text' to add a caption to the button. Select 'Size' to edit the size and position of the command button. Select 'General' to edit the function of the button. Choose 'AutoLoad' if you want the button activated every time the workbook is opened. Choose 'Placement' to edit the movement of the button on the workbook page. Click 'OK' to save the the command button properties.
6. Right-click on the command button and choose 'Assign Macro.' Select the action that you want the button to perform from the macro list. Click 'OK' to save the command button.

Read more ►

How to Put Error Bars on Points in Excel

Office 2003
1. Right-click the data series (the points on the graph) and click 'Format Data Series.'
2. Click the tabs at the top of the window that read 'X Error Bars' or 'Y Error Bars' as necessary.
3. Select the error bar style under 'Display' and set the error amount as a fixed value, a percentage or a standard deviation.
4. Click 'OK' to apply the error bars.
Office 2007
5. Click on the graph and the 'Chart Tools' toolbar will appear at the top of the screen.
6. Select the 'Layout' tab and click the 'Error Bars' button found on the right side.
7. Click 'More Error Bars Options' and choose the style of error bar, and enter the error amount as a fixed value, percentage or standard deviation.
8. Click 'OK' to apply the error bars.

Read more ►

How to Recover MS Excel Files After Closing

Enable AutoRecover
1. Open the Excel program. A new worksheet appears.
2. Click the 'File' tab. A list of basic commands appears.
3. Click 'Options' under 'Help.'
4. Click 'Save.' A dialog box opens.
5. Select the check box for 'Save AutoRecover Information Every X Minutes.'
6. Type the number of minutes, such as every 10 minutes, for the frequency of saves.
7. Select the check box for 'Keep the Last Autosaved Version if I Close Without Saving.' The Excel files will save at least one version.
View the Document Recovery Pane
8. Open the Excel file. A Document Recovery task pane opens next to the worksheet.
9. Click the arrow next to the recovered file icon in the 'Available Files' text box. A list of options appears: 'Open,' 'Save As' or 'Delete.'
10. Click 'Open' to review the version of the file. Click 'Save As' to rename and create a new copy of the workbook. Click 'Delete' to delete this version.

Read more ►

How to Change Column Width in Microsoft Excel 2003

1. Select the column that you wish to resize. To select a column, left-click on the column letter, located at the top of the column in the spreadsheet and labeled alphabetically from left to right. Once you click on the column letter it will highlight the entire column.
2. Resize the column using the drag arrows on the column head. Hold the cursor over the left or right side of the column header . An arrow will appear. Simply left-click and you can drag the column to the desired width.
3. Set the column width using the column properties menu. Once you have highlighted the column, right-click to access the column properties menu.
4. Implement column width changes using the column properties menu. Enter in the desired width of the column in pixels into the column properties menu width box and click “Okay” to implement.

Read more ►

How to Create Sequential Numbers on an Excel Document With Software

1. Type the first number of your sequence into the cell corresponding to the top position of your list. For example, if you wanted to start your numbering sequence in the top left corner of the spreadsheet, you could type '1' into cell 'A1.'
2. Type the second number of your sequence into the cell corresponding to the second position of your list. For example, you could type '2' into cell 'A2.' Add more numbers to your sequence if the numbering pattern isn't recognizable after two numbers.
3. Click on the top cell in your sequence and drag your mouse to select the rest of your starting values.
4. Click the 'fill handle' in the bottom right corner of the bottom cell, then drag the handle down until all of your required cells are included within the selection. For example, if you entered '1' and '2' into cells 'A1' and 'A2' respectively and wanted to create a 20-number sequence, you would drag the handle to cell 'A20.'
5. Release the left mouse button to fill your selected cells with a list of sequential numbers.

Read more ►

How to Rename Columns in Microsoft Excel Queries

Customize Column Labels
1. Open Microsoft Excel.
2. Click on the column you wish to rename to highlight it.
3. Click 'Insert' on the toolbar at the top of the screen to open a drop-down menu.
4. Click 'Name.'
5. Click 'Define.'
6. Type the name you wish to give the column.
7. Click 'OK' to save the new label. Repeat these steps for each column you wish to rename.
Rename Column Labels With Numbers
8. Open Microsoft Excel.
9. Click 'Tools' to open a drop-down menu.
10. Click 'Options.' A new window will open.
11. Click on the 'General' tab to display a list of options.
12. Uncheck the box next to 'R1C1 reference' to rename the columns with numbers instead of letters. To return to using alphabetical labels, check the box.

Read more ►

How to Delete Commas From Excel 2007

1. Double-click on the cell that you want to edit.
2. Position the cursor directly behind the comma that you want to delete. Click the mouse once in this spot.
3. Click the 'Backspace' button on the keyboard to remove the comma. If there are multiple commas in the cell that you want to delete, use the arrow keys to move over to them and hit 'Backspace' to delete them.
4. Click 'Enter' when you are finished making changes to the cell.
5. Repeat the process for any additional cells you wish to edit.

Read more ►

How to Insert Copy a Formula in Excel 2007

1. Open Excel and the worksheet in question. Position the cursor in the cell in which you wish to insert the formula.
2. Click on the Formulas tab at the top of the Excel window. Choose the proper category for the formula you will be using, and then select the formula that you wish to insert from the list that appears.
3. Enter the cell references as prompted in the Function Arguments dialog box that appears.
4. Copy any of your existing formulas by first selecting the cell that contains the formula you wish to copy.
5. Click on the Home tab at the top of the Excel window, and select the Copy icon. Select Paste if you would like to paste both the formula and the formatting, and click on Paste Special if you want to paste the formula only.
6. Copy your formula into adjacent cells by using the Excel fill handle. This is a small black square that is located at the lower-right corner of the cell or group of cells you have selected. Move your mouse over it, and when the pointer turns to a black cross, left-click and drag the fill handle over the range of cells into which you wish to copy the formula.

Read more ►

How to Enable a Ribbon Customizer

1. Launch the Microsoft Office application for which you want to customize the Ribbon interface.
2. Right click anywhere on the Office Ribbon, then click 'Customize the Ribbon.'
3. Click the 'New Tab' button at the bottom of the right side of the 'Options' screen. The application creates a new section labeled 'My Tab' in the right pane of the window.
4. Drag and drop desired command functions and options for the Ribbon Tab from the drop-down menu on the left side of the 'Options' screen into the 'My Tab' section of the right-side window pane.
5. Click the 'OK' button at the bottom of the screen after you finish dropping desired function and option commands into your new customized Ribbon Tab. Once you return to the main Office application screen, the new tab is immediately available for use within the program.

Read more ►