数据透视表的习题汇总
<p><font size="3">学前l练习1:我所了解的数据透视表</font></p><p><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=90082"><font size="1">http://www.excelpx.com/forum.php?mod=viewthread&tid=90082</font></a></p><p><font size="3">学前练习2:基础选择题</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1116210&id=90180&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1116210&id=90180&skin=0</font></a></p><p><font size="3">学前练习3:刷新问题</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1118624&id=90357&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1118624&id=90357&skin=0</font></a></p><p><font size="3">学前练习4:筛选</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1120539&id=90515&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1120539&id=90515&skin=0</font></a></p><p><font size="3">学前练习5:添加简单运算公式</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1122502&id=90656&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1122502&id=90656&skin=0</font></a></p><p><font size="3">学前练习6:透视运算汇总方式</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1125654&id=90934&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1125654&id=90934&skin=0</font></a></p><p><font size="3">学前练习7:组合</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1127574&id=91161&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1127574&id=91161&skin=0</font></a></p><p><font size="3">学前练习8:永远的表格线</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1130957&id=91486&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1130957&id=91486&skin=0</font></a></p><p><font size="3">学前练习9:排序</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1133032&id=91729&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1133032&id=91729&skin=0</font></a></p><p><font size="3">学前练习10:只显示最大2位</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1134978&id=91924&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1134978&id=91924&skin=0</font></a></p><p><font size="3">学前练习11:利用数据透视表得到数据源</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1137669&id=92162&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1137669&id=92162&skin=0</font></a></p><p><font size="3">学前练习12:如何得到插入字段的公式</font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1140109&id=92410&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=168&replyID=1140109&id=92410&skin=0</font></a></p>[此贴子已经被作者于2009-9-30 6:26:36编辑过]
jx1680000版主的“和我一起学数据透视表”系列
<p align="center"><font color="#ff0000" size="3">jx1680000版主 的“和我一起学数据透视表”系列</font></p><p><font size="3">和我一起学数据透视表(题1 添加计算项) </font></p><p><font size="3"><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312051&id=41224&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312051&id=41224&skin=0</font></a></font></p><p><font size="3">和我一起学数据透视表(题2 重复项 获取数据) </font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312053&id=41226&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312053&id=41226&skin=0</font></a></p><p><font size="3">和我一起学数据透视表(题3 日期聚合) </font></p><p><font size="3"><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312060&id=41227&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312060&id=41227&skin=0</font></a></font></p><p><font size="3">和我一起学数据透视表(题4 格式百变) </font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312065&id=41229&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312065&id=41229&skin=0</font></a></p><p><font size="3">和我一起学数据透视表(题5 动态数据) </font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312068&id=41230&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312068&id=41230&skin=0</font></a></p><p><font size="3">和我一起学数据透视表(题6 显示部分数据与排序) </font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312080&id=41232&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312080&id=41232&skin=0</font></a></p><p><font size="3">和我一起学数据透视表(题7 多重合并计算) </font></p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312158&id=41241&skin=0"><font size="1">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312158&id=41241&skin=0</font></a></p><p><font size="3">和我一起学数据透视表(题8 多字段多重合并计算)</font> </p><p><a href="http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312400&id=41263&skin=0">http://www.excelpx.com/dispbbs.asp?BoardID=116&replyID=312400&id=41263&skin=0</a></p>[此贴子已经被作者于2009-9-30 6:37:24编辑过]