Excel：数据筛选排序公式函数的简单入门

《Excel：数据筛选排序公式函数的简单入门》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Excel：数据筛选、排序、公式、函数的简单入门Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.前言：版本之争1上篇：数据筛选、排序与制表规范2下篇：公式与函数3后记：上网求助4Evaluationonly.CreatedwithAspos

2、e.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.版本之争Excel2003：手动挡轿车Excel2007、2010：自动挡轿车Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011

3、AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.版本之争Excel2003的现状：①用户依然占大多数②2007版或2010版的某些功能的确强过2003版，但基础功能却大同小异，甚至没有变化。本报告立足基础，示例用Excel2003版，但尽量不涉及版本功能。Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2

4、004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.数据筛选、排序与制表规范Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5

5、.2.0.0.Copyright2004-2011AsposePtyLtd.引例下表是《来访》表的一部分，有问题吗Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.第一宗罪——日期录入不规范日期该如何录入？格式统一就行吗？Evaluation

6、only.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.日期常见的错误录入方式“点”型——以“.”为分隔符录入的日期。比如：2011.1.10；13.05.08。“空格”型——以“”为分隔符录入的日期。比如：2011110；130508。Evaluationonly.

7、CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.Evaluationonly.CreatedwithAspose.Slidesfor.NET3.5ClientProfile5.2.0.0.Copyright2004-2011AsposePtyLtd.日期常见的正确录入方式“减号”型——以“-”为分隔