资源描述：
《excel拓展运用拓展运用excel.doc》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、excel拓展运用(拓展运用excel)Maybeyou'vedonehundredsoffinancialstatementsinExcel,andmaybeyou'veimplementedthousandsofcomplexoperationswithExcelfunctions,andyoumightthinkthatExcelisjustthat,evenwithoutnewideas・Butthecountlesshandytricksweuseonweekdaysarejustonepercentofallt
2、heskillsofExceLThistopicstartswithsomelittle-knownskillsinExceltoappreciatethedifferentstylesofExcel.First,letdifferenttypesofdatadisplayindifferentcolorsInthepayroll,ifyouwantgreaterthanorequaltototalwages2000yuanto"red〃thatisgreaterthanorequaltototalwages1500yua
3、nforthe〃blue〃showsthatlessthan1000yuanintotalwagesofz/Brown〃black〃toothershows,sowecanset・1.openthepayrollworkbook,selectthecolumnof"payroll",implementthe，zformattoconditionalformat，zcommand,andopenthe^conditionalformatzzdialogbox・Clickthedrop-downbuttonontheright
4、sideofthesecondbox,selectthez，largerorequal/zoption,andenterthevalue〃2000〃inthefollowingbox〃・Clicktheformatbutton,openthecellFormatdialogbox,andchangethecolorofthefonttored〃・2.pressthe"add〃button,andfollowtheaboveoperationtosetupotherconditions(greaterthanorequalt
5、o1500),thefontissetto"blue",lessthan1000,thefontisset"Brown〃・3.aftersetting,pressthe〃0K〃button.Lookatthepayro11.Thedataofthetotalwageisdisplayedindifferentcolorsaccordingtoyourrequirements.Two,establishaclassificationdrop-downlistfillitemWeoftenenterthenameoftheen
6、terpriseintothetable・Inordertomaintaintheconsistencyofthename,weusethedataavailabilityfunctiontobuildaclassificationdrop-downlistfillitem・1.inSheet2,theenterprisenameisclassifiedintodifferentcolumnsaccordingtocategory(suchas''industrialenterprise",commercialenterp
7、rise",''individualenterprise",etc・)，andanenterprisenamedatabaseisestablished・2.selecttheAcolumn(''industrialenterprises"columnname),inthe〃name〃column,enterthe''industrialenterprises"character,press"enter"keytoconfirm・Imitatetheaboveoperation,B,CTheyarenamedbusines
8、senterpriseandindividualenterprise3.switchtoSheetl,selectthecolumnthatneedstoentertheenterpriseclass(suchasCcolumn),executethedatavaliditycommand,andope
