Excel efficient (Revised) (data sorting sorting office - data processing and analysis(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: Unknown in Publisher: People's Posts and Telecommunications Press List Price: 49.80 yuan Author: Publisher: People's Posts and Telecommunications Press ISBN: 9787115286291 Yema: Revision: Binding: Folio: Published :2012 -7-1 printing time: Words: Goods ID: 22809554 Description Excel efficient office - Data Processing and Analysis (Revised Edition) according to the main features of the decision-making and management of modern enterprises from a new perspective. a thorough introduction to the powerful processing capabilities of Excel 2003 in the enterprise decision-making and management of specific applications. The book is divided into 15 chapters. data input. data formatting. sorting. filtering. subtotals PivotTable formulas and functions. charts. Excel and the external database interaction. the use of data analysis tools. sampling and survey data processing. production and decision-making data processing. economic data processing. sales data processing. financial management decision-making data processing. business decision-making data processing and engineering data processing. Excel efficient office - Data Processing and Analysis (Revised Edition) fully consider the actual needs of the decision makers and management personnel. an additional instance REVIEW most of the chapter. introduced Excel knowledge and design ideas examples are given to expand to meet the needs of different users. Whether a beginner or have some basis reader through learning book can easily grasp the Excel data processing and analysis methods.Explain through full voice. scenario-based teaching. the book knowledge. in-depth explanations. step-by-step guide readers to master the use of Excel for data processing and analysis of the various operations and application. In addition. the CD-ROM with the book all instances of the corresponding material. templates and source files; spree and a value. containing a variety of day-to-day work of the post Manual. 1100 Office classic practical the template Excel application skills and FAQ 300 cases. Excel is efficient office - Data Processing and Analysis (Revised Edition) read for personnel engaged in corporate decision-making. management. and project management work for colleges and professional students learning. but also can be used as Excel decision-making management short course training materials. 21.1.2 Date of Introduction Table of Contents Chapter 1 data input 1.1 Basic data input 21.1.1 numeric data input and time data input 31.1.3 text data the input 31.2 validity data input 41.2.1 custom fill sequence 41.2.2 custom fill range 51.3 regular data input 71.3.1 copied filled fill 71.3.2 sequence 81.3.3 custom fill 81.4 input of the same data in multiple cells in 91.4.1 enter the same formatted data to enter the same data in multiple sheets 91.4.2 101.5 record single input data 10 Chapter 2 Data 2.1 Basic data formatting 142.1.1 text formatting the 142.1.2 value formatting 152.1. conditional formatting of the date and time formatting 162.2 172.3-style definition of the set and use 182.3.1 built-in custom style style 182.3.2 182.3.3 style editor of 192.4 set a custom format 19 2.4.1 text and spaces 212.4.3 202.4.2 decimal point. space. color and condition currency. percentage. and scientific notation the 222.4.4 percentage 222.4.5 date and time 23 Chapter 3. sorting. filtering. and classification summary 3.1 Sort 263.1.1 single keyword sorting 263.1.2 multiple keywords sort 273.1.3 custom sort 283.2 screening 293.2.1 293.2.2 custom filters 303.2.3 Advanced Filter 311. while meeting multiple conditions screened 312 AutoFilter. meet one of the conditions of the screening 323 Screening 323.3 Classification summary self-defined conditions 333.3.1 simple classification summary 333.3.2 senior classification summary the 343.3.3 nested subtotals 353.3.4 Group and Outline 363.3.5 page display sub. …