The efficient office workplace through: Excel 2010 formulas. functions and charts (with CD 1)(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: 2012 Pages: 423 Language: Chinese in Publisher: China Railway Press efficient office workplace through: Excel 2010 formulas. functions and charts. focuses on the application of formulas and functions. and to use the charts to analyze the data. Excel data results more straightforward. The book review a workplace problem solving workplace integrated application structure through the basics all the content is divided into three parts. The basic knowledge Recalling selected use the basic operation of the calculation and analysis of data. including the basic application of the basic operation of Excel formulas and functions. and chart applications foundation to help users quickly master Excel formulas. functions and charts applications. Cited a large number of workplace problem solving various practical problems in the workplace. through workplace scenario. Solutions and solution writing structure to give readers a clear practical problems in the work should be how to solve. Workplace integrated application to workplace issues to solve part of the separate problem linked together by an instance. the reader quickly learned to be applied to the actual work of important guiding significance. Efficient office workplace through: Excel 2010 formulas. functions and charts are mainly localized in the hope to quickly grasp the knowledge of Excel formulas. functions and charts. and solve the office practical problems users at all levels. suitable for the office workers of different ages. secretarial. financial officers. civil servants. in particular. to solve the real problems of the staff just entering the workplace a great guide. Contents: Recalling the first chapter of the basics of Excel. the basic operation 1.1 workbook basic operation 1.1.1 New Workbook 1.1.2 the basic operation to save the open workbook workbook 1.1.3 1.1.4 Close the workbook 1.2 worksheet select worksheet Insert Sheet 1.2.1 1.2.2 1.2.3 Rename 1.2.4 move and copy of the worksheet worksheet 1.2.5 1.2.6 delete worksheet 1.3 cell worksheet hide and show the basic operation 1.3.1 Select the cell 1.3.2 insert and delete cells 1.3.3 Merge Cells 1.3.4 Format Cells 1.4 Data input and editing 1.4.1 1.4.2 rapid filling of the manual data entry in cell regular data 1.4. 3 Get External Data 1.4.4 special data input 1.4.5 Find and replace data 1.5 Form beautify 1.5.1 cell font settings 1.5.2 1.5.3 setting worksheet background 1.5.4 apply cell borders and shading set style of 1.5.5 apply a table style 1.6 data protection 1.6.1 encryption protect the worksheet in the workbook 1.6.2 1.6.3 Protect Workbook 1.6.4 use 1.7.1 to create the name 1.7 allows the user to edit the cell range 1.7 cell name .2 basic application of the second chapter of the name 1.7.3 Management name formulas and functions in Excel 2.1 recognize the basic structure of formula 2.1.1 formula formulas commonly used operators 2.1.2 2.1.3 formula input method 2.1.4 2.3-cell function formula editor 2.2 understanding function in Excel 2.2.1 function structure 2.2.2 Classification 2.2.3 function input reference type 2.3.1 relative references 2.3.2 2.3.3 mixed reference absolute reference 2.4 2.5 formulas and functions operating common error in the formula error processing formulas and functions 2.4.1 checking formula error 2.4.2 2.5.1 tracking cell 2.5.2 formula step-by-step evaluation 2.5.3 monitoring unit cell value changes Chapter chart applied basic 3.1 understanding Excel chart 3.1.1 What is Chart 3.1.2 Chart components create 3.2 charts the basic operation 3.2.1 3.1.3 Chart of classification Chart 3.2.2 move or copy chart 3.2.3 change the chart layout to modify the chart data source 3.2.5 Chart beautify operation 3.3 chart advanced operations 3.3.1 3.2.4 3.3.2 to create a combination chart 3.3.3 adjusted data series drawing order custom chart layout 3.3. recognize something of the effect of t.