Items related to 正版现货 Excel2010数据&#...
Synopsis
《Excel2010数据透视表应用大全》全面系统地介绍了Excel2010数据透视表的技术特点和应用方法，深入揭示数据透视表的原理，并配合大量典型实用的应用实例，帮助读者全面掌握Excel2010数据透视表技术。《Excel2010数据透视表应用大全》共20章，分别介绍了创建数据透视表、改变数据透视表的布局、刷新数据透视表、数据透视表的格式设置、在数据透视表中排序和筛选、数据透视表的切片器、数据透视表的项目组合、在数据透视表中执行计算、数据透视表函数的综合应用、创建动态数据透视表、创建复合范围的数据透视表、通过导入外部数据"编辑OLEDB查询"创建数据透视表、使用"MicrosoftQuery"数据查询创建透视表、利用多样的数据源创建数据透视表、PowerPivot与数据透视表、数据透视表与VBA、发布数据透视表、使用图形展示数据透视表、数据透视表打印技术及数据透视表技术的综合运用等内容。《Excel2010数据透视表应用大全》适用于各个层次的Excel用户，既可以作为初学者的入门指南，又可作为中、高级用户的参考手册。书中大量的实例还适合读者直接在工作中借鉴。《Excel2010数据透视表应用大全》由多位MVP倾力打造，多年经验之无保留分享。《Excel2010数据透视表应用大全》可教初学者入门，教入门者进阶，教进阶者高级应用。《Excel2010数据透视表应用大全》讲授数据透视表的多项绝秘应用，让一切成为可能。《Excel2010数据透视表应用大全》全面向你展示数据透视表的神奇之处--不需要任何公式与函数，在一分钟之内就能创建精美的高级报表。《Excel2010数据透视表应用大全》精选来自ExcelHome的海量实例，向你展示如何在几秒钟内轻松将数百万行数据制作成专业报表。第1章创建数据透视表1.1什么是数据透视表1.2数据透视表的数据源1.3自己动手创建第一个数据透视表1.4数据透视表的用途1.5何时使用数据透视表分析数据1.6数据透视表结构1.7数据透视表字段列表1.8数据透视表中的术语1.9【数据透视表工具】1.9.1【选项】选项卡的主要功能1.9.2【设计】选项卡的主要功能第2章改变数据透视表的布局2.1改变数据透视表的整体布局2.2数据透视表页面区域的使用2.2.1显示报表筛选字段的多个数据项2.2.2水平并排显示报表筛选字段2.2.3垂直并排显示报表筛选字段2.2.4显示报表筛选页2.3启用Excel2003经典数据透视表布局2.4整理数据透视表字段2.4.1重命名字段2.4.2整理复合字段2.4.3删除字段2.4.4隐藏字段标题2.4.5活动字段的折叠与展开2.5改变数据透视表的报告格式2.5.1改变数据透视表的报表布局2.5.2分类汇总的显示方式2.5.3在每项后插入空行2.5.4总计的禁用与启用2.5.5合并且居中排列带标签的单元格2.6清除已删除数据的标题项2.7数据透视表的复制和移动2.7.1复制数据透视表2.7.2移动数据透视表2.8影子数据透视表2.9获取数据透视表的数据源信息2.9.1显示数据透视表数据源的所有信息2.9.2显示数据透视表某个项目的明细数据2.9.3禁止显示数据源的明细数
"synopsis" may belong to another edition of this title.
- Publisher人民邮电出版社
- Publication date2013
- ISBN 10 7115300232
- ISBN 13 9787115300232
- BindingPaperback
- LanguageChinese
- Edition number1
Buy New
View this item
US$ 107.42
US$ 18.00 shipping from China to U.S.A.
Destination, rates & speedsSearch results for 正版现货 Excel2010数据&#...
Stock Image
???? Excel2010????????? (???) ????? excel 2010 ?? ?? ?????????
Seller: medimops, Berlin, Germany
Seller rating 5 out of 5 stars
Condition: good. Befriedigend/Good: Durchschnittlich erhaltenes Buch bzw. Schutzumschlag mit Gebrauchsspuren, aber vollständigen Seiten. / Describes the average WORN book or dust jacket that has all the pages present. Seller Inventory # M0B00ASURJGA-G
Quantity: 1 available
Stock Image
Excel 2010 PivotTable application Daquan (with a CD-ROM)(Chinese Edition)
ISBN 10: 7115300232
ISBN 13: 9787115300232
New
paperback
Seller: liu xing, Nanjing, JS, China
Seller rating 5 out of 5 stars
paperback. Condition: New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: 2013 Pages: 476 Language: Chinese in Publisher: People's Posts and Telecommunications Publishing House Excel 2010 PivotTable table application Encyclopedia comprehensive systematic introduction to Excel 2010 PivotTable technical characteristics and application method. and reveal the data perspective of the principle of the table. with a large number of typical application examples to help the reader to fully grasp the technology of Excel 2010 PivotTable. Excel 2010 PivotTable table application Daquan Chapter 20. respectively. create a PivotTable to change the layout of the PivotTable Refresh PivotTable PivotTable formatting. sorting and filtering PivotTable data PivotTable slicer. the PivotTable project combination. perform calculations in a PivotTable. PivotTable function application. create a dynamic PivotTable to create a composite range PivotTable Edit OLE import external data DB query create a PivotTable. use the Microsoft Query data query to create a pivot table. using a variety of data sources to create a PivotTable. the PowerPivot PivotTable PivotTable VBA Post PivotTable. using a graphical presentation of data PivotTable PivotTable printing technology and PivotTable technology use. Excel 2010 PivotTable table application Daquan applies to all levels of Excel users. either as the Getting Started Guide for beginners. but also as advanced users reference manual. Book a large number of instances for readers to learn work directly. Contents: Chapter 1 to create a PivotTable 1.1 1.2 PivotTable PivotTable data source 1.3-yourself to create a PivotTable uses the first PivotTable 1.4 1.5 1.6 PivotChart PivotTable analysis data when table structure 1.7 PivotTable Field List 1.8 PivotTable term 1.9 [PivotTable Tools] 1.9.1 [Options] tab 1.9.2 [design] tab 2 the overall layout of the 2.2 Chapter 2.1 change the PivotTable to change the layout of the PivotTable PivotTable area of ??the page to use 2.2.1 report filter field multiple data items 2.2.2 level displayed side-by-side vertical report filter field 2.2.3 Show Report Filter field 2.2.4 side-by-side to display the report filter page 2.3 enable Excel 2003 Classic PivotTable layout 2.4 finishing PivotTable Field 2.4.1 rename field 2.4.2 2.4.3 finishing composite field Delete field 2.4 .4 hidden field headers 2.4.5 active field folding and unfolding 2.5 the change PivotTable report format 2.5.1 change PivotTable report layout 2.5.2 subtotals displayed after 2.5.3 in each insert 2.7.1 copy copy and move heading blank lines 2.5.4 Total disable and delete data of the to enable 2.5.5 Hopewell and center arranged with a label cell 2.6 Clear 2.7 PivotTable PivotTable 2.7.2 mobile data get PivotTable data source information 2.9.1 2.8 shadow PivotTable Pivot Table 2.9 displays all information 2.9.2 PivotTable data source shows a detail PivotTable 2.9.3 prohibit the display data source detail data in Chapter 3 Refresh PivotTable 3.1 manually refresh the PivotTable 3.2 when the file is opened automatically refresh the 3.3 refresh link together PivotTable 3.4 refresh refresh timer reference external data PivotTable 3.5 3.6 3.7 All VBA code to set automatic refresh Refresh PivotTable shared cache PivotTable 3.8 3.9 3.10 PivotTable refresh Chapter 4 Notes PivotTable postponed layout update format settings 4.1 PivotTable format 4.1.1 automatically apply PivotTable Style 4.1.2 PivotTable refresh how to keep the column width adjusted the format of numeric data in certain types of projects 4.1.3 Batch setting PivotTable format 4.1.4 Modify PivotTable 4.1.5 4.1.6 custom number format set error values ??displayed 4.1.7 specific data processing the blank PivotTable data items 4.2 PivotTable with conditional formatting 4.2.1 highlighted PivotTable in 4.2.2 PivotTable Data of 4.2.3 the PivotTable icon set 4.2.4 PivotTable Levels 4.2.5 Modify PivotTable in application Chapter 5 o. Seller Inventory # NG008031
Quantity: 1 available