000			02480nam a2200313Ia 4500
001			1569
008			230305s2016 xx 000 0 und d
020			_a9781530946549
043			_aen_UK
041			_aeng
245		0	_aMicrosoft Excel Macros & VBA for business users
260			_a _bAutoedición, _c2016
300			_a158 pages : illustrations ; 24 cm
500			_aa beginners guide
520			_aAn Excel® Macros and VBA book developed for business users! ; Readers will be able to refer back to this book time and time again. Written with little technical jargon and divided into five easy to follow segments. Business users of all types will learn how to automate tasks, improve productivity, and reduce the occurrence of errors in standardized processes. ; ; The book begins by providing a foundation on how Macros & VBA (Visual Basic for Applications) work, followed by step-by-step examples on recording and troubleshooting macros. Continuing with how to enhance your code with Looping and Decision Structures. From the easy to the more complex, this book has something to offer all business users. ; ; Macro Fundamentals ; · How to record a macro ; · How to modify and test macros ; · How to utilize the Personal Macro Workbook ; · How to use the debugging tools ; ; Macro Examples Include ; · Report formatting ; · Data analysis - Analyzing test results ; · Importing and parsing text and .CSV files ; · Macro to save each worksheet as a separate workbook file ; · Macros to sort worksheets either alphabetically or numerically ; · Printing all worksheets in a workbook ; · Dynamic Quarterly and Year-To-Date reporting ; ; Intermediate Topics ; · An introduction to Looping with easy to follow examples ; · How to incorporate If...Then...Else statements ; · How to incorporate Select...Case statements ; · Protecting macro code ; ; Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel's® best features.
630			_aHF COMMERCE _914
650			_aMicrosoft Excel (Computer file) _9898
650			_aVisual Basic for Applications program language) _98139
650			_aMacroprogramming _98140
650			_aMacro instructions (Electronic computers) _98141
650			_a _912
700			_aBenton, C.J. _eAuthor
902			_a660
905			_am
912			_a2016-01-01
942			_a1
953			_d2016-10-03 13:30:39
999			_c1580 _d1580