Artículos relacionados a Excel 2013 VBA and Macros (MrExcel Library)
Sinopsis
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
"Sinopsis" puede pertenecer a otra edición de este libro.
Acerca del autor
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 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 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.
"Sobre este título" puede pertenecer a otra edición de este libro.
- EditorialAlpha Books
- Año de publicación2013
- ISBN 10 0789748614
- ISBN 13 9780789748614
- EncuadernaciónTapa blanda
- IdiomaInglés
- Número de páginas640
- Contacto del fabricanteno disponible
Resultados de la búsqueda para Excel 2013 VBA and Macros (MrExcel Library)
Imagen de archivo
Excel 2013 VBA and Macros (MrExcel Library)
Librería: WorldofBooks, Goring-By-Sea, WS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Fair. A readable copy of the book which may include some defects such as highlighting and notes. Cover and pages may be creased and show discolouration. Nº de ref. del artículo: GOR013799817
Cantidad disponible: 2 disponibles
Imagen de archivo
Excel 2013 VBA and Macros (MrExcel Library)
Librería: WorldofBooks, Goring-By-Sea, WS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Good. The book has been read but remains in clean condition. All pages are intact and the cover is intact. Some minor wear to the spine. Nº de ref. del artículo: GOR006003458
Cantidad disponible: 1 disponibles
Imagen de archivo
Excel 2013 VBA and Macros
Librería: medimops, Berlin, Alemania
Calificación del vendedor: 5 de 5 estrellas
Condición: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Nº de ref. del artículo: M00789748614-V
Cantidad disponible: 1 disponibles
Imagen de archivo
Excel 2013 VBA and Macros (MrExcel Library)
Librería: Goldstone Books, Llandybie, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Good. All orders are dispatched within one working day from our UK warehouse. We've been selling books online since 2004! We have over 750,000 books in stock. No quibble refund if not completely satisfied. Nº de ref. del artículo: mon0007367515
Cantidad disponible: 1 disponibles
Imagen de archivo
Excel 2013 VBA and Macros
Librería: Ammareal, Morangis, Francia
Calificación del vendedor: 5 de 5 estrellas
Softcover. Condición: Bon. Ancien livre de bibliothèque. Traces de pliures sur la couverture. Traces d'usure sur la couverture. Edition 2013. Ammareal reverse jusqu'à 15% du prix net de cet article à des organisations caritatives. ENGLISH DESCRIPTION Book Condition: Used, Good. Former library book. Traces of creases on the cover. Signs of wear on the cover. Edition 2013. Ammareal gives back up to 15% of this item's net price to charity organizations. Nº de ref. del artículo: E-580-585
Cantidad disponible: 1 disponibles
Imagen de archivo
Excel 2013 VBA and Macros (MrExcel Library)
Librería: Stephen White Books, Bradford, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Good. Ex-library book, usual marking. Clean copy in good condition. Quick dispatch from UK seller. Nº de ref. del artículo: mon0000383235
Cantidad disponible: 1 disponibles
Imagen de archivo
Excel 2013 VBA and Macros
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.24. Nº de ref. del artículo: G0789748614I4N00
Cantidad disponible: 1 disponibles
Imagen de archivo
VBA and Macros
Publicado por
Pearson Education, Limited, 2013
ISBN 10: 0789748614
ISBN 13: 9780789748614
Antiguo o usado
Tapa blanda
Librería: Better World Books, Mishawaka, IN, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: Very Good. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Nº de ref. del artículo: 14706777-6
Cantidad disponible: 1 disponibles
Imagen de archivo
VBA and Macros
Publicado por
Pearson Education, Limited, 2013
ISBN 10: 0789748614
ISBN 13: 9780789748614
Antiguo o usado
Tapa blanda
Librería: Better World Books, Mishawaka, IN, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects. Nº de ref. del artículo: 901540-6
Cantidad disponible: 2 disponibles
Imagen de archivo
Excel 2013 VBA and Macros (MrE
Publicado por
Que Publishing, 2013
ISBN 10: 0789748614
ISBN 13: 9780789748614
Antiguo o usado
Tapa blanda
Librería: SecondSale, Montgomery, IL, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Nº de ref. del artículo: 00085231350
Cantidad disponible: 1 disponibles