|
Get beyond the basics with Excel 2007 macros
Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. YouAnd#39;ll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.
-
Record and edit macros
-
Create and debug macros in VBA
-
Save macros to the Personal Macro Workbook or other workbooks
-
Create VBA subroutines and functions
-
Develop interactive macros
-
Format cells using macros
-
Create variables and arrays
-
Apply logic to macros with If/Then/Else routines
-
Use loops to process data
-
Add controls to your worksheets
About the Author
Gail Perry is a CPA, financial journalist, the author more than 20 books on financial software, taxes, and personal finance. She is the managing editor for AccountingWEB, a contributing editor for SMBFinance magazine, and an instructor. |
|
|
Dynamic Secrets in Communication Security
Dynamic secrets are constantly generated and updated from messages exchanged between two communication users. When dynamic secrets are used as a complement to existing secure communication systems, a stolen key or password can be quickly and automatically reverted to its secret status without disrupting communication. "Dynamic Secrets in... | | Mastering Red Hat Enterprise Linux 3Your Complete Guide to the World’s Leading Linux Enterprise Distribution
Red Hat Enterprise Linux 3 is emerging as the corporate Linux standard. One of the first books to focus on this robust product, Mastering Red Hat Enterprise Linux 3 gives you the practical information you need to install, configure, and... | | Data Mining: Concepts, Models, Methods, and Algorithms, Second Edition
Now updated—the systematic introductory guide to modern analysis of large data sets
As data sets continue to grow in size and complexity, there has been an inevitable move towards indirect, automatic, and intelligent data analysis in which the analyst works via more complex and sophisticated software tools. This book... |
|