This book is the first of three books to come in a series that is dedicated to making VBA in Microsoft Excel less scary for regular, everyday people.  I’m committed to providing tutorials in a way that will allow my books to be as easily understood as watching a cartoon on your television screen; this is why pictorial examples dominates this book; the images will follow me step by step in the process of writing VBA codes from beginning to end; there are full and complete codes in this...

This book is the third and final book in the Microsoft VBA Codes Are Fun, Simple, and Easy to Learn In One Hour or Less series. I’m dedicated to making VBA as simple as possible for anyone who wants to harness its power and efficiency. Since I’ve already explained Microsoft VBA statements, built-in objects, arrays, variables, integers, Sub, Private Sub and Public Sub tags in my previous books, I won’t be explaining them in this one. I also use everyday language with pictorial examples to e...

This book is the third and final book in the Microsoft VBA Codes Are Fun, Simple, and Easy to Learn In One Hour or Less series. Since I’ve already explained Microsoft VBA statements, built-in objects, arrays, variables, integers, Sub, Private Sub and Public Sub tags in my previous books, I won’t be explaining them in this one. I also use everyday language with pictorial examples to explain how to understand and write Microsoft loop statements in both Word and Excel. This book contains more...

You can quickly learn what a comment, an array, a variable, a text string, a VBA loop Statement, a With Statement, a Set Statement, a Dim Statement and the basic functions of Microsoft Word 2010 VBA from the pages of this small book, but you must first have the desire to learn VBA; without the desire, you’ll only end up being disappointed in this book or any other book.  When a person lacks an interest or a desire in a particular topic or matter, he or she just finds excuses to convin...

You can quickly learn what a comment, an array, a variable, a text string, a VBA loop Statement, a With Statement, a Set Statement, a Dim Statement and the basic functions of Microsoft Word 2010 VBA from the pages of this small book, but you must first have the desire to learn VBA; without the desire, you’ll only end up being disappointed in this book or any other book.

This book will allow users to quickly master Microsoft Excel Form Controls: combo box, check box, spin button, list box, and option button. The option button is also known as the radio button. Form controls are designed to work with Microsoft formulas and/or VBA; however, this book is strictly about form controls working with Microsoft formulas; there will be no VBA codes or macros discussed in this book. In order to simplify the user’s learning experience, pictorial examples dominate this...

This book is for every employee that’s required to consolidate hundreds of documents into a large, single document. Users will be able to extract data from hundreds of emails for documenting correspondence in seconds; users will be able to consolidate month-end reports and other business documents in seconds, and users will be able to manually resize, format and apply effects to hundreds of large images simultaneously in under a few seconds. Tasks that currently require days or weeks to co...

This five-minute eBook will quickly show anyone how to use Microsoft’s VBA operators (e.g., , Like, And) and its wildcard characters (e.g., #, ? and *) to filter for data in spreadsheet cells. If a user has ever worked with filtering data in Microsoft Access databases, he or she will be very familiar with these operators and wildcard characters and how they’re used to extract data, but the user must use these operators and wildcard characters in VBA codes differently than he or she wou...

This book will allow users to quickly master Microsoft Excel Form Controls: combo box, check box, spin button, list box, and option button.  The option button is also known as the radio button.  Form controls are designed to work with Microsoft formulas and/or VBA; however, this book is strictly about form controls working with Microsoft formulas; there will be no VBA codes or macros discussed in this book.  In order to simplify the user’s learning experience, pictorial exam...

This book will allow users to quickly master Microsoft Excel data formulas: left, right, mid, trim, len, find, index, if, and, or, iserror, hlookup, vlookup, concatenate, offset, match, small, and large. In order to create powerful mega-formulas, which are used to extract and manipulate data without using VBA or macros, users will learn how to nestle formulas. This book makes it much easier for users to learn how to use Microsoft formulas for tasks that may seem complex; in some cases, the...

This book will allow users to quickly master Microsoft Excel data formulas: left, right, mid, trim, len, find, index, if, and, or, iserror, hlookup, vlookup, concatenate, offset, match, small, and large. In order to create powerful mega-formulas, which are used to extract and manipulate data without using VBA or macros, users will learn how to nestle formulas. This book makes it much easier for users to learn how to use Microsoft formulas for tasks that may seem complex; in some cases, the...

This book will allow users to quickly master Microsoft Excel data formulas: left, right, mid, trim, len, find, index, if, and, or, iserror, hlookup, vlookup, concatenate, offset, match, small, and large.  In order to create powerful mega-formulas, which are used to extract and manipulate data without using VBA or macros, users will learn how to nestle formulas.  This book makes it much easier for users to learn how to use Microsoft formulas for tasks that may seem complex; in som...