2014进阶课程函数.pptVIP

案例：突出显示高工资人员 工资金额在5500元以上的人员名称自动变红色 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 案例：限制销售日期的有效性 销售业绩表销售日期，只能填写2008-4-1到2008-6-1之间的数据 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 数据的排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 案例：拼音排序 员工档案表按姓名的汉语拼音顺序排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 案例：笔划排序 员工档案表按姓名的笔划排序（中文版） Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 案例：自定义排序（一） 企业员工档案数据清单表按照学位高低排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 文本函数 left (文本对象，截取位数) right (文本对象，截取位数) mid(文本对象，开始位数，截取位数) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 案例：整理产品型号 将品牌和型号分开两列显示 使用分列功能 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 常见图表的制作技巧 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 认识图表商务模型 创建图表的方法 一键生成法 按部就班法 用图表传递信息的类型 常用图表类型及选择技巧 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 图表类型的选择 柱形图：强调的是数据区中所有的数据 条形图：与柱形图强调要点相同，建议使用在横轴为时间线时 折线图：强调的是数据趋势 饼图：强调的是部分对整体的贡献 XY散点图：强调X轴与Y轴之间的相对关系 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 图表的基本修改方式 移动和调整图表 更改图表类型 移动图表元素 删除、格式化图表元素 修改原则： 看得见的部分双击 看不见的单击右键 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 200