Excel VBA 24-Hour Trainer by TOM URTIS

1 BOOKS FOUND ON YOUR SEARCH.

Excel VBA 24-Hour Trainer

by TOM URTIS

Qty :

Price : $ ~~9.98~~
Your Price : $ 8.98
You Save : $ 1.00 (10%)
Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel's newest chart and pivot table object models Manipulate the user interface to customize the look and feel of a project Utilize message boxes, input boxes, and loops to yield customized logical results Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need. Introduction Part � 1: Understanding the Basics Introducing VBA What Is VBA? A Brief History of VBA What VBA Can Do for You Liabilities of VBA Try It Getting Started with Macros Composing Your First Macro Running a Macro Try It Introducing the Visual Basic Editor What Is the VBE? Try It Working in the VBE Toolbars in the VBE Macros and Modules Understanding the Code Editing a Macro with Comments and Improvements to the Code Try It Part � 2: Diving Deeper into VBA Object Oriented Programming: An Overview What "Object-Oriented Programming" Means The Object Model Try It Variables, Data Types and Constants What Is a Variable? Assigning Values to Variables Why You Need Variables Data Types Forcing Variable Declaration Understanding a Variable's Scope Try It Understanding Objects and Collections Workbooks Cells and Try It Working with Ranges Working with Non-contiguously Populated Ranges Try It Making Decision with VBA Understanding Logical Operators Choosing Between This or That Getting Users to Make Decisions Try It Part � 3: Beyond the Macroi Recorder � Writing Your Own Code Repeating Actions with Loops What Is a Loop? Nesting Loops Try It Programming Formulas Understanding A1 and R1C1 References Programming Your Formula Solutions with VBA Try It Working with Arrays What Is an Array? The Option Base Statement Boundaries in Arrays Declaring Arrays with Fixed Elements Declaring Dynamic Arrays with ReDim and Preserve Try It Automating Procedures with Worksheet Events What Is an Event? Worksheet Events: An Overview Examples of Common Worksheet Events Try It Automating Procedures with Workbook Events Workbook Events: An Overview Examples of Common Workbook Events Try It Handling Duplicate Items and Records Deleting Rows Containing Duplicate Entries Working with Duplicate Data Try It Using Embedded Controls Working with Form Controls and ActiveX Controls Try It Programming Charts Try It Programming Pivot Tables and Pivot Charts Creating a PivotTable Report Understanding Pivot Caches Manipulating Pivot Fields in VBA Manipulating Pivot Items with VBA Creating a PivotTables Collection Try It User-Defined Functions What Is a User-Defi ned Function? UDF Examples That Solve Common Tasks Volatile Functions Try It Debugging Your Code What Is Debugging? What Causes Errors? Weapons of Mass Debugging Trapping Errors Try It Part � 4: Advanced Programming Techniques Creating Userforms What Is a UserForm? Creating a UserForm Designing a UserForm Adding Controls to a UserForm Showing a UserForm Where Does the UserForm's Code Go? Closing a UserForm Try It Userform Controls and Their Functions Understanding the Frequently Used UserForm Controls Try It Advanced Userforms The UserForm Toolbar Modal versus Modeless Disabling the UserForm's Close Button Maximizing Your UserForm's Size Selecting and Displaying Photographs on a UserForm Unloading a UserForm Automatically Pre-sorting the ListBox and ComboBox Items Populating ListBoxes and ComboBoxes with Unique Items Displaying a Real-Time Chart in a UserForm Try It Class Modules What Is a Class? What Is a Class Module? Creating Your Own Objects An Important Benefi t of Class Modules Creating Collections Class Modules for Embedded Objects Try It Add-Ins What Is an Excel Add-In? Creating an Add-In Converting a File to an Add-In Installing an Add-In Creating a User Interface for Your Add-In Closing Add-Ins Removing an Add-In from the Add-Ins List Try It Managing External Data Creating QueryTables from Web Queries Creating a QueryTable for Access Using Text Files to Store External Data Try It Data Access with Activex Data Objects Introducing ADO An Introduction to Structured Query Language (SQL) Try It Impressing Your Boss (Or Atleast Your Friends) Selecting Cells and Ranges Filtering Dates Setting Page Breaks for Specifi ed Areas Using a Comment to Log Changes in a Cell Using the Windows API with VBA Scheduling Your Workbook for Suicide Try It Part � 5: Interacting with Other Office Applications Overview of Office Automation from Excel Why Automate Another Application? Understanding Offi ce Automation Try It Working with Work from Excel Activating a Word Document Creating a New Word Document Copying an Excel Range to a Word Document Printing a Word Document from Excel Importing a Word Document to Excel Try It Working with Outlook from Excel Opening Outlook Composing an E-mail in Outlook from Excel Putting It All Together E-mailing a Single Worksheet Try It Working with Access from Excel Adding a Record to an Access Table Exporting an Access Table to an Excel Spreadsheet Creating a New Table in Access Try It Working with Powerpoint from Excel Creating a New PowerPoint Presentation Copying a Worksheet Range to a PowerPoint Slide Copying Chart Sheets to PowerPoint Slides Running a PowerPoint Presentation from Excel Try It Index ISBN - 9788126555475

Pages : 496

Untitled Document

Some More Books of Similar Interest

Standard Methods for the Examination of Water and Wastewater, 24th Edition by William C. Lipps, Ellen Burton Braun-Howland, Terry E. Baxter	Electronics (Hindi) by Vijay S. K.	Crystallography Applied to Solid State Physics by Verma, A.R.
Quantum Mechanics by Thankappan, V.K.	Laser Systems and Applications (All India) by Srivastava, S.K.	Laser Systems and Applications (AKTU) by Srivastava, S.K.

If you didn't find any required book(s),
Please mail us the details we will find it for you through our resources.
Kindly click here to send your requirement now.

OR

You may try advance search through below given search window.

Untitled Document

   Tips to get best Search results:
   1. Carefully check the spellings of words typed in the search box.
   2. Type one word in Search box to get better results.
   eg. for searching a book "Sikhism in India" just type sikhism in search box.
   3. Do not use Phrases to search a book like "Books on art of Himachal Pradesh".
   Just search for "art of Himachal Pradesh".
   4. To search a book on author, choose author in drop down menu given above
    search window before pressing Submit button.