290 likes | 702 Views
Microsoft Excel. Walking Through a Tutorial http://www.fgcu.edu/support/office2000/excel/. What’s this?. So after hitting cancel…. Solution . The Cancel button was not really Cancel. For this case, close the browser with the x Now, run your spyware and …. The Standard Toolbar.
E N D
Microsoft Excel Walking Through a Tutorial http://www.fgcu.edu/support/office2000/excel/
Solution The Cancel button was not really Cancel. For this case, close the browser with the x Now, run your spyware and …
The Standard Toolbar Source: Florida Gulf Coast University, http://www.fgcu.edu/support/office2000/excel/customize.html
Macros Later…
Using the Formatting Toolbar Select cells and click on the button Example: highlight column D and click on $ to make the numbers $.
Insert Function • Highlight the cells – rows and columns • Insert Function or use Function Wizard Example: to sum columns 1 and 2 into column 3, highlight columns 1 – 3 and click to put the sum in column 3. Or, highlight columns 1 – 3 and Insert Function.
Function Wizard • Click on the drop down menu to the right of the to bring up the Function Wizard.
The Best Tutorial for You? • http://www.usd.edu/trio/tut/excel/\ • http://www.baycongroup.com/el0.htm • http://www.cc.gatech.edu/classes/AY2005/cs1321_spring/labs/lab4/index.html • Google for others…
Link Worksheets Put your subtable of extras in sheet 1 and link it to another value in sheet 3 Format: sheetname!celladdress Example: "=A1+Sheet2!A3"