Microsoft Excel VBA Professional Projects

  • 9h 27m
  • Duane Birnbaum
  • Cengage Course PTR
  • 2003

Microsoft Excel VBA Professional Projects illustrates and teaches intermediate to advanced techniques in VBA programming using Microsoft's Excel spreadsheet application. It provides an introduction to VBA and Excel VBA before proceeding through four to five programming projects using Excel to illustrate basic and advanced programming techniques. It does not assume any prior knowledge of Excel VBA programming.

About the Author

Duane Birnbaum received a Ph.D from the University of California, Riverside in 1991 in physical chemistry. He works at Biogel Technology as a research scientist and has authored numerous scientific articles in the areas of chemical physics, biochemistry, and chemical engineering. He began teaching part-time in the computer science department of Indiana University - Purdue University at Indianapolis in 1997, focusing on an introductory course in data analysis with an emphasis on using the tools in spreadsheet applications. Duane lives in Indianapolis, Indiana.

In this Book

  • VBA Overview and the IDE
  • Working with Variables and Constants in VBA
  • Using VBA's Built-In Functions
  • Understanding VBA Procedures
  • Program Branching with VBA Decision Structures
  • Creating VBA Loops and Arrays
  • VBA Objects Specific to Excel Programming
  • Understanding File I/O, Debugging, and Error Handling in VBA
  • Custom Menus and Toolbars
  • Creating and Manipulating Excel Charts
  • VBA Class Modules: Creating Custom Objects
  • Constructing the Excel-to-HTML Converter
  • Data I/O between Excel and Access
  • Using and Creating Excel Pivot Tables for Fast Data Analyses
  • Business Analyses for Pear Tree Used Cars, Inc.
  • Web Queries and Web-Related Objects in VBA
  • Accessing the Windows API with VBA
  • Constructing the Stock Ticker
  • Reducing the Workload by Automating Data Analyses
  • Advanced Data Analysis Using Curve-Fitting and Interactive Charts with Excel-VBA
  • Data Analysis Automation and Curve-Fitting with Excel-VBA
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Book Microsoft Excel 2021 Programming Pocket Primer
Course Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Excel Macros for Dummies, 2nd Edition
Course Defining Cloud Computing for Decision-makers: Cloud Computing Principles
Rating 4.3 of 328 users Rating 4.3 of 328 users (328)
Course VBA: Getting Started with VBA in Excel
Rating 4.6 of 292 users Rating 4.6 of 292 users (292)