Excel 2010 data processing and analysis from entry to the proficient (high-definition video version) (with DVD-ROM disc 1)(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: December 2012 Pages: 441 Language: Chinese. English in Publisher: Tsinghua University Press Excel 2010 information analysis and management. to help users make better. more informed decisions. Excel 2010 data processing and analysis from entry to the proficient (HD video version) from the Basic Excel data analysis tools to start gradually in depth to explain the method of data analysis and processing. including the basics of Excel data processing and analysis. the formula with the basis of the use of the function. and how to use persuasive charts to enhance data analysis. the use of the various functions in Excel. the chart tips. PivotTable. and a perspective view of the use of macros and VBA to automate analysis. array and the use of circular references. debugging and testing of self-defined functions. and data processing using VBA. Large lecture hall of the the Tsinghua Society video efficient office Video Lecture: Excel 2010 data processing and analysis from entry to the proficient (HD video version) In addition to the examples in the form to explain the use of knowledge. classification explain use Excel daily office. human resources. sales and finance work. Tsinghua Society video lecture hall large efficient office video Lecture: Excel 2010 data processing and analysis from entry to the proficient (HD video version) applies to Excel beginners. will Excel operation is not proficient business people as well as finishing business people need to work data also applies to in-school students and self-learners. Contents: Getting Started Chapter 1. data processing expert - Exce1 2010 video to explain: 4 paragraph 1.1 Excel data processing relations 1.2 Excel 2010 interface 1.2.1 brand new interface 1.2.2 does not like Ribbon Ribbon 1.2. the 3 shortcut menu and Mini Toolbar 1.3 Excel 2010 Basic operation 1.3.1 workbook Tip: use knowledge 1.3.2 worksheet saved as a workbook using the 1.3.3 cell operation 1.3.4 enter and edit data knowledge Tip: Enter # 1.3.5 beautification data and Table 1.3.6 Print Form 1.4 Excel 2010 Analysis Tool 1.4.1 access the database 1.4.2 PivotTable 1.4.3 grading 1.4.4 Programme Management 1.4.5 Audit function 1.4 .6 use of plug-ins to analyze 1.5 Workplace Case - making and printing aftermarket questionnaire 1.5.1 Case the target 1.5.2 making ideas workplace charging: the role of the sales questionnaire the 1.5.3 production process. to produce aftermarket questionnaire. saved and printed table .1.6 novice doubts Question 1: How to save a workbook as a low version of the file? Question 2: How to Repair a workbook? Question 3: how to make better use of the working interface? 1.7 consolidate Exercise 1: Rename the new worksheet to practice 2: Make a price list the relaxed moment Chapter 2 data processing core - Formulas and Functions video to explain: 7-segment 2.1 recognize formula the 2.1.1 formula for the composition of knowledge tips: The following numbers are not constant? 2.1.2 formulas commonly used operators. Arithmetic operators. Comparison operator 3. Text concatenation operator. Referenced operator the 2.1.3 formula for calculation of the order of knowledge prompts: changing the formula for the calculation of the order of 2.2 input and editing formulas 2.2 .1 enter the formula in the edit field or cell. enter the formula. 2.2.2 spaces blank line input via keyboard and mouse input formula 2.2.3 edit formulas skills coaching: Modify longer formulas 2.2.4 Excel displays the formula 2.2.5 hidden formula knowledge prompted: unhide the the formulas 2.3 cell range reference 2.3.1 2.3.2 relative references like clever points Altitude: Switch 2.3.3 reference. mixed reference 2.3.4 A1 reference absolute reference 2.3.5 reference to the use of the name of the other worksheet or workbook 2.4 2.4.1 What is the name 2.4.3. 2.4.2 definition name using the name defined the structure and param.…