The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | Yesterday, 10:42am

Merritt Tierce: IMG Has My Husband Read It?



My first novel, Love Me Back, was published on September 16. Writing the book took seven years, and along the way three chapters were published in... Continue »
  1. $16.77 Sale Hardcover add to wish list

    Love Me Back

    Merritt Tierce 9780385538077

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Microsoft Windows- Windows 95 General
3 Local Warehouse Personal Computers- Desktop Applications- Spreadsheets
18 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2013 VBA and Macros (MrExcel Library)

by

Excel 2013 VBA and Macros (MrExcel Library) Cover

 

Synopses & Reviews

Publisher Comments:

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

 

Synopsis:

Using Microsoft Excel 2013 VBA scripting features, you can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. Excel 2013 VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques you need to automate virtually any Excel task and customize virtually any Excel report or business solution.

 

Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and efficient, modern object programming. You'll learn how to automate Excel 2013's most powerful new features for data analysis, formatting, visualization, sharing, and presentation. Jelen and Syrstad cover all this, and more:

  • Creating charts, PivotTables, and other data visualizations
  • Mining data with Excel's Advanced Filter
  • Reading from and writing to the Web
  • Using XML from within Excel
  • Using Microsoft Access as a back end to enhance multi-user access to data
  • Handling errors
  • Customizing the Excel 2013 Ribbon to run macros
  • Writing Excel 2013 code that works with older versions of Excel

  This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of leading Excel help site, MrExcel.com.

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 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.

Table of Contents

I. Introduction

1. Unleash the Power of Excel with VBA

2. This Sounds Like BASIC, So Why Doesn't It Look Familiar?

3. Referring to Ranges

4. User-Defined Functions

5. Looping and Flow Control

6. R1C1-Style Formulas

7. What's New in Excel 2013 and What's Changed

8. Create and Manipulate Names in VBA

9. Event Programming

10. Userforms--An Introduction

11. Creating Charts

12. Data Mining with Advanced Filter

13. Using VBA to Create Pivot Tables

14. Excel Power

15. Data Visualizations and Conditional Formatting

16. Reading from and Writing to the Web

17. XML in Excel 2013

18. Automating Word

19. Arrays

20. Text File Processing

21. Using Access as a Back End to Enhance Multi-User Access to Data

22. Creating Classes, Records, and Collections

23. Advanced Userform Techniques

24. Windows Application Programming Interface (API)

25. Handling Errors

26. Customizing the Ribbon to Run Macros

27. Creating Add-Ins

Product Details

ISBN:
9780789748614
Author:
Jelen, Bill
Publisher:
Que
Author:
Syrstad, Tracy
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
Trade paper
Series:
MrExcel Library
Publication Date:
20130318
Binding:
TRADE PAPER
Language:
English
Pages:
648
Dimensions:
9 x 7 x 1.303 in 993 gr

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2013 VBA and Macros (MrExcel Library) New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 648 pages Que Pub. - English 9780789748614 Reviews:
"Synopsis" by ,

Using Microsoft Excel 2013 VBA scripting features, you can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. Excel 2013 VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques you need to automate virtually any Excel task and customize virtually any Excel report or business solution.

 

Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and efficient, modern object programming. You'll learn how to automate Excel 2013's most powerful new features for data analysis, formatting, visualization, sharing, and presentation. Jelen and Syrstad cover all this, and more:

  • Creating charts, PivotTables, and other data visualizations
  • Mining data with Excel's Advanced Filter
  • Reading from and writing to the Web
  • Using XML from within Excel
  • Using Microsoft Access as a back end to enhance multi-user access to data
  • Handling errors
  • Customizing the Excel 2013 Ribbon to run macros
  • Writing Excel 2013 code that works with older versions of Excel

  This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of leading Excel help site, MrExcel.com.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.