兰色幻想 发表于 2007-4-23 12:23

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

本帖最后由 兰色幻想 于 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>

hzwzd 发表于 2007-6-21 14:35

谢谢老师！学习共享！

wf3601475 发表于 2007-5-5 17:20

下载下来,学习一下.

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>

happystudy 发表于 2007-4-23 13:04

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

lksxq 发表于 2007-4-23 13:52

<p>谢谢，要是能看明白，咱到大城市买一本。</p>
页: [1] 2 3 4 5 6 7 8 9 10
查看完整版本: 《Excel在会计工作中的日常应用》书稿试读