【综合1系2期3班】课件及作业汇总

园丁

<p>【综合1系2期3班】课件及作业汇总</p><p>&nbsp;</p><p>如有不足欢迎大家指正，谢谢！！！！</p><p>&nbsp;</p><p><font face="黑体" color="#dd2222" size="6">所有公开课课件及视频：</font></p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size="4"> &nbsp;&nbsp;&nbsp; </font><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=56558"><font size="4">http://www.excelpx.com/forum.php?mod=viewthread&tid=56558</font></a></p><p><font size="4">&nbsp;</font></p><p><font face="黑体" color="#0000ff" size="6">所有大教室上课课件及视频：</font></p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://uc.165pc.com/qianl/kb/index.asp?page=0"><font face="宋体" size="5">http://uc.165pc.com/qianl/kb/index.asp?page=0</font></a></p><p>&nbsp;</p><p><strong><font face="黑体" color="#ff0000" size="6">【综合1系2期3班】1~12课作业参考答案汇总</font></strong></p><p><strong><font face="黑体" color="#ff0000" size="6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=72053"><font size="4">http://www.excelpx.com/forum.php?mod=viewthread&tid=72053</font></a></font></strong></p><p>&nbsp;</p>

[此贴子已经被作者于2008-11-4 20:44:55编辑过]

园丁

<p><strong>【综合1系2期3班】第1讲——入门基础(8月4日)</strong></p><p><strong>课件：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65147">http://www.excelpx.com/forum.php?mod=viewthread&tid=65147</a>　</strong></p><p>视频：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66077">http://www.excelpx.com/forum.php?mod=viewthread&tid=66077</a>&nbsp;</p><p>&nbsp;</p><p><font face="黑体">作业</font>：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65935">http://www.excelpx.com/forum.php?mod=viewthread&tid=65935</a>&nbsp; </p><p>&nbsp;</p><p>作业上交：</p><p>1组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66009">http://www.excelpx.com/forum.php?mod=viewthread&tid=66009</a>&nbsp;</p><p>2组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66011">http://www.excelpx.com/forum.php?mod=viewthread&tid=66011</a>&nbsp;</p><p>3组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66012">http://www.excelpx.com/forum.php?mod=viewthread&tid=66012</a>&nbsp;</p><p>4组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66013">http://www.excelpx.com/forum.php?mod=viewthread&tid=66013</a>&nbsp;</p><p>5组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66014">http://www.excelpx.com/forum.php?mod=viewthread&tid=66014</a>&nbsp;</p><p>6组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66015">http://www.excelpx.com/forum.php?mod=viewthread&tid=66015</a>&nbsp;</p><p>7组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66018">http://www.excelpx.com/forum.php?mod=viewthread&tid=66018</a>&nbsp;</p><p>8组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66019">http://www.excelpx.com/forum.php?mod=viewthread&tid=66019</a>&nbsp;</p><p>9组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66020">http://www.excelpx.com/forum.php?mod=viewthread&tid=66020</a>&nbsp;</p><p>10组：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66022">http://www.excelpx.com/forum.php?mod=viewthread&tid=66022</a>&nbsp;</p><p>&nbsp;</p>

[此贴子已经被作者于2008-10-13 21:27:13编辑过]

园丁

<p>&nbsp;<strong>【综合1系2期3班】第2讲——公式与函数基础(8月11日)</strong></p><p>课件： &nbsp;<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66645">http://www.excelpx.com/forum.php?mod=viewthread&tid=66645</a></p><p>作业：&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67097">http://www.excelpx.com/forum.php?mod=viewthread&tid=67097</a>&nbsp;</p><p>视频：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=66957">http://www.excelpx.com/forum.php?mod=viewthread&tid=66957</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<strong><font face="Verdana" color="#61b713">玉玉虫</font></strong>&nbsp;)&nbsp; </p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67012">http://www.excelpx.com/forum.php?mod=viewthread&tid=67012</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (<strong><font face="Verdana" color="#61b713">老元子啊)</font></strong></p><p>&nbsp;</p><p>作业上交(1----10组)：</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67120">http://www.excelpx.com/forum.php?mod=viewthread&tid=67120</a></p>

[此贴子已经被作者于2008-8-16 14:12:19编辑过]

园丁

<p><strong>【综合1系2期3班】第3讲——单元格输入和格式设置（8月18日）</strong></p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 课件: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67195">http://www.excelpx.com/forum.php?mod=viewthread&tid=67195</a>&nbsp;</strong></p><p><strong></strong>&nbsp;</p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp; 作业: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67718">http://www.excelpx.com/forum.php?mod=viewthread&tid=67718</a>&nbsp; </strong></p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;</strong>作业讲解：<strong> </strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67816"><strong>http://www.excelpx.com/forum.php?mod=viewthread&tid=67816</strong></a>　</p><p>&nbsp;&nbsp;</p><p>&nbsp; 视频: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67803">http://www.excelpx.com/forum.php?mod=viewthread&tid=67803</a>&nbsp;&nbsp; (<strong><font face="Verdana" color="#61b713">老元子啊</font></strong>)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67794">http://www.excelpx.com/forum.php?mod=viewthread&tid=67794</a>&nbsp;&nbsp;&nbsp; (<strong><font face="Verdana" color="#61b713">玉玉虫</font></strong>)</p><p>&nbsp;</p><p>&nbsp;&nbsp; 作业上交: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=67727">http://www.excelpx.com/forum.php?mod=viewthread&tid=67727</a>&nbsp;（１－１０组）</p>

[此贴子已经被作者于2008-10-13 21:27:40编辑过]

园丁

<p><strong>【综合1系2期3班】第4讲——普通函数(8月25日)</strong></p><p><strong>&nbsp;&nbsp; 课件: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68250">http://www.excelpx.com/forum.php?mod=viewthread&tid=68250</a>&nbsp;</strong></p><p><strong>&nbsp; &nbsp;作业:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68770">http://www.excelpx.com/forum.php?mod=viewthread&tid=68770</a>&nbsp;</strong></p><p><strong>&nbsp;&nbsp; 作业答案： <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=69184">http://www.excelpx.com/forum.php?mod=viewthread&tid=69184</a>&nbsp;（<font face="Verdana" color="#61b713">小p</font>）</strong></p><p><strong>&nbsp;&nbsp;&nbsp;&nbsp;作业答案： </strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68777"><strong>http://www.excelpx.com/forum.php?mod=viewthread&tid=68777</strong></a><strong>&nbsp; (</strong>AA老师的参考答案<strong>)</strong></p><p><strong>&nbsp;&nbsp; 视频:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68414">http://www.excelpx.com/forum.php?mod=viewthread&tid=68414</a>&nbsp;&nbsp; (<font face="Verdana" color="#61b713">玉玉虫)</font></strong></p><p><strong><font face="Verdana" color="#61b713">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68486">http://www.excelpx.com/forum.php?mod=viewthread&tid=68486</a>&nbsp; (老元子啊)</font></strong></p><p><strong>&nbsp; </strong></p><p><strong>&nbsp; &nbsp;作业上交:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68777">http://www.excelpx.com/forum.php?mod=viewthread&tid=68777</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (1-10组)</strong></p>

[此贴子已经被作者于2008-9-1 22:37:46编辑过]

园丁

<p><strong>综合1系2期3班】第5讲——查找替换、定位与超链接（9月1日）</strong></p><p><strong>&nbsp;&nbsp;&nbsp; 课件:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=68340">http://www.excelpx.com/forum.php?mod=viewthread&tid=68340</a>&nbsp; </strong></p><p><strong>&nbsp;&nbsp;&nbsp; 作业:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=69197">http://www.excelpx.com/forum.php?mod=viewthread&tid=69197</a>&nbsp;</strong></p><p><strong>&nbsp;&nbsp;&nbsp; 视频:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=69212">http://www.excelpx.com/forum.php?mod=viewthread&tid=69212</a>&nbsp; (<font face="Verdana" color="#61b713">老元子啊)</font></strong></p><p><strong>&nbsp;&nbsp; 作业上交:&nbsp; </strong>&nbsp;<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=69204">http://www.excelpx.com/forum.php?mod=viewthread&tid=69204</a>&nbsp; (<strong>1-9组</strong>)</p>

[此贴子已经被作者于2008-10-13 21:28:22编辑过]

园丁

<p><strong>【综合1系2期3班】第6讲——条件函数</strong></p><p><strong>&nbsp;课件： <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=69974">http://www.excelpx.com/forum.php?mod=viewthread&tid=69974</a>&nbsp; </strong></p><p><strong>&nbsp;作业：&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70274">http://www.excelpx.com/forum.php?mod=viewthread&tid=70274</a>&nbsp; </strong></p><p><strong>&nbsp;视频： <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70022">http://www.excelpx.com/forum.php?mod=viewthread&tid=70022</a>&nbsp;&nbsp;&nbsp; (<font face="Verdana" color="#61b713">玉玉虫</font>)</strong></p><p><strong>&nbsp;作业上交：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70290">http://www.excelpx.com/forum.php?mod=viewthread&tid=70290</a>&nbsp;&nbsp; (1-9组)</strong></p>

[此贴子已经被作者于2008-9-11 22:10:55编辑过]

园丁

<p><strong>【综合1系2期3班】第7讲——条件格式、排序（9月15日）</strong></p><p>&nbsp; 课件：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70183">http://www.excelpx.com/forum.php?mod=viewthread&tid=70183</a>&nbsp;</p><p>&nbsp; 作业：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70605">http://www.excelpx.com/forum.php?mod=viewthread&tid=70605</a>&nbsp; </p><p>&nbsp; 视频：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70614">http://www.excelpx.com/forum.php?mod=viewthread&tid=70614</a>&nbsp; (<strong><font face="Verdana" color="#61b713">玉玉虫)</font></strong></p><p>&nbsp; 作业上交： <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=70606">http://www.excelpx.com/forum.php?mod=viewthread&tid=70606</a>&nbsp;&nbsp; <strong>(1-9组)</strong></p>

[此贴子已经被作者于2008-10-13 21:17:40编辑过]

园丁

<p>&nbsp;<strong>综合1系3班2期第8讲——日期函数（9月22日）</strong></p><p>课件：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71277">http://www.excelpx.com/forum.php?mod=viewthread&tid=71277</a></p><p>视频：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71357">http://www.excelpx.com/forum.php?mod=viewthread&tid=71357</a></p><p>&nbsp;</p><p>作业：暂时没有作业</p><p>作业上交：暂时没有作业</p>

[此贴子已经被作者于2008-10-13 21:36:06编辑过]

园丁

<p><strong>【综合1系2期3班】第9讲——数据有效性、分列和合并计算(9月29日)</strong></p><p><strong>课件：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71382">http://www.excelpx.com/forum.php?mod=viewthread&tid=71382</a></strong></p><p><strong>视频：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71960">http://www.excelpx.com/forum.php?mod=viewthread&tid=71960</a>&nbsp;</strong></p><p><strong>作业：</strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71945" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=71945</a>&nbsp;</p><p><strong>作业上交：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=71961">http://www.excelpx.com/forum.php?mod=viewthread&tid=71961</a></strong></p>

[此贴子已经被作者于2008-10-13 21:21:16编辑过]