<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">1)外观设定(第3楼) <br/> 从空白工作表开始,对整个表格进 <br/> 行字体,居中,网格设置。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">2)格式设定(第4楼) <br/> 对条件格式进行设定。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">3)格式设置(第5楼) <br/> 对数据格式进行设定,区分数字, <br/> 文本,货币,对外观修整。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">4)表格中建立公式(第6楼) <br/> 在“进销存”表中输入自动计算的公式。 <br/> 并进行调试。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">5)单据录入界面(第7楼) <br/> 对入单界面进行初步制作。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">6)设置按钮(第8楼) <br/> 在入单界面中加入控制按钮。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">7)控件对齐(第9楼) <br/> 对控制进行对齐。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">8)对界面的数据格式设定(第10楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">9)在界面中输入VLOOKUP公式(第11楼) <br/> 对代码调出型号进行调试。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">10)设定界面的保护(第12楼) <br/> 对保护进行调试。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">11)输入清空数据代码(第13楼) <br/> 并调试清空。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">12)输入数据录入代码,并调试录入。(第14楼) </font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"> </font></span></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">13)对工作表运作调试(第15楼) <br/> 录入,清空,汇总是否正常。</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial"></font></span></span> <span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">14)对工作表运作调试(第16楼) <br/> 各分表汇总和“进销存”表汇总是否一致 </font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">15)关于仓库库存表的一些情况说明!(17楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">16)关于录入界面的一些情况说明!(18楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">17)关于“进销存”统计表的说明!(19楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">18)“进”“销”两表的情况说明!(20楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">19)关于数据清空代码的说明情况!(21楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">20)期初库存与期末库存的结转(22楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">21)关于数据录入的代码说明!(23楼)</font></span></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt 20.25pt; TEXT-INDENT: -15pt; TEXT-ALIGN: left; mso-list: l0 level1 lfo1; tab-stops: list 20.25pt; mso-layout-grid-align: none;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 宋体; mso-font-kerning: 0pt; mso-ansi-language: ZH-CN;"><span style="mso-list: Ignore;"><font face="Arial">22)月汇总的表格(24楼)<br/></font></span></span></p><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span><p></p><p></p><p></p>
[此贴子已经被作者于2007-3-14 16:28:51编辑过] |