Excel fly! Workplace Office efficiency Cheats (@ MrExcel works. and a(Chinese Edition)

Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Paperback. Pub Date: Unknown Pages: 396 in Publisher: Publishing House of Electronics Industry List Price: 59.00 yuan: Linshu Ming Press: Electronic Industry Press ISBN: 9787121177415 Pages: 396 Edition: 1 Binding: Paperback: 16 Published :2012 -8-1 printing time: words: Product ID: 22844979 Description This is a book on how to effectively use Excel and Access. to improve workplace efficiency. The book cohesion of thinking over the years on how to improve personal productivity using Excel and Access unique. The book is divided into two parts. the decisive battle Excel Excel to fly. In the first part. the vast majority of Excel advanced features. the Excel management application problems should be avoided. Excel modeling and reporting automation infrastructure. as well as Excel and reporting automation; introduced in the second part. Excel users need to know Access knowledge. Excel. and Access integration applications. as well as to build lean office. The book is characterized by emphasis on combat. combined with a variety of management scenarios of Office technology cleverly explain. help you become efficient in the workplace lazy. a real office hero. This book is suitable for a preliminary basis for the Excel. are confused at how to further improve own Excel Management application level as well as those who drowned in the vast Excel isolated skills. suffer from failure to master Excel essence of not giving top priority to Excel free application failed to meet state friends. About the author Lin Shuming. MBA Microsoft Certified Excel Expert. Microsoft Certified Office Masters. has for many years a well-known foreign companies working experience. well versed in the Microsoft Office business efficiency Road. The author focuses on how to use Excel and Access to enhance the efficiency of departments and individuals. In this book. the authors will share experience and your. to explore the infinite possibilities of Excel and Access business applications. Reading this book. you may sigh. Excel and Access could be so strong! Through the author's the Sina microblogging _AT_ MrExcel you can communicate with the author. Chapter 1 of the directory first part of the decisive battle Excel Excel. Unbearable Weight 21.1 terrible sort of misuse 71.5 31.2 delete some cell 51.3 61.4 repeated open file function open self-deceiving 121.6 111.6 Excel with trade secrets 121.6.1 Excel. manually calculate. 2 to prevent Excel leaks 141.7 backup! Back up! 161.8 Excel. workplace amulet 181.9 to quickly learn Excel 191.9.1 191.9.2 a dance master key to survival 201.9.3 network survival 242.1 intelligent sensing 22 Chapter 2 Excel you must understand menu 272.2.1 Separation data 272.2 252.2 auxiliary column. every other line to insert a blank line 272.2.3 always revert to the state prior to the sort a true date 332.4.2 342.4.3 DATEDIF function 382.5 references. of 282.3 text and the date and time of the digital 292.4 322.4.1 date and time of the essence! Reference! The name 473.1 43 Chapter 3 of 392.6 to identify the active cell in Excel to a single cell named 473.2 named range of cells 483.3 text or numeric naming 503.4 503.5 Excel a name to the formula auto-naming feature 51 Chapter 4 Excel smarter 544.1 advanced features 715.1 67 Chapter 5 Excel the IFERROR function 544.2 the VLOOKUP function 564.3 584.4 CHOOSE INDEX and MATCH function function 604.5 OFFSET function 614.6 INDIRECT function 624.7 SUMPRODUCT function Advanced Data validity 715.2 Advanced conditional formatting 745.3 Excel Advanced Filter 805.3.1 Advanced Filter 815.3.2 special conditions under Advanced Filter controls in Excel 85 Chapter 6 876.1 checkbox control 896.2 combo box control 92 Chapter 7 import data 1027.4 1007.3 import database import Excel data of external data 977.1 987.2 import pages data import text data 1077.5 set external data refresh way to 111 first 8 data perspectiv. …