Updated for Excel 2021, this book is a practical guide for those proficient with the Excel user interface and looking to automate routine tasks. It introduces programming concepts through numerous hands-on exercises, progressing to advanced topics via custom projects. The journey begins with recording and editing macros, writing VBA code, and extends to programming the Ribbon interface and working with XML documents.
The course covers automating operations on files, folders, and other Microsoft Office applications. It also delves into event procedures, testing, and debugging. Advanced features include working with VBA classes and raising custom events in standalone class modules. By mastering these skills, users can significantly enhance their productivity and efficiency in Excel.
The book's structure, with 29 chapters and over 275 examples, ensures comprehensive learning. Companion files with source code, projects, and figures further support the user. This course is essential for anyone aiming to streamline their Excel tasks and harness the full power of Excel programming.

Osoby które kupowały "Excel 2021 / Microsoft 365 Programming By Example. A Comprehensive Guide to Mastering Excel VBA", wybierały także:

• Windows Media Center. Domowe centrum rozrywki 66,67 zÅ‚, (8,00 zÅ‚ -88%)
• Ruby on Rails. Ćwiczenia 18,75 zÅ‚, (3,00 zÅ‚ -84%)
• Przywództwo w Å›wiecie VUCA. Jak być skutecznym liderem w niepewnym Å›rodowisku 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Scrum. O zwinnym zarzÄ…dzaniu projektami. Wydanie II rozszerzone 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Od hierarchii do turkusu, czyli jak zarzÄ…dzać w XXI wieku 58,64 zÅ‚, (12,90 zÅ‚ -78%)

Spis treści

Excel 2021 / Microsoft 365 Programming By Example. A Comprehensive Guide to Mastering Excel VBA eBook -- spis treści

• 1. Excel Macros: A Quick Start in Excel VBA Programming
• 2. Excel Programming Environment: A Quick Overview of its Tools and Features (VBE)
• 3. Excel VBA Fundamentals: A Quick Reference to Writing VBA Code
• 4. Excel VBA Procedures: A Quick Guide to Writing Function Procedures
• 5. Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements
• 6. Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements
• 7. Storing Multiple Values in Excel VBA Programs: A Quick Introduction to Working with Arrays
• 8. Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections
• 9. Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs
• 10. File and Folder Manipulation with VBA
• 11. File and Folder Manipulation with Windows Script Host (WSH)
• 12. Using Low-Level File Access
• 13. Using Excel VBA to Interact with Other Applications
• 14. Using Excel with Microsoft Access
• 15. Event-Driven Programming
• 16. Using Dialog Boxes
• 17. Creating Custom Forms
• 18. Formatting Worksheets with VBA
• 19. Context Menu Programming and Ribbon Customizations
• 20. Printing and Sending Email from Excel
• 21. Using and Programming Excel Tables
• 22. Programming PivotTables and PivotCharts
• 23. Getting and Transforming Data in Excel
• 24. Programming the Visual Basic Editor (VBE)
• 25. Calling Windows API Functions from VBA
• 26. Creating Classes in VBA
• 27. HTML Programming and Web Queries
• 28. Using XML in Excel 2021
• 29. Excel and Rest API