设为首页收藏本站
开启辅助访问

Excel精英培训网

 找回密码
 注册
Excel精英培训网»论坛 › Excel 分享区 › Excel 财务会计报表 › 《Excel在会计工作中的日常应用》书稿试读
数据透视表40+个常用小技巧，让你一次学会！
12345678910... 79下一页
返回列表 发新帖
查看: 182234|回复: 786

《Excel在会计工作中的日常应用》书稿试读

  [复制链接]
发表于 2007-4-23 12:23 | 显示全部楼层 |阅读模式
本帖最后由 兰色幻想 于 2011-3-8 08:34 编辑 <br /><br /><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 在大家的支持下，&nbsp;《Exce;在会计日常工作中的应用》这本书已销售了一个年头，<FONT color=#f70909>累计印刷4次，共13000本</FONT>。兰色幻想再次感谢大家的支持，这次兰色经过争取，把第三章条件格式的原稿（已排好版）发上来供大家下载学习。希望能对大家有帮助。本章的内容有：</P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.1<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>条件格式的设立、添加</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.1.1<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>设立条件格式</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.1.2<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>添加条件</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.2<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>定义条件</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.2.1<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>单元格数值条件</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.2.2<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>公式条件</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>条件格式实例应用</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.1<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>库龄分析的颜色提示</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.2<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>应收账款催款提醒</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.3<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>监视重复录入</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.4<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>格式化账簿</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.5<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>代码录入的错误显示</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.6<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>动态显示销售额排行</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc3 style="MARGIN: 0cm 0cm 0pt 42pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.3.7<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>隐藏公式中的错误值</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.4<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>小结</SPAN></SPAN></FONT></SPAN></SPAN><SPAN lang=EN-US style="mso-no-proof: yes">
<P><FONT color=#1818d7></FONT></P></SPAN>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P></P>
<P><FONT color=#1818d7></FONT></P>
<P><FONT color=#1818d7></FONT></P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#1818d7><SPAN style="mso-font-kerning: 10.5pt"><FONT face="Times New Roman">3.5<SPAN style="mso-spacerun: yes">&nbsp; </SPAN></FONT></SPAN><SPAN lang=EN-US style="FONT-FAMILY: 宋体; mso-font-kerning: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'"><SPAN lang=EN-US>习题</SPAN></SPAN></FONT></SPAN></SPAN><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"></SPAN></SPAN></P>
<P class=MsoToc2 style="MARGIN: 0cm 0cm 0pt 21pt; tab-stops: right dotted 419.7pt"><SPAN class=MsoHyperlink><SPAN lang=EN-US style="mso-no-proof: yes"><FONT color=#e73408>原稿下载：（只供学习，不得作其他商业用途）</FONT></SPAN></SPAN></P>
<P><BR>
<P align=right><FONT color=#000066>[此贴子已经被作者于2008-2-13 13:42:00编辑过]</FONT></P>

本帖子中包含更多资源

您需要 登录 才可以下载或查看，没有帐号？注册

x

点评

ls
下载学习  发表于 2011-9-22 21:56

评分

参与人数 14 +18 收起 理由
蓝天下的白云 + 1 很给力!
linbohen + 1 太给力了
cabi22 + 1 很给力!
ajohncat + 1 很给力!
558888 + 1 很给力!

查看全部评分

回复

使用道具 举报

工作中最常用的函数公式，全印在一张超大的鼠标垫上
hzwzd
发表于 2007-6-21 14:35 | 显示全部楼层
工作中常用的Excel函数公式，全印在一张超大鼠标垫上

谢谢老师！学习共享！
回复

使用道具 举报

发表于 2007-5-5 17:20 | 显示全部楼层
工作中最常用的Excel函数公式，全印在一张鼠标垫上

下载下来,学习一下.
回复

使用道具 举报

kxpxd
发表于 2007-4-23 17:19 | 显示全部楼层

谢谢了!!!
回复

使用道具 举报

liyh67
发表于 2007-4-26 19:38 | 显示全部楼层

谢谢兰版！
回复

使用道具 举报

xiaoyver
发表于 2007-4-23 12:24 | 显示全部楼层

谢谢老师:)
回复

使用道具 举报

laoyebin
发表于 2007-4-23 12:32 | 显示全部楼层

哈哈，搬个板凳好好看看书
回复

使用道具 举报

lvyanfu
发表于 2007-4-23 12:48 | 显示全部楼层

<p>好啊！谢谢了！</p><p></p>
回复

使用道具 举报

发表于 2007-4-23 13:04 | 显示全部楼层

<p><span style="font-weight: bold;">谢谢楼主的分享。这是我的第一帖。</span><br/></p>
回复

使用道具 举报

lksxq
发表于 2007-4-23 13:52 | 显示全部楼层

<p>谢谢，要是能看明白，咱到大城市买一本。</p>
回复

使用道具 举报

下一页 »
12345678910... 79下一页
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-4-26 16:13 , Processed in 0.370589 second(s), 12 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表