資源描述:
《excel表格 招必學(xué)絕技(excel table must learn stunt)》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、excel表格35招必學(xué)絕技(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