Excel Programming: Your visual blueprint for creating interactive spreadsheets [NOOK Book]

Overview

A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics!

This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons ...

See more details below
Excel Programming: Your visual blueprint for creating interactive spreadsheets

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$16.49
BN.com price
(Save 45%)$29.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics!

This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly.

  • Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft
  • Covers most tasks in two-page spreads -- no flipping back and forth required!
  • Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format
  • Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners!
  • Helps you maximize your productivity with practical examples, tips, and advice

 Harness everything that Excel has to offer with this friendly, practical, visual guide.

Read More Show Less

Product Details

  • ISBN-13: 9781118036297
  • Publisher: Wiley
  • Publication date: 1/13/2011
  • Series: Visual Blueprint , #44
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 3
  • Pages: 368
  • Sales rank: 519,061
  • File size: 82 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites and authors computer related books. You can visit www.baycongroup.com to view her online tutorials.
Read More Show Less

Table of Contents

HOW TO USE THIS BOOK V

1 USING MACROS AND FORM CONTROLS 2

Introducing Excel Programming 2

Introducing Macros 4

Set Macro Security 6

Create a Digital Signature 7

Record a Macro 8

Assign a Digital Signature to a Macro 10

Run a Macro 12

Create and Launch a Keyboard Shortcut 14

Assign a Macro to the Quick Access Toolbar 16

Delete a Macro 18

Add a Form Control to a Worksheet 20

Assign Values to a Form Control 22

Add a Macro to a Form Control 24

2 USING THE VISUAL BASIC EDITOR 26

Introducing the Visual Basic Editor 26

Activate the Visual Basic Editor 28

Open Visual Basic Editor Windows 30

Set Properties for a Project 32

Set Display Options for the Code Window 34

Add a New Module 36

Remove a Module 38

Hide a Macro 40

Update a Macro 42

3 INTRODUCING VISUAL BASIC FOR APPLICATIONS 44

Create Sub Procedures 44

Create Functions 46

Comment Your Code 48

Reference Cells and Ranges 50

Understanding Variables and Data Types 52

Declare Variables 54

Work with Strings 56

Work with Numbers 58

Create a Constant 60

4 INTRODUCING THE EXCEL OBJECT MODEL 62

Discover the Excel Object Model 62

Access the Excel Object Model Reference 64

Create an Object Variable 66

Change the Properties of an Object 68

Compare Object Variables 70

Using an Object Method 72

Display a Built-in Dialog Box 74

5 UNDERSTANDING ARRAYS 76

Declare an Array 76

Declare a Multidimensional Array 78

Convert a List to an Array 80

Redimension an Array 82

Create a User-Defined Data Type 84

6 CONTROLLING PROGRAM FLOW 86

Create Comparisons 86

Make Use of Logical Operators 87

Employ Do While Loops 88

Create Do Until Loops 90

Create For Next Loops 92

Execute For Each In Loops 94

Create If Then Else Statements 96

Construct Select Case Statements 98

GoTo a Named Location 100

Call a Procedure 102

7 USING EXCEL WORKSHEET FUNCTIONS 104

Work with Excel Worksheet Functions 104

Work with a MsgBox Function 106

Using the InputBox Function 108

Retrieve the Current Date and Time 110

Perform Date and Time Calculations 112

Format a Date Expression 114

Format a Numeric Expression 116

Change the Case of a String 118

Return a Portion of a String 120

8 DEBUGGING MACROS 122

Debug a Procedure with Inserted Breakpoints 122

Using the Watches Window to Debug a Procedure 124

Step through a Procedure 126

Using the Immediate Window 128

Resume Execution When an Error Is Encountered 130

Process a Runtime Error 132

9 WORKING WITH WORKBOOKS AND FILES 134

Open a Workbook 134

Open a Text File as a Workbook 136

Open a File Requested by the User 138

Save a Workbook 140

Save a Workbook in a Format Specified by the User 142

Determine if a Workbook Is Open 144

Close a Workbook 146

Create a New Workbook 148

Delete a File 150

10 WORKING WITH WORKSHEETS 152

Add a Sheet 152

Delete a Sheet 154

Move a Sheet 156

Copy a Sheet 158

Hide a Sheet 160

Change the Name of a Sheet 162

Save a Sheet to Another File 164

Protect a Worksheet 166

Protect a Chart 168

Print a Sheet 170

Sort Sheets by Name 172

11 DEFINING RANGES 174

Using the Range Property 174

Using the Cells Property 176

Combine Multiple Ranges 178

Using the Offset Property 180

Delete a Range of Cells 182

Hide a Range of Cells 184

Create a Range Name 186

Resize a Range 188

Insert a Range 190

Set the Width of Columns in a Range 192

Set the Height of Rows in a Range 194

12 WORKING WITH CELLS 196

Cut and Paste Ranges of Cells 196

Copy and Paste Ranges of Cells 198

Using Paste Special Options When Pasting 200

Add Comments to a Cell 202

Automatically Fill a Range of Cells 204

Copy a Range to Multiple Sheets 206

Add a Border 208

Find Specific Cell Values 210

Find and Replace Values in Cells 212

13 WORKING WITH LISTS 214

Convert a Column of Text into Multiple Columns 214

Perform a Sort 216

Perform a Filter 220

Perform an Advanced Filter 222

Create Subtotals 224

Create Groups 226

Define a List as a Table 228

14 CREATING DIALOG BOXES AND CUSTOMIZING THE RIBBON
230

UserForm Basics 230

Create a Custom Dialog Box 232

Call a Custom Dialog Box from a Procedure 234

Capture Input from a Custom Dialog Box 236

Validate Input from a Dialog Box 240

Create Custom UserForm Controls 242

Create a UserForm Template 244

Customize the Ribbon 246

Create a CustomUI.xml File 250

Add a CustomUI.xml File to a Workbook 252

Add Additional Options to the Ribbon 254

15 WORKING WITH CHARTS 258

Create a Chart Sheet 258

Embed a Chart in a Worksheet 260

Apply Chart Wizard Settings to a Chart 262

Add a New Data Series to a Chart 264

Format Chart Text 266

Create Charts with Multiple Chart Types 268

Add a Data Table to a Chart 270

16 WORKING WITH PIVOTTABLES 272

Create a PivotTable 272

Add Fields to a PivotTable 274

Display Subtotals and Grand Totals 276

Filter a PivotTable 278

Create Groups 279

17 AUTOMATING PROCEDURES WITH EXCEL EVENTS 280

Understanding Excel Events 280

Run a Procedure as a Workbook Opens 284

Run a Procedure before Closing a Workbook 286

Run a Procedure before Saving a Workbook 288

Run a Procedure When Excel Creates a Workbook 290

Execute a Procedure at a Specific Time 294

Execute a Procedure When You Press Keys 296

Monitor a Range of Cells for Changes 298

18 BUILDING ADD-INS 300

Create an Add-In 300

Set Add-In Properties 302
Install Add-Ins 304

Using VBA to Load Add-Ins 306

19 UNDERSTANDING XML 308

Introducing XML 308

Understanding Excel XML Files 310

Open an XML File in Excel as a Table 314

Create an XML Map 316

Import and Export XML Files Using Excel 318

Load XML Files Using VBA 320

Import XML Files Using VBA 322

APPENDIX: VBA QUICK REFERENCE 324

INDEX 342

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)