VBA and Macros: Microsoft Excel 2010 (MrExcel Library)

3,93 valoración promedio
( 67 valoraciones por Goodreads )
 
9780789743145: VBA and Macros: Microsoft Excel 2010 (MrExcel Library)

AUTOMATE REPORTS

BUILD FUNCTIONS

VISUALIZE DATA

WRITE FAST, RELIABLE SCRIPTS

 

 

Microsoft Excel 2010

VBA AND MACROS:

SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS!

 

Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won’t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010’s most powerful new features. Learning advanced Excel scripting has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel.

 

 

· Work efficiently with ranges, cells, and R1C1-style formulas

· Build super-fast applications with arrays

· Customize the Excel 2010 Ribbon to run your macros

· Write Excel 2010 VBA code that works on older versions of Excel

· Create custom dialog boxes to collect information from your users

· Use error handling to make your VBA scripts more resilient

· Use Web queries to import data from virtually any online source

· Master advanced techniques such as classes and collections

· Use Excel VBA to control other Office programs...even control Windows itself,

via the Windows API

· Create add-ins to share or sell your programs

 

About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will

 

· Dramatically increase your productivity—saving you 50 hours a year or more

· Present proven, creative strategies for solving real-world problems

· Show you how to get great results, no matter how much data you have

· Help you avoid critical mistakes that even experienced users make

 

 

"Sinopsis" puede pertenecer a otra edición de este libro.

About the Author:

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Financemagazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. 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 his sons, Josh and Zeke.

 

Tracy Syrstadis the project manager for the MrExcel consulting team. She was introduced to Excel VBA by a co-worker who encouraged her to learn VBA by recording steps and then modifying the code as needed. Her first macro was a simple lookup and highlight for a parts index, although it hardly seemed simple then. But she was encouraged by this success and others to follow. She’ll never forget the day when it all clicked. She hopes this book will bring that click to its readers sooner and with less frustration. She lives near Sioux Falls, South Dakota, with her husband, John.

 

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Jelen, Bill; Syrstad, Tracy
Editorial: Que Publishing (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 1
Librería
Griffin Books
(Stamford, CT, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing, 2010. Paperback. Estado de conservación: New. As new clean tight and bright Please email for photos. Larger books or sets may require additional shipping charges. Books sent via US Postal. Nº de ref. de la librería 79304

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 16,33
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,38
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Jelen, BillSyrstad, Tracy
Editorial: Prentice Hall
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Cantidad: > 20
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración
[?]

Descripción Prentice Hall. Estado de conservación: New. Brand New. Nº de ref. de la librería 0789743140

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 21,83
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,95
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Bill Jelen; Tracy Syrstad
Editorial: Que Publishing (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Primera edición Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing, 2010. Paperback. Estado de conservación: New. book. Nº de ref. de la librería M0789743140

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 27,01
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Bill Jelen, Tracy Syrstad
Editorial: Que Publishing (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing, 2010. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0789743140

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 25,72
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,37
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Bill Jelen, Tracy Syrstad
Editorial: Pearson Education (US), United States (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 10
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción Pearson Education (US), United States, 2010. Paperback. Estado de conservación: New. Language: English . Brand New Book. AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010 s most powerful new features. Learning advanced Excel scripting has never been easier. You ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. * Work efficiently with ranges, cells, and R1C1-style formulas * Build super-fast applications with arrays * Customize the Excel 2010 Ribbon to run your macros * Write Excel 2010 VBA code that works on older versions of Excel * Create custom dialog boxes to collect information from your users * Use error handling to make your VBA scripts more resilient * Use Web queries to import data from virtually any online source * Master advanced techniques such as classes and collections * Use Excel VBA to control other Office programs.even control Windows itself, via the Windows API * Create add-ins to share or sell your programs About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website , these books will * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make. Nº de ref. de la librería BZV9780789743145

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 32,00
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Bill Jelen, Tracy Syrstad
Editorial: Pearson Education (US), United States (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 10
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración
[?]

Descripción Pearson Education (US), United States, 2010. Paperback. Estado de conservación: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won t find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on it. It also shows you how to capture data from anywhere and use it anywhere, and helps you automate Excel 2010 s most powerful new features. Learning advanced Excel scripting has never been easier. You ll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutions, straight from MrExcel. * Work efficiently with ranges, cells, and R1C1-style formulas * Build super-fast applications with arrays * Customize the Excel 2010 Ribbon to run your macros * Write Excel 2010 VBA code that works on older versions of Excel * Create custom dialog boxes to collect information from your users * Use error handling to make your VBA scripts more resilient * Use Web queries to import data from virtually any online source * Master advanced techniques such as classes and collections * Use Excel VBA to control other Office programs.even control Windows itself, via the Windows API * Create add-ins to share or sell your programs About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website , these books will * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make. Nº de ref. de la librería BTE9780789743145

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 33,40
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Jelen, Bill, Syrstad, Tracy
Editorial: Que Publishing (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing, 2010. Paperback. Estado de conservación: New. Never used!. Nº de ref. de la librería P110789743140

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 39,00
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,68
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Bill Jelen; Tracy Syrstad
Editorial: Que Publishing (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Tapa blanda Cantidad: > 20
Librería
Palexbooks
(Sanford, NC, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing, 2010. Estado de conservación: New. Brand new! Please provide a physical shipping address. Nº de ref. de la librería 9780789743145

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 42,29
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,53
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Jelen, Bill; Syrstad, Tracy
Editorial: Que Publishing
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos PAPERBACK Cantidad: 3
Librería
BarristerBooks
(Lawrence, KS, Estados Unidos de America)
Valoración
[?]

Descripción Que Publishing. PAPERBACK. Estado de conservación: New. 0789743140 BRAND NEW W/FAST SHIPPING! This item is: VBA and Macros: Microsoft Excel 2010, 1st Ed., 2011, by Jelen, Bill^Syrstad, Tracy; FORMAT: Paperback; ISBN: 9780789743145. Choose Expedited for fastest shipping! Our 98%+ rating proves our commitment! We cannot ship to PO Boxes/APO address. To avoid ordering the wrong item, please check your item's ISBN number!. Nº de ref. de la librería P9780789743145

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 49,89
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Jelen, Bill/ Syrstad, Tracy
Editorial: Que Pub (2010)
ISBN 10: 0789743140 ISBN 13: 9780789743145
Nuevos Paperback Cantidad: 1
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción Que Pub, 2010. Paperback. Estado de conservación: Brand New. 1st edition. 592 pages. 9.11x7.00x1.29 inches. In Stock. Nº de ref. de la librería 0789743140

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 47,77
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,66
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda