How to do a Fast Fourier Transform (FFT) in Microsoft Excel

1. Enable the ToolPak if you have not already done so. Click the 'Office' button, and then choose 'Options.' Click 'Add-In Options,' highlight 'Analysis ToolPak,' and press 'Go.' Highlight 'Analysis ToolPak' a second time, and then press the 'OK' button.
2. Open Excel and create a new spreadsheet file. Add the title 'Time' to the A column, followed by the titles 'Data,' 'FFT Frequency,' 'FFT Complex' and 'FFT Magnitude' to columns B through E respectively.
3. Input the data from your samples into the Data column. Make a note of the number of data points and the sampling rate used.
4. Write the time at which each data point was taken in the Time column. Determine this by dividing the total time by the number of data points.
5. Open the 'Data' tab, and then select 'Data Analysis.' Select the 'Fourier Analysis' option and press the 'OK' button. Set the input range as the information in the Data column and the output as the FFT Complex column.
6. Type the equation '=IMABS (E2)' into the first cell of the FTT Magnitude column. Drag the equation downward to fill every cell of the column. This equation creates real numbers, instead of complex numbers, in the previous column.
7. Fill column F with the corresponding data, from column A, point minus one. Create a separate cell with the equation '=(S/2)/(N/2),' replacing 'S' with the sampling rate and 'N' with the number of samples.
8. Enter the equation '=F2*SG$4' in the first cell of the FTT Frequency column. This time, drag the equation only to the halfway point in the column.
9. Create a graph, using the FTT Magnitude column for the y-axis and the FTT Frequency column for the x-axis. The graph displays the dominant frequencies as peaks.

Read more ►

How to Do Combination Charts in Excel 2007

1. Launch Microsoft Excel and open the spreadsheet containing data by selecting 'Open' under the Office ribbon, selecting the desired file and clicking the 'Open' button.
2. Check that the data is organized in columns, with the first column containing the categories and the second and third columns containing values.
3. Highlight all three columns by selecting the top of the first column and the bottom of the third column by clicking the mouse button and holding it down to highlight before releasing the mouse button.
4. Click the 'Insert' tab in the top toolbar and click the button for the desired chart type in the 'Charts' group (such as 'Column'). Note: additional options will be displayed for that chart type; select a thumbnail image for the desired presentation of the first data series (the second column).
5. Check that the chart is inserted on the same sheet as the data.
6. Click the second set of data on the chart from the third column (the second colored set of data).
7. Right-click the data series and select 'Format Data Series.'
8. Select the category in the left-hand frame for 'Series Options.'
9. Click the option for 'Secondary Axis' in the section, 'Plot Series On' and click the 'Close' button.
10. Click the 'Insert' tab in the top toolbar.
11. Select a chart type in the 'Charts' group for the selected data series (such as line). Note: additional options for the selected chart type will be displayed; select the thumbnail to present the data series in the third column.

Read more ►

How to Change the Default Font in Microsoft Excel 2007

1.
Click on the 'Office' button and choose the 'Excel Options' button toward the bottom of the menu.
2.
When the 'Excel Options' dialog box opens, make sure that the 'Popular' tab on the left is selected. In the center of the window you will see the font options. You can select the options you would like to become your new defaults.
3. When you have finished making your selections, click the 'OK' button on the bottom of the dialog box. Your choices will now be the new default font.

Read more ►

How to Change Text Based on CheckBox Value in Excel

1. Open the Excel 2010 workbook that contains the checkbox that you want to manipulate.
2. Click the 'Developer' tab at the top of the screen. Click the 'Design Mode' button in the middle of the ribbon. This lets you interact with your checkbox.
3. Click on the checkbox to select it. Then, click the 'Properties' button in the 'Controls' area of the ribbon. A small Properties window will open up. Take note of the entry in the 'Name' field at the top of this window, which is usually 'CheckBox1,' or something similar. This is the name of the object, and you will need to know it to write your code. Click the 'X' to close the Properties window.
4. Right-click the checkbox and choose 'View Code' from the pop-up menu. The VBA editor window will appear, with the line 'Private Sub CheckBox1_Click()' already entered into the editor. Place your cursor on the line directly beneath this first one.
5. Enter the following code into the cell:If CheckBox1.Value Then[A1] = 'XXX'Else[A1] = 'YYY'End IfChange 'CheckBox1' to your checkbox's name. Change 'A1' to whatever cell you want the checkbox to manipulate. Change 'XXX' to whatever text you want in the cell when the checkbox has a check in it, and 'YYY' to whatever text you want in the cell when the checkbox is blank. To have one of the options leave a blank cell, just remove the letters but leave the quotes in place.
6. Click the 'X' to close the VBA editor. Click the 'Design Mode' button to turn it off. You can now add or remove a check mark from the checkbox, and your desired cell's text will change.

Read more ►

How to Break the Y Axis on Excel

1. Launch Excel and open a new workbook. For illustration purposes, type “10,” “12,” “13,” “500” in the first column from cells A1 through A4. If you created a chart from these values, the last value would overwhelm the chart, making the smaller numbers nearly indistinguishable.
2. Highlight the column of numbers by dragging the cursor over them. Press “Ctrl-C” to copy them. Click cell “B1” and press “Ctrl-V” to paste them in the second column. Click cell “B4” and change the value from “500” to “50.” Adding this column allows you to customize the chart without changing the original data in your worksheet.
3. Drag the cursor across cells “B1” to “B4” to highlight them. Click the “Insert” menu and select “Chart.” Select a “Column” chart and click “Next.” Continue clicking “Next until you get to the “Chart Location” menu. Select “As a New Sheet” and click “Finish.”
4. Click on the background to open the Format Plot Area dialog box. Click the “Color” menu and change it to white. Click 'OK.'
5. Click the “Insert” menu and select “Autoshapes.” Click the “Line” tool. Drag the tool diagonally across the middle of the last bar. Double-click the line. Click the “Color” menu and select white. Type “20” in the Weight text field. Click “OK.”
6. Click the “Text Box” tool. Drag it beside “10” on the y-axis and type “10”. Draw text boxes beside each of the other numbers in the y-axis, typing “500” beside “50.”
7. Double-click a number in the y-axis. Click the “Color and Lines” tab. Select “None” in the “Tick Mark Labels” section. Click “OK.” The numbers in the y-axis disappear, leaving the numbers you typed in the text boxes as the y-axis values.

Read more ►

How to Convert Multiple Excel Sheets to PDF

1. Create your Excel file sheets. Save all the sheets as a PDF by clicking the first sheet and holding down the 'shift' key and clicking on the last sheet. All sheets in between will be selected.To select some but not all sheets, click the first sheet you want to convert and hold down the 'ctrl' key and click the other sheets to convert.
2. Click 'File' at the top of the Excel screen. Click 'Save As.'
3. Name the file. Choose 'PDF' from the document type drop down menu.
4. Click 'Save.' The Excel sheets have been saved as a PDF.

Read more ►

How to Print Avery Labels in Excel 2007

1. Navigate to Avery's Avery Wizard website.
2. Click the 'Free Download' link in the center of the page. The download should start automatically. If it doesn't click the 'click here' link.
3. Install Avery Wizard by following the on screen instructions.
4. Open Word 2007, then click the 'Avery' tab.
5. Click the 'Avery Wizard.'
6. Follow the instructions in the wizard to select your Avery product. The wizard will prompt you to tell it where the data is saved. Click 'Merge data from existing file' and select the location of your Excel file.
7. Preview your file and print the labels by completing the rest of the wizard.

Read more ►

How to Use Indirect in Excel 2007 to Link to Another Worksheet

1. Create a tab for links to external sources by right clicking on the tab named Sheet1 and selecting 'Create New Tab.' Name it 'Links.'
2. Enter an '=' in the formula bar in the cell you want the data imported into, and then switch to the spreadsheet you're pulling data from, and click on the cell the data is in. This will create a formula in the form of ='[Accounting.xls]Sheet1'!$A$1 where '[Accounting.xls]' is replaced with the name of the spreadsheet, 'Sheet1' is replaced with the name of the tab in the work sheet you're pulling data from, and '$A$1' is replaced with the reference to the cell the data resides in.
3. Select the cell you just made the reference in. Click on the Formulas tab in Excel 2007 and choose Name Manager. In earlier versions of Excel, go to the Formulas menu and select 'Names.' Assign a name to Links!A1 that will be easy to remember. For this example, choose 'Accounting.'
4. Enter the following formula to reference the data: '=INDIRECT(Accounting)'. This will display the information in the cell with the name Accounting.

Read more ►

How to Hide the X Axis on MS Excel

1. Click on the chart you want to edit in Excel.
2. Click 'Axes' on the 'Layout' tab at the top of the Excel application.
3. Click 'Primary Horizontal Axis,' then 'None.'

Read more ►

How to Delete the VBA Project

1. Launch any program which is part of the Microsoft Office suite. Common Microsoft Office programs include Word, Excel, PowerPoint, Access and Outlook.
2. Press the ALT and F11 keys simultaneously on your keyboard. This will open the VBA editor.
3. Right-click in the left pane on the name of the VBA project you would like to delete and select 'Remove.' The VBA editor will now delete that project from your system.

Read more ►

How to Create a ZIP File for Excel Spreadsheet

1. Right-click 'Start' and then click 'Explore.'
2. Right-click on the Excel file and then point to 'Send To.'
3. Click 'Compressed (ZIP) Folder.'
4. Double-click the ZIP folder and then click 'Extract all files' in order to open it as a 'Read-Only' file. (Note: If you would like to extract the ZIP folder and make a copy of it, click 'Extract all files' after you double-click it. Follow the steps in the wizard to complete the process.)

Read more ►

How to Insert a Watermark Into Excel 2007

1. Open Excel 2007 by clicking the Windows Start icon, selecting the 'All Programs' link and clicking the 'Microsoft Office' folder. Click 'Microsoft Excel 2007' to open the program. Click the Microsoft Office icon and select 'Open' to open an existing spreadsheet, or click 'New' to create a new spreadsheet.
2. Click the 'Insert' tab on the top navigation bar, located above the navigation ribbon.
3. Select the 'WordArt' menu from the Text group.
4. Click a style to use for the word art. You can choose any style that appeals to you or is appropriate for the type of document you are watermarking.
5. Type the word you wish to use for the watermark. For example, type 'Draft.'
6. Click the 'Format' tab on the navigation ribbon if it is not already visible, and then click 'Text Fill' in the WordArt group. Select 'No Fill' from the Text Fill drop-down list.
7. Select 'Text Outline' in the WordArt group on the navigation ribbon. Then select the 'Automatic' option from the drop-down options.
8. Click 'Send to Back' in the Format tab's Arrange group on the navigation ribbon. The watermark appears behind the text and characters in the Excel 2007 spreadsheet.

Read more ►

How To Remove Data From the External Data Range in Excel 2007

1. Select the range of data to be removed from the external data range within the spreadsheet.
2. Click on the 'Data' tab. Click on the arrow next to the 'Refresh' field in the 'Connection' group.
3. Click on the 'Connection Properties' option and then click on the 'Usage' tab. Click on the box next to the 'Remove data from the external data range before saving the workbook' field.
4. Close out of the dialog box and click on the 'Refresh Data' option from the 'Data' tab. The data will be fully removed from the external data range.

Read more ►

How to Rename an Excel Worksheet

1. Open Microsoft Excel and the file you want to change.
2. Double-click on the tab for the worksheet that you want to rename. (The tabs are at the bottom of the Excel window.) The sheet's name becomes highlighted.
3. Type in the new worksheet name.
4. Press Enter to accept the changes.

Read more ►

How to View Two Excel 2007 Spreadsheets on Separate Screens

Excel's 'Side-by-Side' View
1. Open the first Microsoft Excel 2007 file with which you want to work.
2. Open a second instance of Excel 2007. Go to the 'Start' menu in the lower left-hand corner of the computer desktop, choose the 'All Programs' list and click on Microsoft Office Excel 2007. Click the 'Office' button in the program, select 'Open,' and double-click on the second file that you want to open and view.
3. Click the 'View' Ribbon in Excel 2007. Click the 'View Side by Side' option in the 'Window' group to view the spreadsheets stacked vertically side-by-side. Click the 'Synchronous Scrolling' button in the 'Window' group to control the scrollbar separately for each spreadsheet file. Click the 'Full Screen' option in the 'Workbook Views' group to expand the viewing area. Right-click anywhere on the screen and choose 'Close Full Screen' to close this view.
4. Click 'Save Workspace' in the 'Window' group from the 'View' Ribbon. Type a name for the file and a directory location and click 'Save.' Re-opening this file saves the side-by-side view of the two files.
Split Screen Option (Windows 7)
5. Open the first Excel 2007 file which you want to view. Click the 'Maximize' button in the top-right corner of the Excel screen.
6. Open the second Excel 2007 file you want to view in a new instance of the Excel program. To open a new instance of the program, either click the Excel application from the 'All Programs' list within the 'Start' menu or right-click the Excel 2007 shortcut on your computer desktop or Taskbar and choose 'Microsoft Office Excel 2007.' In the new instance of the program, open the second file you want to view. Click the 'Maximize' button in the program to maximize the file's view.
7. View the files in split screen mode. With the second Excel 2007 file open, maximized and selected, press first the Windows logo key in the lower left corner of the keyboard. Hold the Windows logo key down and then press the 'right' arrow key to shift the file to the right side of the screen. Click once on the first Excel 2007 file to select it. Repeat the process of holding the Windows logo and the 'left' arrow keyboard keys to place the file on the left side of the screen.

Read more ►