Excel 2021 / Microsoft 365 Programming By Example
1st Edition
Published on 21. December 2022
1072 pages
978-1-68392-884-3 (ISBN)
Description
No detailed description available for "Excel 2021 / Microsoft 365 Programming By Example".
More details
Other editions
Additional editions
Julitta Korol
Excel 2021 / Microsoft 365 Programming By Example
Book
12/2022
1st Edition
Mercury Learning & Information
€64.95
Article not available at the moment
Julitta Korol
Excel 2021 / Microsoft 365 Programming By Example
E-Book
12/2022
1st Edition
Mercury Learning & Information
€73.49
Available for download
Person
Korol Julitta:
Since 1993, Julitta Korol has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).
Since 1993, Julitta Korol has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).
Content
PART I: EXCEL VBA PRIMER
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
PART II: MANIPULATING FILES AND FOLDERS WITH VBA
10: File and Folder Manipulation with VBA
11: File and Folder Manipulation with Windows Script Host (WSH)
12: Using Low-Level File Access
PART III: CONTROLLING OTHER APPLICATIONS WITH VBA
13 Using Excel VBA to Interact with Other Applications
14: Using Excel with Microsoft Access
PART IV: ENHANCING THE USER EXPERIENCE
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
PART V: EXCEL TOOLS FOR DATA ANALYSIS
21: Using and Programming Excel Tables
22: Programming PivotTables and PivotCharts
23: Getting and Transforming Data in Excel
PART VI: TAKING CHARGE OF PROGRAMMING ENVIRONMENT
24: Programming the Visual Basic Editor (VBE)
25: Calling Windows API Functions from VBA
PART VII: ADVANCED CONCEPTS IN EXCEL VBA
26: Creating Classes in VBA
PART VIII: WORKING TOGETHER: VBA, HTML, XML, AND THE REST API
27: HTML Programming and Web Queries
28: Using XML in Excel 2021
29: Excel and Rest API
Index
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
PART II: MANIPULATING FILES AND FOLDERS WITH VBA
10: File and Folder Manipulation with VBA
11: File and Folder Manipulation with Windows Script Host (WSH)
12: Using Low-Level File Access
PART III: CONTROLLING OTHER APPLICATIONS WITH VBA
13 Using Excel VBA to Interact with Other Applications
14: Using Excel with Microsoft Access
PART IV: ENHANCING THE USER EXPERIENCE
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
PART V: EXCEL TOOLS FOR DATA ANALYSIS
21: Using and Programming Excel Tables
22: Programming PivotTables and PivotCharts
23: Getting and Transforming Data in Excel
PART VI: TAKING CHARGE OF PROGRAMMING ENVIRONMENT
24: Programming the Visual Basic Editor (VBE)
25: Calling Windows API Functions from VBA
PART VII: ADVANCED CONCEPTS IN EXCEL VBA
26: Creating Classes in VBA
PART VIII: WORKING TOGETHER: VBA, HTML, XML, AND THE REST API
27: HTML Programming and Web Queries
28: Using XML in Excel 2021
29: Excel and Rest API
Index
