ECE111 Useful Excel Techniques 1 / 4ECE 111 – Introduction to Signal and CircuitsUseful Excel Techniquesprepared by Jarrod OrszulakDecember 19, 2007Below is a list of a number of different functions and techniques in Excel which may behelpful throughout the semester.I. Entering dataExcel is a simple and effective way to communicate data. In lab reports it is important topresent data in an organized and logical manner which the reader will be able understand.Consider the following data current data for a 1000 W resistor:Voltage (V)Current (I)10.00120.00230.00340.00450.00560.00670.00780.00890.009100.01Independent variables can often quickly be entered into Excel using the ‘auto-fill’function. The auto-fill function allows for numbers of equal spacing to be quicklyentered. To begin:- Open a new Excel spreadsheet- In the first row enter your labels (be sure to include units if appropriate)ECE111 Useful Excel Techniques 2 / 4- Enter the first 2 values of the independent variable- - Highlight the values and place the cursor over the square located on the bottomright cornero Notice that the cursor will change from an outlined cross to a smaller solidcross (not shown below)- Left click and pull down until the final value is obtained- Results:- Corresponding current data can then be easily added in to the chart.ECE111 Useful Excel Techniques 3 / 4- To add a border to the chart- Highlight the area you wish to add a border to- Click on the “Add Border” icon if you have it in your toolbarOR- Right-click inside the highlighted area and then select “Format Cells” then“Border” from the tab across the top.II. Plotting Data- To plot the Voltage vs. Current data (I) do the following steps:- Enter the data into Excel such that the x-axis data is in the first column and the y-axis data is next to it on the left (as shown above)- Highlight both the x and y data- From the top tool bar select “Insert” then “Chart” and the chart wizard will appear- For ‘Chart type’ select “XY(Scatter)” and then click “Next”- Your data will already be entered so click “Next”ECE111 Useful Excel Techniques 4 / 4- Enter your chart’s Title and axis labels (with units!) then click “Next”- Click “Finish” and you should have the chart below:Current00.0020.0040.0060.0080.010.0120 2 4 6 8 10 12Voltage (v)Current (I)Current- Different modifications can be made of the chart by right clicking on either theaxes, data, or within the gray area.III. Semi-log plots- Start by plotting your data as described above in part (I) and (II).- Right click on your y-axis and select “Format Axis”- Select the “Scale” tab and then check off the box near the bottom labeled“Logarithmic Scale” and then select “OK”- The corresponding semi-log plot will resultIV. Log-Log plots- To obtain a log-log plot follow the steps as outlined for the semi-log plot in (III)but repeat the steps in (III) for both the x-axis and y-axis- The corresponding log-log plot will