110722Excel基础应用培训课件.ppt

Excel 应用基础 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 教学内容?第一讲:初识 excel 2003 ?第二讲: 函数与公式?第三讲: 常见问题及解决方法?第四讲:图表?第五讲:数据分析?作业布置 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 第一讲:初识 excel 2003 ?一、概述?二、窗口组成与基本概念?三、工作表操作?四、数据输入?五、单元格定位与选择 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 一、概述? Excel 是微软公司推出的一个功能强大的电子表格制作和数据处理软件,可以很方便地使用它来编辑文字、图表和数据。同时,它还是一个强大的分析软件,能够对数据进行各种计算、排序、筛选等操作。 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 二、窗口组成与基本概念 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 三、工作表操作?1、插入工作表?2、删除工作表?3、重命名工作表?4、移动或复制工作表?5、重排窗口(工作表) ?6、工作表的显示和隐藏 Evaluation only. Evaluation only. Created with Client Profile . Created with Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Copyright 2004-2011 Aspose Pty Ltd. 四、数据输入?数字----------------------- ?分数----------------------- ?正、负数----------------- ?输入小数----------------- ?日期---------------------- ?文本类型的数字-------- ?时间---------------------- 数字键区直接输入先输入 0 空格再输入分数“+”“-”“. ”“/”或“-”先输入“’”,再输入数字时间用“:”来输入 Evaluation only. Evaluation only. Cr