Overview

No detailed description available for ""Excel 2021 / Microsoft 365 Programming By Example"".

Full Product Details

Author:   Julitta Korol
Publisher:   Mercury Learning & Information
Imprint:   Mercury Learning & Information
Weight:   1.619kg
ISBN:  

9781683928867

ISBN 10:   1683928865
Pages:   1072
Publication Date:   31 December 2022
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

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

Reviews

Author Information

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).

Tab Content 6

Author Website:  

Countries Available

All regions