Artículos relacionados a VBA and Macros for Microsoft Office Excel 2007 (Business...
Sinopsis
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”
―Jerry Kohl, president of Brighton Collectibles
Develop your Excel macro programming skills using VBA instantly with proven techniques
Automate Reports
Handle Errors
Master Pivot Tables
Produce Charts
Build User-Defined Functions
Migrate to Excel 2007
Query Web Data
Build Dialog Boxes
Use Data Visualizations
Automate Word
You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.
- Learn VBA syntax as easy-to-understand English
- Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters
- Save hours per week by automating redundant tasks
- Create applications built on top of Excel with custom dialog boxes
- Automatically produce hundreds of Excel reports in seconds
- Understand how changes in Excel 2007 impact your VBA macros
Introduction 1
1 Unleash the Power of Excel with VBA 7
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29
3 Referring to Ranges 61
4 User-Defined Functions 75
5 Looping and Flow Control 101
6 R1C1-Style Formulas 121
7 What’s New in Excel 2007 and What's Changed 135
8 Create and Manipulate Names in VBA 143
9 Event Programming 155
10 UserForms--An Introduction 177
11 Creating Charts 197
12 Data Mining with Advanced Filter 249
13 Using VBA to Create Pivot Tables 281
14 Excel Power 337
15 Data Visualizations and Conditional Formatting 373
16 Reading from and Writing to the Web 393
17 XML in Excel 2007 413
18 Automating Word 421
19 Arrays 441
20 Text File Processing 449
21 Using Access as a Back End to Enhance Multi-User Access to Data 461
22 Creating Classes, Records, and Collections 477
23 Advanced UserForm Techniques 493
24 Windows Application Programming Interface (API) 517
25 Handling Errors 529
26 Customizing the Ribbon to Run Macros 543
27 Creating Add-Ins 569
Index 577
"Sinopsis" puede pertenecer a otra edición de este libro.
Acerca del autor
Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill has made more than 50 guest appearances on Call for Help with Leo Laporte and has produced more than 250 episodes of his daily video podcast, Learn Excel from MrExcel. He is the host of Total Training’s Excel 2007 Advanced DVD. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Before founding MrExcel.com, Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke.
Tracy Syrstad remembers the painful trek up the VBA learning curve while developing applications for herself and co-workers at a former job. Now, as the project manager for the MrExcel consulting team, she enjoys helping clients develop custom solutions for their unique situations, observing the myriad ways people use Excel and other Microsoft Office applications.
"Sobre este título" puede pertenecer a otra edición de este libro.
Comprar nuevo
Ver este artículo
EUR 38,67
EUR 19,79 gastos de envío desde España a Estados Unidos de America
Destinos, gastos y plazos de envío
Resultados de la búsqueda para VBA and Macros for Microsoft Office Excel 2007 (Business...
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007
Librería: ThriftBooks-Atlanta, AUSTELL, GA, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.25. Nº de ref. del artículo: G0789736829I4N00
Cantidad disponible: 1 disponibles
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007
Librería: ThriftBooks-Dallas, Dallas, TX, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 2.25. Nº de ref. del artículo: G0789736829I4N00
Cantidad disponible: 1 disponibles
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
Librería: AwesomeBooks, Wallingford, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. VBA and Macros for Microsoft Office Excel 2007 (Business Solutions) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Nº de ref. del artículo: 7719-9780789736826
Gastos de envío:
EUR 5,77
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío
Cantidad disponible: 2 disponibles
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
Publicado por
Pearson Education (US), United States, 2007
ISBN 10: 0789736829
ISBN 13: 9780789736826
Antiguo o usado
Paperback
Librería: WorldofBooks, Goring-By-Sea, WS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. In this day and age of too much information and not enough time, the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of. Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesnt work and you cant make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. Learn VBA syntax as easy-to-understand English Automate Excels power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesnt It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 Whats New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Nº de ref. del artículo: GOR002126610
Gastos de envío:
EUR 6,47
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío
Cantidad disponible: 1 disponibles
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007 (Business Solutions)
Librería: Bahamut Media, Reading, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Nº de ref. del artículo: 6545-9780789736826
Gastos de envío:
EUR 8,07
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío
Cantidad disponible: 2 disponibles
Imagen del vendedor
VBA & Macros For Micorosoft Office Excel 2007
Librería: Agapea Libros, Malaga, MA, España
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Idioma/Language: Inglés. Â"In this day and age of Â'too much information and not enough time,Â' the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of. Â" ÂJerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesnÂ't work and you canÂ't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. Learn VBA syntax as easy-to-understand English Automate ExcelÂ's power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why DoesnÂ't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 WhatÂ's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing 449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577 *** Nota: Los envíos a España peninsular, Baleares y Canarias se realizan a través de mensajería urgente. No aceptamos pedidos con destino a Ceuta y Melilla. Nº de ref. del artículo: 1204037
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
VBA and Macros for Microsoft Office Excel 2007
Publicado por
Pearson Education (US), 2007
ISBN 10: 0789736829
ISBN 13: 9780789736826
Nuevo
Paperback / softback
Librería: THE SAINT BOOKSTORE, Southport, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback / softback. Condición: New. New copy - Usually dispatched within 4 working days. 1032. Nº de ref. del artículo: B9780789736826
Gastos de envío:
EUR 19,73
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
VBA & Macros For Micorosoft Office Excel 2007
Librería: moluna, Greven, Alemania
Calificación del vendedor: 5 de 5 estrellas
Condición: New. KlappentextrnrnThis book will dramatically increase white collar productivity. Given the current state of MIS departments, this reader is probably stuck in a user department and can t get the reports they need in a timely manner. They ve taken m. Nº de ref. del artículo: 2145921561
Gastos de envío:
EUR 48,99
De Alemania a Estados Unidos de America
Destinos, gastos y plazos de envío
Cantidad disponible: Más de 20 disponibles