|
|
| Book details / order |
| EXCEL VBA 24-HOUR TRAINER, 2ED |
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.
contents : -
introduction
part i: understanding the basics
lesson 1: introducing vba
• what is vba?
• a brief history of vba
• what vba can do for you
• liabilities of vba
• try it
lesson 2: getting started with macros
• composing your first macro
• running a macro
• try it
lesson 3: introducing the visual basic editor
• what is the vbe?
• try it
lesson 4: 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 ii: diving deeper into vba
lesson 5: object-oriented programming: an overview
• what "object-oriented programming" means
• the object model
• try it
lesson 6: 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
lesson 7: understanding objects and collections
• workbooks
• cells and ranges
• try it
lesson 8: working with ranges
• working with noncontiguously populated ranges
• try it
lesson 9: making decisions with vba
• understanding logical operators
• choosing between this or that
• getting users to make decisions
• try it
part iii: beyond the macro recorder: writing your own code
lesson 10: repeating actions with loops
• what is a loop?
• nesting loops
• try it
lesson 11: programming formulas
• understanding a1 and r1c1 references
• programming your formula solutions with vba
• try it
lesson 12: 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
lesson 13: automating procedures with worksheet events
• what is an event?
• worksheet events: an overview
• examples of common worksheet events
• try it
lesson 14: automating procedures with workbook events
• workbook events: an overview
• examples of common workbook events
• try it
lesson 15: handling duplicate items and records
• deleting rows containing duplicate entries
• working with duplicate data
• try it
lesson 16: using embedded controls
• working with form controls and
• activex controls
• try it
lesson 17: programming charts
• try it
lesson 18: programming pivottables and pivotcharts
• creating a pivottable report
• understanding pivot caches
• manipulating pivot fields in vba
• manipulating pivot items with vba
• creating a pivottables collection
• try it
lesson 19: user-defined functions
• what is a user-defined function?
• udf examples that solve common tasks
• volatile functions
• try it
lesson 20: debugging your code
• what is debugging?
• what causes errors?
• weapons of mass debugging
• trapping errors
• try it
part iv: advanced programming techniques
lesson 21: creating user forms
• what is a user form?
• creating a user form
• designing a user form
• adding controls to a user form
• showing a user form
• where does the user form’s code go?
• closing a user form
• try it
lesson 22: user form controls and their functions
• understanding the frequently used user form controls
• try it
lesson 23: advanced user forms
• the user form toolbar
• modal versus modeless
• disabling the user form’s close button
• maximizing your user form’s size
• selecting and displaying photographs on a user form
• unloading a user form automatically
• pre-sorting the list box and combo box items
• populating list boxes and combo boxes with unique items
• displaying a real-time chart in a user form
• try it
lesson 24: class modules
• what is a class?
• what is a class module?
• creating your own objects
• an important benefit of class modules
• creating collections
• class modules for embedded objects
• try it
lesson 25: 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
lesson 26: managing external data
• creating query tables from web queries
• creating a query table for access
• using text files to store external data
• try it
lesson 27: data access with activex data objects
• introducing ado
• an introduction to structured query language (sql)
• try it
lesson 28: impressing your boss (or at least your friends)
• selecting cells and ranges
• filtering dates
• setting page breaks for specified areas
• using a comment to log changes in a cell
• using the windows api with vba
• scheduling your workbook for suicide
• try it
part v: interacting with other office applications
lesson 29: overview of office automation from excel
• why automate another application?
• understanding office automation
• try it
lesson 30: working with word 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
lesson 31: 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
lesson 32: 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
lesson 33: 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.
Author : Tom urtis
Publication : Wrox
Isbn : 9788126555475
Store book number : 107
NRS 1120.00
|
 |
|
|
|
|
|
|
|
| |
|
|
