Excel 2013 VBA and Macros (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
648
Utgivningsdatum
2013-02-21
Upplaga
1
Förlag
QUE
Medarbetare
Syrstad, Tracy
Illustratör/Fotograf
illustrations
Illustrationer
Illustrationsstrations
Dimensioner
158 x 196 x 31 mm
Vikt
979 g
Antal komponenter
1
ISBN
9780789748614
Excel 2013 VBA and Macros (häftad)

Excel 2013 VBA and Macros

Excel 2013 VBA and Macros _p1

(2 röster)
Häftad Engelska, 2013-02-21
379
Skickas inom 3-6 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 1 format & utgåvor
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! Youll discover macro techniques you wont 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 ithow to capture data from anywhere, and use it anywherehow to automate Excel 2013s most valuable new features. Mastering advanced Excel macros has never been easier. Youll find simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus examples, macros, and solutionsstraight 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 programsand 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 productivitysaving 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 
Visa hela texten

Passar bra ihop

  1. Excel 2013 VBA and Macros
  2. +
  3. VBA and Macros for Microsoft Excel

De som köpt den här boken har ofta också köpt VBA and Macros for Microsoft Excel av Bill Jelen, Tracy Syrstad (häftad).

Köp båda 2 för 808 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Bloggat om Excel 2013 VBA and Macros

Övrig information

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.

Innehållsförteckning

Introduction ........................................................ 1

Getting Results with VBA ...................................................................1

What Is in This Book? .................................................................1

  Reduce the Learning Curve .............................................1

  Excel VBA Power .................................................................2

  Techie Stuff Needed to Produce Applications ................................2

  Does This Book Teach Excel? ............................................................2

The Future of VBA and Windows Versions of Excel ..............................4

  Versions of Excel ......................................................................................4

Special Elements and Typographical Conventions .........................................4

Code Files .........................................................................................................5

Next Steps..........................................................................5

1 Unleash the Power of Excel with VBA ......................................... 7

The Power of Excel .....................................................................7

Barriers to Entry .......................................................................7

  The Macro Recorder Doesnt Work! ...................................................7

  Visual Basic Is Not Like BASIC ..............................................................8

  Good News: Climbing the Learning Curve Is Easy ....................................8

  Great News: Excel with VBA Is Worth the Effort ..................................8

Knowing Your Tools: The Developer Tab .............................................................9

Understanding Which File Types Allow Macros .........................................10

Macro Security ...........................................................................................11

  Adding a Trusted Location ........................................................................12

  Using Macro Settings to Enable Macros in Workbooks Outside of Trusted Locations ........................13

  Using Disable All Macros with Notification ...............................................13

Overview of Recording, Storing, and Running a Macro ......................................14

  Filling Out the Record Macro Dialog ..................................................................14

Running a Macro..............................................................................................16

  Creating a Macro Button on the Ribbon .........................................................16

  Creating a ...