Excel 2000 Tutorial · FGCU Technology Skills Orientation

Description

lllllllllllllllllllllllllllllllllllllllllExcel 2000 Tutorial · FGCU Technology Skills Orientation Begin the Excel tutorial »Spreadsheet Basics Sorting and Filling Screen elements Basic ascending and descending Adding and renaming worksheets sorts The standard toolbar - opening, Complex sortsclosing, saving, and more. Autofill Alternating text and numbers with AutofillCustomizing Excel Autofilling functions MenusGraphics Customize toolbars Recording a macro Running a macro Adding clip art Add an image from a file Editing a graphicModifying A Worksheet AutoShapes Moving through cellsCharts Adding worksheets, rows, and columns Resizing rows and columns Chart Wizard Selecting cells Resizing a chart Moving and copying cells Moving a chart Freeze panes Chart formatting toolbar Copy a chart to Microsoft WordFormatting CellsPage Properties and Printing Formatting toolbar Format Cells dialog box Page breaks Dates and times Page orientation Styles Margins Style dialog box Headers, footers, and page Create a new style numbers Format Painter Print Preview AutoFormat Printhttp://www.fgcu.edu/support/office2000/excel/ (1 of 2) [11/12/2002 7:27:44 AM]llllllExcel 2000 Tutorial · FGCU Technology Skills OrientationFormulas ...

Informations

• Publié par: Edwie
• Nombre de lectures: 32
• Langue: English

Extrait

Excel 2000 Tutoirla∙ F CG UeThclono SgyllkiOrs tneioitan thwww//:ptedu.gc.forppsuu/

 

     

 

 

      Sorting and Filling l       Basic ascending and descending sorts l       Complex sorts l       Autofill l       Alternating text and numbers with Autofill l       Autofilling functions Graphics l       Adding clip art l       Add an image from a file l       Editing a graphic l       sepauAhSot Charts l       Chart Wizard l       Resizing a chart l       Moving a chart l       Chart formatting toolbar l       Copy a chart to Microsoft Word Page Properties and Printing l       Page breaks l       Page orientation l       Margins l       Headers, footers, and page numbers l       Print Preview l       Print

Begin the Excel tutorial »

Spreadsheet Basics l       Screen elements l       Adding and renaming worksheets l       The standard toolbar - opening, closing, saving, and more. Customizing Excel l       Menus l       Customize toolbars l       Recording a macro l       Running a macro Modifying A Worksheet l       Moving through cells l       Adding worksheets, rows, and columns l       Resizing rows and columns l       Selecting cells l       Moving and copying cells l       Freeze panes Formatting Cells l       Formatting toolbar l       Format Cells dialog box l       Dates and times l       Styles l       Style dialog box l       Create a new style l       Format Painter l       tmaoroFutA

)2 f11[  /leo 1(0020xc/eoft/cefiA ]M 7:27:44/12/2002

 

Office 2000 Tutorials ∙ Word ∙ Excel ∙ Power Point ∙ Access ∙ FrontPage

l       Formulas l       Linking worksheets l       Relative, absolute, and mixed referencing l       Basic functions l       Function Wizard l       Autosum

Keyboard Shortcuts

 

FGCU does not provide personal support for Office 2000 programs to outside parties. © FGCU 2002. This is an official FGCU web page. Florida Gulf Coast University is an equal opportunity/affirmative action institution. [e-mail]  

http/:w/wwf.cg.ude/ut/orppsu20cefioflecxe/00 fo 2( /11/12) [02 72/2044A 2::7]M snnuF oitcasulnd a onti rmFo neatO irlisl ykSologechnCU T∙ FG lairotuT 0002 lceEx

 ygolonhO sllikS∙ l iaorec TCUFGec lxET tu0200   rientation  20072:7 75:]MA

Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Each Excel file is aworkbookthat can hold manyworetskshe. The worksheet is a grid ofcolumns sed(angi det by letters) androws(designated by numbers). The letters and numbers of the columns and rows (called labelsdisplayed in gray buttons across the top and left side of the worksheet. The intersection of a) are column and a row is called acell. Each cell on the spreadsheet has acell addressthat is the column letter and the row number. Cells can contain either text, numbers, or mathematical formulas.

Microsoft Excel 2000 Screen Elements

Adding and Renaming Worksheets

« Excel tutorial menu

 

     

Spreadsheet Basics

Customizing Excel »

orppsuu/edu.gc.fcxe/0002eciffo/tml (s.htasicel/b212/1[/13  ) 1fopt/:w/wwth

seccab s cis ecxEcol anmm.ds ernea dna llwo syou to quickly a lm(  2fosaci.sth12/2002  3) [11/]MA

Undo and Redo- Click the backwardUndoarrow to cancel the last action you performed, whether it be entering data into a cell, formatting a cell, entering a function, etc. Click the forward Redoarrow to cancel the undo action. Insert Hyperlink- To insert a hyperlink to a web site on the Internet, type the text into a cell you want to be the link that can be clicked with the mouse. Then, click the Insert Hyperlink button and enter the web address you want the text to link to and clickOK. Autosum, Function Wizard, and Sorting- These features are discussed in detail in the Functionstutorial.

  New- SelectFile|Newfrom the menu bar, pressCTRL+N, or click theNewbutton to create a new workbook. Open- ClickFile|Openfrom the menu bar, pressCTRL+O, or click theOpenfolder button to open an existing workbook. SaveThe first time you save a workbook, select- File|Save Asand name the file. After the file is named clickFile|Save,CTRL+S, or the Save button on the standard toolbar. Print- Click the Print button to print the worksheet. Print Preview- This feature will allow you to preview the worksheet before it prints. Spell Checkspell checker to correct spelling errors on the worksheet.- Use the Cut, Copy, Paste, and Format Painter- These actions are explained in theModifying A Worksheetsection.

Spreadsheet Basics

« Excel tutorial menu  

72:7 75:

Zoomthe size that the worksheet appears on the screen, choose a different- To change percentage from the Zoom menu.

Customizing Excel »

.fgc/wwwtp:/htfo/troppus/ude.u/belxc/e0020cefi Exce t|errkWoeeshfrt teehes ,tcelsnI book. To add a sed dnie ca howkr atseeshlunc ireht ,tluakrow eer  baratus  def . Bybavosu t ets ehtat tj sbkroweehsg ine th cbyckliseislb ea era ccworkbookts in a eehskrow ehT noittaenri OlsilSky logocenhUCT  ∙GFial utor00 Tl 20 ehm ne uab rtat he top of the scoot rabl si acold testjuel b tow ek.yET R tSnahT e Toodard This lbar n eht ep eman weesprd anENe ths  om the  s ename fr emun .yTohtruc t thh moe ab tit welesR tc esu dna, ri tabheetorkst eh knolccihg-tr.bau en   m he tom w eht emaner oT 

/:ptthgc.fww/wsuu/edu./tfoppro0200ifecel/c/excmizeustomth.1( l fo [ )3/111202/ 7028::230A ]M

Toolbars Many toolbars displaying shortcut buttons are available. Selectslbar|TooViewfrom the menu bar to select more toolbars. Customize Toolbars Customizing toolbars allows you to delete certain shortcut buttons from a toolbar if you do not use them and add the shortcut buttons for commands you use often. 1. SelectweT|oobliVizomes|arstCuand select thesdmnoaCmtab.

« Spreadsheet Basics

Menus Unlike previous versions of Excel, the menus in Excel 2000 initially list only the commands you have recently used. To view all options in each menu, click the double arrows at the bottom of the menu. If you would like to revert to the way older versions of Excel displayed menu options, follow these steps: 1. SelectmozieiV|Tewlboos|arstCufrom the menu bar. 2. Click on theOptionstab. 3. Uncheck theMenus show recently used commands firstcheck box.

 

Customizing Excel

Modifying A Worksheet »

 

     

ut Tiaorl ce0020xEls Orienogy SkilT cenhlo l ∙GFUContita  

  2. By clicking on the command categories in theCateseirogbox, the commands will change in the Commandsbox to the right. 3. Select the command you would like to add to the toolbar by selecting it from theasmdmnoCbox. 4. Drag the command with the mouse to the desired location on the toolbar and release the mouse button. The shortcut button should now appear on the toolbar. 5. Remove buttons from the toolbars by reversing these steps. Highlight the button on the toolbar, drag it off the toolbar with the mouse, and release the mouse button. Recording A Macro Macros can speed up any common editing sequence you may execute in an Excel spreadsheet. In this example we will make a simple macro that will set all the margins on the page to one inch. 1. ClickTools|Macro|Record New Macrofrom the menu bar.

  2. Name the macro in theMacro nameand must not begin with afield. The name cannot contain spaces number. 3. If you would like to assign a shortcut key to the macro for easy use, enter the letter underShortcut keyEnter a lower case letter to make a CTRL+number shortcut and enter an upper case letter to. assign a CTRL+SHIFT+number shortcut key. If you select a shortcut key that Excel already uses, your macro will overwrite that function. 4. Select an option from theStore macro indrop-down menu. 5. Enter a description of the macro in thetiprocisenDfield. This is for your reference only so you remember what the macro does. 6. ClickOKwhen you are ready to start recording.

 o(23)f 11 [2//120022:7 30:8]MA ce20offixcel00/eotimc/sumt lezh.tpht.fww/w://ude.ucg/troppus 0200T tuxEec lnoneiritatSkills Ohnology GFUCT ceroai l ∙

lliwcer  dro ehtnumeans Exd l ce mht erdpod wo nlect options fro itatneir eS  .7 noy ogolhn OlsilSk l ∙roaiT ceGFUCcel Ex Tut2000 d ananchSee p tueliFgaP|leS  tce window.ge Setup nht eaPraigsno  mhe tnggianchs a hcus ,sexob  godialthe rom se fhcoooy uno spoit  fo [ )31/1102/2touszemitm.h(3l 02 7:28:03 AM] t isle i whip itse s ,rpingnr nund anglos  iroacots ot tnaw uoy  adsheet  ). « Spre tsmozini aBissc uC d olRLCTEABR(hK  P  ss ESUA dna erp   e02ffcituro00T  ∙ Wials∙ Exord  M lecxE g gniyfidoksor W A   O  »ethe tnaPeg GFUCd eo snot provide pers  lecoP ∙ rewnioP∙ t ceAc ∙ssro F CGF ©    .seitrap desiut otos amgrp or0200ci eO ff forport suponal tsaoinU uG aC flFl e. idor eb wag pai lGFUCnao ffciThis is U 2002.  tins ion. w ontitutamriffaitca evioppoual ity/rtunti yevsr nqesia  cefi0020xc/e/celde.uus/uroppfo/t u   http://www.fgc [e-mail]  mhegiar   a ge  tllrP . sset sn"1 oace thisOK. Replhtw ahets et piwou ydsanmmcor veorcam ruoy tnaw   Selute.exec  to  oisno tpnoylce taht om tyfideht or wheks. etggToela tcoisns cu has View|Toolbars ah  taht  fe on evn  octferkwoe th tiwhseetob lln corde re 8.   ed.    eerocdrtuot nhte Stop bClick thon sas wcam i orr.bahe Tg inolto  n a our .T  rc 1 oA Maing Runn ved. T tceles ,detaer cvehau yoo crmas from the menu ooslM|caorM|caor ac Ms rondwi, ow .rab   .2morFeht namecro the  in ilhgihhg eaM tht   3. .   un  mhe tIf dna tsilR kcilc