缓解压力的方法是什么?Excel会计应学35招秘技

 huanjiegongzuoyaliyoushenmebanfa?chukailijijianruwai，congyicunyoudedanyuangeneirongzhonghuoquteshubiaoshifujianru，kendingshiyizhongshengshiyoufangbiandefangshi，feichangshiduiyixiekuanshileitongdexinxineironggengshiruci，liruyuangongmingdan、hujisuozaididengxinxineirong。huanjieyalidefangfashishenme?

 ruguowomenxiangxunsuconga4danyuangezhonghuoquchenghudehua，shiyingyong“=right(yuanshujuxinxige，huoqudezifushu)”hanshu，tabiaoming“conga4danyuangezuiyoubiandebiaoshifugangkaishihuoqulianggebiaoshifu”jianrudaocibuwei。ziran，jiaruniyaohuoqumingzidehua，zeyaoyingyong“=left(yuanshujuxinxige，huoqudezifushu)”hanshule。yeyouyizhongzhuangkuang，womenbucongzuoyouliangduangangkaishi，zhishilijicongshujuxinxizhengzhongjianhuoquhaoduogebiaoshifu。liruwomenyaoxiangconga5danyuangezhonghuoqu“wuhanshi”liangzishi，jiuzhixuyaozaizongtimubiaodanyuangezhongjianru“=mid(a5,4,2)”jiukeyile。yisishi：zaia5danyuangezhonghuoqudisizifuhoude2gebiaoshifu，yejiushidisihediwuliangzi。

把基数词转化成序数词

 jiangyingyudejishucizhuanhuachengxushucishiyigefeichangfuzadenanti。yinweitameiyouyigeshifengudingbudongdefangshi：dabufendeshujuzaibianweixushuciquanshiyingyongde“th”houzhuiming，dandadanfanyi“1”、“2”、“3”moweideshujuquefenbieshiyi“st”、“nd”he“rd”moweide。bingqie，“11”、“12”、“13”zheisangeshujuyoubuyiyang，tamenqueyiranshiyi“th”moweide。yiner，wanchengqilaihaoxianghenfanza。shijishang，yaoshidajialiqingsilu，xuanzhunhanshu，zhixuyaozhuanxieyigegongshijisuan，jiukeqingqingsongsongbianhuanle。buxiangxin，keyikan：“=a2&if(or(value(right(a2,2))={11,12,13}),″th″,if(or(value(right(a2))={1,2,3,},choose(right(a2),″st″,″nd″,″rd″),″th″))”。gaigongshijisuansuiranyizhangchuan，danshihanyiquehenqueli：①jiarushujushiyi“11”、“12”、“13”moweide，zezaijia“th”houzhuiming;②jiarudiyibiaozhunshixiao，zechayanzuihouyigeshuju，yi“1”moweiyingyong“st”、yi“2”moweiyingyong“nd”、yi“3”moweiyingyong“rd”;③jiarudiyi、2biaozhundoushixiao，neimajiuyong“th”。yiner，jishucihexushucidebianhuanwanchengdezheibanqingqingsongsonghebianjie。

用特殊字符补足十位数

 hehuijidalejiaodaolederendoulejie，zaizhangmutianchongshiyouyizhongyuedingchengsude“anquanxingtianhaofa”，neibianshijiangeduzhongdeweizhibuzu，huoshizaizhangkuanshujuxinxideqianbianzaijia“$”zheileidebiaoji。shijishang，zaiexcelzhongyeyouxiangjindejianrufangshi，neibianshi“rept”hanshu。tadejichuwenjiangeshishi“=rept(“teshuzifu”，tianchongshiweishu)”。

 liru，womenyaoxianzaia2danyuangelideshujujieweiyong“#”haotianchongzhi16wei，jiuzhixuyaojianggongshijisuangaicheng“=(a2&rept(″#″,16-len(a2)))”jiukeyi;jiaruwomenyaojianga3danyuangezhongdeshujucongzuobianyong“#”haotianchongzhi16wei，jiuxuyaogaicheng“=rept(″#″,16-len(a3)))&a3”;ciwai，ruguowomenxiangyao“#”haojianga4zhongdebiaozhicongliangbiantianchong，zebixugaicheng“=rept(″#″,8-len(a4)/2)&a4&rept(″#″)8-len(a4)/2)”;jiaruniyaoxianbuzujishuzhuanye，yaozaia5danyuangeshujudedingbianzaijia“$”biaojidehua，neimejiugaicheng：“=(text(a5,″$#,##0.00″(&rept(″#″,16-len(text(a5,″$#,##0.00″))))”，yidingnengmanzunideguiding。

建立文字条形图

 chukaifanfujianruyiwai，“rept”hanshulingyixiangyanhuayunyongbianshinenggou lijizaigongzuobuzhongjianliyouchunwenzigouchengdetiaoxingtu。tadejibenyuanliyefeichangjiandan，bianshiyunyongteshuzifudezhinenghuafanfu，yizhaotedingdanyuangezhongdeshuzhizhuyaobiaoxianchuzhangduanbuyidejiaoweishijixiaoguo。

 lirudajiazuixianzhizuoyizhangbenniandushouzhipinghengbiao，suihoujiang“elie”zuoweitiaoxingtuzhong“yusuanjinyinei”yuedexianshixinxiqu，jiang“glie”zezuoweitiaoxingtuzhong“chaochuyusuan”dexianshixinxiqu。suihouyijubiaogezhongxianyoujieguo“dlie”debiaozhi，yong“wingdings”zitiyangshide“n”biaoshifuzhuyaobiaoxianchuqu。caozuobuzhouyixia：

 zaie3danyuangezhongzairugongshijisuan“=if(d3<0,rept(″n″,-round(d3*100,0)),″″)”，suihouxuandingtabingtuozhuai“tianchongbing”，shielieshangquanbuxingdounengyiyiduiyingdliezhongdejieguo;ranhouzaig3danyuangezhongzairugongshijisuan“=if(d3>0,rept(″n″,round(d3*100,0)),″″)”，yetuozhuaitianchongbingzhig14。dajiajiandao，yigemeiyoushiyongexcelshujutubiaozuoyongdechunwenzitiaoxingtuyichengxianyanxia，bianjiexingxianghua，jianjiemingle。

测算单元格中的总篇幅

 youshi，dajiajianghuiduimouyidanyuangezhongbiaoshifudezongshuhenganxingqu，bixucesuandanyuangezhongdezongpianfu。yaochulizheigewenti，chukaiyunyongdao“substitute”hanshudexusicesuanwai，yeyaoshiyong“trim”hanshulaishandiaokonggefu。lirurujina1danyuangezhongjianruyou“howmanywords?”ziyan，neimadajiajiukeyiyongyixiadeguanxishilaibangzhu：

 “=if(len(a1)=0,0,len(trim(a1))-len(substitute(trim(a1),″,″,″″))+1)”

 gaishidehanyishixianjia“substitute”hanshujianliyigexinzifuchuanshuzu，erqieyunyong“trim”hanshushandiaozaiqizhongbiaoshifujiandekonggefu，suihoucesuancizifuchuanshuzuheyuanzifuchuanshuzudeduoweicha，jinerdedao“konggefu”dezongshu，zuizhongjiangkonggefushu+1，jiudedaodanyuangezhongbiaoshifudezongshule。

有关欧的变换

 tashiexcel2002zhongdexinzhuanyonggongju。jiaruniyizhizaianzhuangexcel2002shitiaoxuandeshimorenshezhifangfa，neimahenkenengbukeyizai“zhuanyonggongju”laidanzhongxunzhaota。danshi，womenkeyixiantiaoxuan“zhuanyonggongju”laidanzhongde“zairuhong”，suihouzaidanchuduihuakuangzhongqiyong“ouzhuanyonggongju”xuanzexiang，“mingque”houexcel2002bianhuizizhuanzhuangle。

 jinxinghoudajiazaidukaiqi“zhuanyonggongju”laidan，dianji“ouyuanzhuanhuan”，yigedandudezhuanyeyongyiouheoumengguojiahuobizhuanhuandeduihuakuangjiuchuxianle。yuexceldebiedehanshuduihuakuangyiyang，womenkeyigenjushubiaoshezhihuobizhuanhuande“yuandiqu”he“zongtimubiaodiqu”，suihouzaitiaoxuanbianhuanqianhouzuoyoudebuyiyanghuobijiukeyi。suoxianshidebianshi“100ouyuan”gezizhuanhuachengoumengguojiabiededaibidebijiaojiageyilanbiao。ziran，yibianshioudexianshixinxigengxianjishuzhuanye，dajiahainenggoudianyixiaexcelcaidanlanshangde“ou”anjian，neiyangquanbubianhuanhoudedaibibiaozhiquanshioudekuanshile。

给报表做下非常百度搜索引擎

 womenzhidao，excelbaobiaohewordzhongdebaobiaojiaodadebuyiyangbianshiexcelshijiangtianxiebaobiaozhongdequanbuneirong(baohanjingtaishujuwenzi)doulieruleshujukuchaxundefanweiyinei。womenkeyiyunyong“hanshuchaxun”，duizongtimubiaoshujuxinxikaizhanjingzhundingwei，rutongwangyeyemianzhongdebaidusousuoyinqingyiyang。

 liruzaisuoxianshidebaobiaozhong，conga1daof7dedanyuangezhongjianruleduoweitongxuemendemeikekaoshichengji。erzaia8daoa13dedanyuangezhongdajiazechuangjianleyige“hanshuchaxun”diqu。dajiadegouxiangshi，zaiwomenzai“jianruxueyuanmingzi”youcededanyuange，yejiushic8gezhongjianruyiqieyigetongxuemendexingminghou，qizhengxiafangdedanyuangezhongbianhuiquanzidongxianshixinxichugaixueyuandemeikekaoshichengji。shijiwanchengdefangshiyixia：

 jiangshubiaoguangbiaojingzhundingweidaoc9danyuangezhong，suihoudianji“chajin”zhi“hanshu”xuanzexiang。zairutusuoshi18danchulaideduihuakuangzhong，tiaoxuan“vlookup”hanshu，dian“mingque”。zaisuihoudanchulaide“hanshucanshu”duihuakuangzhongdajiasheding“lookup_value”(zhibixuzaishujufenxibiaodiyiliezhongjiansuodezhi)wei“c8”(jijiansuowomenzaic8danyuangezhongtianxiedexingming);“table_array”(zhishujuxinxijiansuodefanchou)wei“a2∶b6”(jizaiquanbuxueyuande“yuwenke”kaoshichengjizhongjiansuo);“col_vindex_num”(zhiyaojiansuodebiaozhizaibaobiaozhongdexiliehao)wei“2”(jibiaozhizaidierlie);“range_lookup”(zhishibushibixujingzhunpeidui)wei“false”(shuomingbingbushi。ruguoshi，jiuwei“ture”)。shezhijieshuan“mingque”。

 zheishifanhuibaobiao，dianjic9danyuange，dajiajiandao“fx”diquzhongxianshixinxidezhilinggerenxingwei“=vlookup(c8，a2∶b6，2，false)”。kaobeigaicmd，zaic10、c11、c12、c13danyuangezhonggezijianru：“=vlookup(c8，a2∶c6，3，false)”;“=vlookup(c8，a2∶d6，4，false)”;“=vlookup(c8，a2∶e6，5，false)”;“=vlookup(c8，a2∶f6，6，false)”(qizhuyaocanshushijiyiyitongc9zhongyiyang，yibuguoduochanshi)。

 jiexiaqu，dajiajiulaijiance“vlookup”hanshudezuoyong。changshizai“c8”danyuangezhongjianrumouyixueyuanming，liru“zhaoyao”，huichejianzhizhongdajiahuifajue，qizhengxiafangmeiyikemudedanyuangezhongjiuquanzidongxianshixinxichugaishengderuxiaokaoshichengjile。

Excel工作簿考试大纲的创建

 heworddedagangshituyiyang，excelzheiyizuoyongguanjianyongyijiejuefeichangdadegongzuobushi，wufajiangzhongyaoneirongxianshixinxizaitongyipingshangdenanti。jiaruzaiyizhangbaobiaoshangmingmufanduo，danjibenshujuleixingqueyouyouyidingdeduibixing，neimadajiachedinenggou xianyongdiannaoshubiaotiaoxuanshujuxinxidiqu，suihoudianyixia“shujuxinxi”laidande“fenleihuizong”xuanzexiang。bingzaidanchulailaidande“xuanzhongguinaxiang”diqutiaoxuannixuyaoguinashujuxinxideleixing。zuizhong，rutusuoshi19suoxianshi，rujindebaobiaobingbushijiubianxiaohenduoma?ziran，jiaruniyaoxiangchakanmingxidehua，dianjibaobiaozuobiande“+”anjianjiukeyi。

插进“图例”

 suiranyou14dalei50duozhongduoyang“shujutubiao”kuanshijiexcelchengzheyao，danzhenduifuzaduobiandeshujuxinxiguanlian，jibendeshujutubiaobiaomingfangshirengkanqilaikuzaofaweiheqianquexiangxiangli。yinerzaizuixinbanexcel2002zhongtianjiale“tuli”dezuoyong。jinguanzai“chajin”laidande“tuli”duihuakuangzhongjinyouxiaoxiao6zhongkuanshi，danzhenduibiaomingshujuxinxizhongjiandegouzaoquejuyoule“siliangboqianjin”deshijixiaoguo。liruyaoxianshixinxishujuxinxidecengjiguanliannenggou tiaoxuan“zuzhijiagoutu”;eryaobiaoshuzichandeshangpinliutongquanguochengzenenggou tiaoxuan“xunhuantu”;ziran，yaobiaominggezhonggeyangshujuxinxidejiao*zhonghexingnenggou tiaoxuan“weientu”。nikankan，rutusuoshi20suoxianshideweientuduomedehaokan。bingqieniyaonenggou youjiangaituli，diaocheng“tuli”caidanlan。wujuwushudisheding“tulikuanshiku”naizhihainenggouduojiashanghaoduogeyuanhuantu。

了解Excel的“从文字到视频语音”

 tashiexcel2002zhongdeyigeyinrenzhuyidexinzuoyong。tabianshirangofficeshoujiruanjianbudannengxie、yaosuan，yeyaokeyikan、nengshuo。suiranxianjieduanzaoyiyouhenduoshoujiruanjiandouzheyanyuwenzideshebeisongdu，danweiruangongsideofficewuluncongshipinyuyindewenheduheyudiaodeshengyinhongliangquanshiqitaleisishoujiruanjianbunengleibide。

 yizhaoofficedemorenshezhianzhuang，nijianghuihaibukeyizaiexceldelaidanzhongxunzhaota，zaidajiaquedinganzhuangle“congwenzidaoshipinyuyin”dexuanzexianghou，jiukeyizaiexcelde“zhuanyonggongju”laidanzhongjiandao“shipinyuyin”xinxiangmule。rutusuoshi21suoxianshi，kaiqiyigebaobiao，suiyitiaoxuanzaiqizhongdeneirong，suihoudianji“congwenzidaoshipinyuyin”caidanlanshangde“songdudanyuange”anjian，zheishiyigehanyoucixingdeshengyinjiugangkaishiyiziyijudisongdule。zhideyitideshi，dangyudaobiaodianshi，exceldesongduhuiquanzidongjianduanyihuier，suihouzairanhousongdu，zheiyidianhedisanfangruanjianchedibuyiyang，xiaobianjuedeneiyangdejiejuegengweidangran。huanjieyalidefangfashishenme?

 yeyouyidianbixubiaomingdeshi，jiaruniyaodiaojieexcel2002zhongyuyinyuedudesulv，nenggou zai“caozuomianban”zhongshuangjishubiao“shipinyuyin”biaozhi，suihouzai“wenbendaoshipinyuyin”kapaishangdiaojiejiukeyi

Excel中“拍摄”作用的用途

 zheiyizuoyongjiaoweijijutese，haoxianghecesuan、tongjifenxi、pailiezheixie“zhengtong”zuoyongbeidaoerchi，yinweitadegongxiaojuranshi——“zhuaping”!bingqiehaibingbushixiang“printscreen”anjianneiban“yibaluanzhua”，zhishirongxujinigenjudiannaoshubiaokaizhantiaoxuan，“zhinazhuana”。

 yaoxunzhaozheiyizuoyonghaibutaifeichangrongyi，dajiadianyixiaexcel“zhuanyonggongju”laidande“ziding”xuanzexiang。zai“zhiling”kapaide“leixing”yuanxin“zhuanyonggongju”，zaizaizhilinglanzhongxunzhao“paishe”anjian，bingjiangtatuozhicaidanlandesuiyibuwei。ruguowomenyaoxiangduibaobiaozhongdemouyibufen“paizhao”，zhixuyaoxiantiaoxuantamen(tu23)，suihouanzhu“paishe”anjian，zheishihougaixuanzhongdiqujiubei“pai”lechulai。suihoujiangdiannaoshubiaonuodongdaobixuxianshixinxi“xiangpian”dediqu(ziran，haikeyishilingyizhangbaobiao)，zaiduanzhu“paishe”anjian，neiyangganggangbei“paishe”de“xiangpian”jiumashangniantieguolaile。ziran，he“xiangpian”yitongchuxiandeyeyou“zhaopian”caidanlan。henxianeryijian，excelshijiangtazuoweiyifuzhaopianlaikandaile，dajiakesuibianjiangtakaizhanzhuandong、fangsuojiejue。

 danshi，qingzhuweiyidingyaoliuyi：zheibingbushiyibandexiangpian!ninengchangshixiugaiyuanxianbeidajia“paishe”chulaidebiaogeshujukanyixia——gengxinyixia“xiangpian”，jieguo“xiangpian”zhongdeshujuxinxijuranyebeitongbushengjile!huanjiegongzuoyaliyoushenmebanfa?