The efficient office workplace Tong: an Excel 2010 financial management and accounting applications (with CD-ROM)(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: October 2012 Pages: 425 Language: Chinese in Publisher: China Railway Press efficient office: workplace through a variety of Excel 2010 financial management and accounting applications encountered mainly in financial management and accounting applications for Excel The elaborate practical problems. Britannica workplace integrated application in accordance with the Basics Review workplace issues to solve the structure of all content is divided into three parts: Review of the basics is to select the use of Excel when dealing with financial management and accounting calculations must master knowledge. Solve workplace problems efficient office workplace through: Excel 2010 financial management and accounting applications. the main content. the author cites a large variety of practical problems in the workplace. through workplace scenarios. Solutions and solution The writing structure allows readers to to clear work how to solve the problem. Workplace Applications section of the workplace problem solving section separate issues through multiple instances linking up. showing the complete production process. so that the reader quickly applied to the practical work of the knowledge. Efficient office workplace through: Excel 2010 financial management and accounting applications mainly localized in the hope to quickly master the use of Excel for Financial Management and Accounting calculation and solve practical problems in day-to-day office beginning and intermediate users. apply to the office staff of different ages financial officers. civil servants. especially the staff just entering the job market to solve real problems. a very good guide. Contents: Recalling the first chapter of the basic knowledge of making Excel table 1.1 input and edit data 1.1.1 edit data input data to create a workbook 1.1.2 1.1.3 1.1.4 save the workbook 1.1.5 Close the workbook is opened 1.2 set Format Cells 1.2.1 1.2.2 1.3 settings adjust 1.3.1 Other tabular format cells row height and column width 1.3 1.2.3 1.2.4 set the cell borders and shading to set the digital format set alignment set the font format. 2 Application Form style Print Exce1 form 1.3.3 Conditional Formatting 1.3.4 set worksheet background 1.4 1.4.1 1.4.2 1.4.3 Print Preview Print effect form set page layout application of formulas and functions 2.1 understand the formula and The input method function of the the formula input methods of the classification of the function of the concept and structure of the concept and structure of the formula of the function 2.1.1 2.1.2 function 2.1.3 2.1.4 2.1.5 2.2 reference to a cell type the 2.2.1 relative reference 2.2. absolute reference 2.2.3 mixed references 2.2.4 relative reference absolute reference switch 2.3 formulas and functions commonly referenced and mixed operation 2.3.1 move and copy formulas 2.3.2 2.3.3 tracking unit about common errors in formulas the management and protection of Excel spreadsheet grid 2.3.4 formula step-by-step evaluates 2.4 commonly used financial function 2.4.1 principal and interest the Financial Functions 2.4.2 Investment income class financial the function 2.4.3 assets depreciation class financial functions Chapter 3.1 sort of data 3.1.1 single keyword data sorting 3.1.2 Multi-keyword data sorting 3.1.3 Summary 3.2.1 create subtotals 3.2.2 show or hide the detail data-defined Sort 3.2 data classification 3.2.3 edit or Clear subtotals 3.3 using the data record single 3.3.1 add records 3.3.2 Find. modify and delete records 3.4 Data Screening 3.4.1 AutoFilter 3.4.2 custom filters 3.4.3 Advanced Filter 3.5 protected form data 3.5.1 protection work Book 3.5.2 Protect Sheet 3.5.3 protect worksheet range of cells Chapter chart application the Chart data 4.1 4.1.1 Recognizing create charts 4.1.3 Editing Chart 4.1.2 Chart 4.1.4 beautify Figure 4.2 4.3.1 Create a data use the Sparklines 4.2.1 Create Mi.