Excel 2013 VBA and Macros (MrExcel Library)

Valutazione media 4,6
( su 15 valutazioni fornite da Goodreads )
 
9780789748614: Excel 2013 VBA and Macros (MrExcel Library)

SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS!

 

Use Excel® 2013 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! You’ll discover macro
techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful
and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues
can understand and act on it...how to capture data from anywhere, and use it anywhere...how to automate
Excel 2013’s most valuable new features. Mastering advanced Excel macros 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.

 

·   Get started fast with Excel 2013 macro development

·   Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models

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

·   Build super-fast applications with arrays

·   Write Excel 2013 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 macros more resilient

·   Use web queries and new web service functions to integrate data from anywhere

·   Master advanced techniques such as classes, collections, and custom functions

·   Build sophisticated data mining and business analysis applications

·   Read and write to both Access and SQL Server databases

·   Control other Office programs–and even control Windows itself

·   Start writing Excel Apps similar to those in the Excel App Store

 

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

 

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

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,500 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 39 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. His Excel tips appear regularly in CFO Excel Pro Newsletter and CFO Magazine . Before founding MrExcel.com, Bill 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.
 
Tracy Syrstad is a developer 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 part index, although it hardly seemed simple when she did it. She was encouraged by her success with that macro and others that followed. 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.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

Edizione Internazionale
Edizione Internazionale

1.

Bill?Jelen
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Softcover Prima edizione Quantità: > 20
Edizione Internazionale
Da
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Softcover. Condizione libro: New. 1st edition. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS with tracking number. Choose expedited shipping for superfast delivery 2-4 business days by DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Codice libro della libreria LPBD31495106

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 17,75
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,37
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

2.

JELEN
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Brossura Quantità: 5
Edizione Internazionale
Da
bookscollection
(Delhi, DELHI, India)
Valutazione libreria
[?]

Descrizione libro Condizione libro: Brand New. PAPERBACK, Brand New, Softcover, International Edition. We Do not Ship APO FPO AND PO BOX. NO CD AND ACCESS CARD. Cover Image & ISBN may be different from US edition but contents as US Edition. Printing in English language. Quick delivery by USPS/UPS/DHL/FEDEX/ARAMEX ,Customer satisfaction guaranteed. We may ship the books from Asian regions for inventory purpose. Codice libro della libreria ABEJUL W/P 845

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 17,57
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,59
Da: India a: U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

3.

Bill Jelen , Tracy Syrstad
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 5
Edizione Internazionale
Da
PRIORITY BOOKS
(springfield, VA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 648 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Codice libro della libreria 375404

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 17,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,41
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

4.

Bill Jelen , Tracy Syrstad
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 1
Edizione Internazionale
Da
Nick Book House
(fresno, CA, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. New, Softcover International Edition, Printed in Black and White, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Codice libro della libreria 24621

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 17,78
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,41
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

5.

Bill Jelen; Tracy Syrstad
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 5
Edizione Internazionale
Da
Bookstore99
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Paperback. Condizione libro: New. This is an International Edition. Brand New Paperback- Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Delivery within 3-7 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Choose expedited shipping for Express delivery. Tracking number provided for every order. Codice libro della libreria RU_9780789748614

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 22,23
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,55
In U.S.A.
Destinazione, tempi e costi
Edizione Internazionale
Edizione Internazionale

6.

International Edition
Editore: International Edition
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 1
Edizione Internazionale
Da
Campustexxts
(Vicksburg, MI, U.S.A.)
Valutazione libreria
[?]

Descrizione libro International Edition. Paperback. Condizione libro: New. International Edition. Very fast shipping. Receive your book in 2-7 business days if you checkout with expedited shipping. We take pride in our customer service, please contact us if you have any questions regarding the listing. Codice libro della libreria in-us-9780789748614

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 22,00
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,99
In U.S.A.
Destinazione, tempi e costi

7.

BillJelen; Syrstad Tracy
Editore: Alpha Books (2013)
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Brossura Quantità: 2
Da
Valutazione libreria
[?]

Descrizione libro Alpha Books, 2013. Condizione libro: New. Codice libro della libreria GH9780789748614

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 31,13
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,99
Da: Germania a: U.S.A.
Destinazione, tempi e costi

8.

Jelen, Bill; Syrstad, Tracy
Editore: Que Publishing (2013)
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Que Publishing, 2013. Paperback. Condizione libro: New. Codice libro della libreria DADAX0789748614

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 35,85
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,41
In U.S.A.
Destinazione, tempi e costi

9.

Bill Jelen
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi Paperback Quantità: 1
Da
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Valutazione libreria
[?]

Descrizione libro 2013. Paperback. Condizione libro: New. 1. Paperback. SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel(R) 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then, le.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 648 pages. 1.030. Codice libro della libreria 9780789748614

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 43,76
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

10.

Jelen, Bill
Editore: QUE
ISBN 10: 0789748614 ISBN 13: 9780789748614
Nuovi soft Quantità: 1
Da
Agapea Libros Urgentes
(Malaga, Spagna)
Valutazione libreria
[?]

Descrizione libro QUE. soft. Condizione libro: New. SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel(r) 2013 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! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues can understand and act on it. . . how to capture data from anywhere, and use it anywhere. . . how to automate Excel 2013's most valuable new features. Mastering advanced Excel macros 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. * Get started fast with Excel 2013 macro development * Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models * Work efficiently with ranges, cells, and R1C1-style formulas * Build super-fast applications with arrays * Write Excel 2013 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 macros more resilient * Use web queries and new web service functions to integrate data from anywhere * Master advanced techniques such as classes, collections, and custom functions * Build sophisticated data mining and business analysis applications * Read and write to both Access and SQL Server databases * Control other Office programs-and even control Windows itself * Start writing Excel Apps similar to those in the Excel App Store 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 *** Nota: EL COSTE DE ENVÍO A CANARIAS ES 8 euros. Si ha realizado un pedido con destino a CANARIAS no podemos hacer el envío con un coste de 3,5 euros . Nos pondremos en contacto con usted para comunicar el coste total del envío a Canarias y si está de acuerdo, Abebooks le efectuará el cargo adicional. Codice libro della libreria 7808991

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 36,35
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 10,00
Da: Spagna a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro