资源描述：
《excel 电子表格运用技巧（Excel spreadsheet skills）.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、excel电子表格运用技巧(Excelspreadsheetskills)IfweuseExcelXPtoprocesshugedata,wecan，tpayattentiontotechniquesandmethodsItcantakealotofeffort・Therefore,howtoskillfullyuseExcelXPtoquicklyinputinformationbecomestheuseofExcelXPThetopicthatthehomecaresverymuch,theauthorintr
2、oducesafewsmalltechniquestothisrespect・1,quicklyinputalargenumberofdecimalplacesIfweneedtoenteralargenumberofdecimaldigitsintheExcelXPworksheet,followtheordinaryinputsideMethod,wemayenterdirectlyaccordingtothesizeoftheoriginalnumber,forexample,nowenterthenumbe
3、r0.05inthecellWewillenterthe〃0.05〃asitisintheform.However,ifyouneedtoenteranumberofdecimalpointsWhenweentertheabovemethod,eachtimeweenteranumber,weneedtorepeatthedecimalpointThevolumewillincreaseandtheinputefficiencywilldecrease.Infact,wecanusethedecimalpointi
4、nExcelXPtoautomaticallylocatetheworkYes,allowthedecimalpointsofalldigitstobeautomaticallypositionedsoastorapidlyincreasetheinputspeed・UsingdecimalpointautomaticpositioningworkOntime,wecanclickthetools/options/EditbuttonfirstintheExcelXPeditinterfacewiththemous
5、e"Edit"tab,inthepop-updialogbox,selectthez，automaticallysetdecimalpoint"checkbox,andthenin"number"finetuneIntheeditbox,typethenumberyouwanttodisplayontherightofthedecimalpoint・Later,weenterthenumberwiththedecimalpointEnterthenumberdirectly,andthedecimalpointwi
6、llbeautomaticallypositionedaftertheenterkey.Forexample,wewanttobeinacellIfyoutype0.06,youcansetthedigitoptionto2inthesettingsabove,andthendirectlyinthespecifiedcellWhenyouenter6andenter,thenumberofthecellisautomaticallychangedto〃0・06〃・Howaboutthat?1,quicklyent
7、erthecontentsofthetextfileNow,ifyouhavesomefilesstoredinYISHI0N，stextformatathand,ifyouneedtomakethedataatthispointExcelXPworksheet,whatshouldIdo?Re-enterit,maybeonlythepersonwithabadbrainwilldoitTodoit;ittakesalotoftimetocopyandpastethedatafromthemenuintothew
8、orksheet・Noproblem!YouonlyneedThecleveruseoftextfileimportcapabilitiesinExcelXPcangreatlyreducetheneedforreenteringorrequiredTheenormousamountofworkneededtokeepcopyingandpasting・Wh
