资源描述：
《excel表格 招必学绝技（excel table must learn stunt）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、excel表格35招必学绝技（Exceltable35mustlearnstunt）Maybeyou'vedonehundredsoffinancialstatementsinExcel,andmaybeyou'veimplementedthousandsofcomplexoperationswithExcelfunctions,andyoumightthinkthatExcelisjustthat,evenwithoutnewideas.Butthecountlesshandytricksweuseonweekdaysarejustonepercentofalltheski
2、llsofExcel.Thistopicstartswithsomelittle-knownskillsinExceltoappreciatethedifferentstylesofExcel.First,letdifferenttypesofdatadisplayindifferentcolorsInthepayroll,ifyouwantgreaterthanorequaltototalwages2000yuanto"red"thatisgreaterthanorequaltototalwages1500yuanforthe"blue"showsthatlessthan1
3、000yuanintotalwagesof"Brown","black"toothershows,sowecanset.1.openthepayrollworkbook,selectthecolumnof"payroll",implementthe"formattoconditionalformat"command,andopenthe"conditionalformat"dialogbox.Clickthedrop-downbuttonontherightsideofthesecondbox,selectthe"largerorequal"option,andenterth
4、evalue"2000"inthefollowingbox".Clicktheformatbutton,openthecellFormatdialogbox,andchangethecolorofthefonttored".2.pressthe"add"button,andfollowtheaboveoperationtosetupotherconditions(greaterthanorequalto1500),thefontissetto"blue",lessthan1000,thefontisset"Brown".3.aftersetting,pressthe"OK"b
5、utton.Lookatthepayroll,Isthepayrolldatadisplayedindifferentcolorsaccordingtoyourrequirements?.Two,establishaclassificationdrop-downlistfillitemWeoftenenterthenameoftheenterpriseintothetable.Inordertomaintaintheconsistencyofthename,weusethedataavailabilityfunctiontobuildaclassificationdrop-d
6、ownlistfillitem.1.inSheet2,theenterprisenameisclassifiedintodifferentcolumnsaccordingtocategory(suchas"industrialenterprise","commercialenterprise","individualenterprise",etc.),andanenterprisenamedatabaseisestablished.2.selecttheAcolumn("industrialenterprises"columnname),inthe"name"column,e
7、nterthe"industrialenterprises"character,press"enter"keytoconfirm.Imitatetheaboveoperation,B,C......Theyarenamed"businessenterprise"and"individualenterprise""......3.switchtoSheet1,selectthecolumnthatneedstoentertheenterpriseclass(suchasCcolumn),executeth
