

Gail Perry is a CPA, financial journalist, the author more than 20 books on financial software, taxes, and personal finance.
Meer over Gail PerryExcel 2007 Macros Made Easy
Samenvatting
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. You'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 oost 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
Specificaties
Inhoudsopgave
1. Recording Macros
2. Editing Macros
3. Creating Macros in Visual Basic
4. Storing Macros
5. Understanding Macro Commands
6. Using Visual Basic Subroutines and Creating Functions
7. Creating Interactive Macros
8. Using Macros to Format Cells
9. Using Variables in Macros
10. Creating If/Then/Else Routines
11. Exploring Loops
12. Adding Controls to Your Worksheets
Index
Anderen die dit boek kochten, kochten ook
Net verschenen
Rubrieken
- aanbestedingsrecht
- aansprakelijkheids- en verzekeringsrecht
- accountancy
- algemeen juridisch
- arbeidsrecht
- bank- en effectenrecht
- bestuursrecht
- bouwrecht
- burgerlijk recht en procesrecht
- europees-internationaal recht
- fiscaal recht
- gezondheidsrecht
- insolventierecht
- intellectuele eigendom en ict-recht
- management
- mens en maatschappij
- milieu- en omgevingsrecht
- notarieel recht
- ondernemingsrecht
- pensioenrecht
- personen- en familierecht
- sociale zekerheidsrecht
- staatsrecht
- strafrecht en criminologie
- vastgoed- en huurrecht
- vreemdelingenrecht