Nova knjiga 101 Excel makro spreman za korišćenje
101 ready-to-use-Excel MacrosSave time and be more productive with this helpful guide to Excel macros!
While most books about Excel macros offer only minor examples, usually
aimed at illustrating a particular topic, this invaluable resource
provides you with the tools needed to efficiently and effectively
program Excel macros immediately. Step-by-step instructions show you how
to create VBA macros and explain how to customize your applications to
look and work exactly as you want them to. By the end of the book, you
will understand how each featured macro works, be able to reuse the
macros included in the book and online, and modify the macro for
personal use.
Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
Outlines a problem that needs to be solved and provides the
actual Excel macro, as well as the downloadable code, to solve the
problem
Provides an explanation of how each macro works and where to use the macro
With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive. ContentsIntroduction 1
Part I: Getting Started with Excel Macros 5
Part II: Working with Workbooks 37
Part III: Automating Worksheet Tasks with Macros 71
Part IV: Selecting and Modifying Ranges 103
Part V: Working with Data 137
Part VI: Working with PivotTables 187
Part VII: Manipulating Charts with Macros 233
Part VIII: E-Mailing from Excel 253
Part IX: Integrating Excel and Other Office Applications 273
Index 302AuthorMike Alexander is a
Microsoft Certified Application Developer (MCAD) and author of several
books on advanced business analysis with Microsoft Access and Excel. He
has more than 15 years of experience consulting and developing Office
solutions. Michael has been named a Microsoft MVP for his ongoing
contributions to the Excel community. In his spare time, he runs a free
tutorial site, www. datapigtechnologies. com, where he shares Excel and
Access tips.
John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona. Visit his website at http://spreadsheetpage. com. Preuzmite kod iz knjigeSa sajta Wileya preuzmite izvorni kod za knjigu. KODVaše mišljenje nam je korisnoSvako vaše mišljenje o knjizi, njenoj potrebi za svakodnevni rad i život bi nam bilo od koristi.