excel讲义（Excel notes）.docVIP

excel讲义（Excel notes） Excel notes.Txt love is the road, friends are trees, only one way of life, way more tree, the rich never forget the way, the lack of time to rely on the tree, you dont get lost, when the rest rely on the tree! This article is made up of coffee, pig and 2008 contribution Ppt documents may experience poor browsing on the WAP side. It is recommended that you first select TXT, or download the source file to the local view. Comprehensive application of Microsoft Excel 2003 Enterprise One Why use Excel to process data? Excel quickly and accurately obtain the information ability of Excel visual inspection formula and calculation relationship of the Excel to deal with multi sheet computing ability of Excel with the modified effect enhanced data management ability of Excel with the ability to chart analysis data of the Excel at any time and anywhere data mining and analysis ability of Excel network data sharing and collaborative analysis ability Two Summary Recognize the ability of spreadsheets to process data, recognize Excels interface and tools, cell concepts, worksheets, concepts, workbook concepts Three Understanding window structures Menu toolbar, formula bar, worksheet, edit area Thinking: how to customize toolbars Four data input Data entry, production of spreadsheets Enter the Ctrl+Enter cell concept by Tab moves to the right of a cell press Enter to move down a cell to determine the contents of the current cell according to the tick input press X to cancel the current contents of the current edit content will be filled to the entire region Five Table basic operations Selection area Drag the selected rectangle region directly with the mouse, click on the row and column mark, click the whole row, the whole column, then drag the mouse, press the Ctrl key, select the discontinuous region Ctrl, and press the Shift key to select the area between the two points Six Select form continued Quick move cursor Ctrl+home moves the cursor to the first cell Ct