Excel VBA: Managing Files and Data
Excel VBA: Managing Files and Data
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 4h 4m | 509 MB
Instructor: Curt Frye
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 4h 4m | 509 MB
Instructor: Curt Frye
In this course, Curt Frye—president of Technology and Society, Incorporated—guides you through effective ways to simplify your management of files and data with Excel VBA, a robust and flexible programming environment for Microsoft Excel workbooks. Using VBA to automate repetitive data import and management tasks can save you substantial time and streamline your processes.
Learn how to create a filter, chain criteria using AND, and combine criteria using OR. Determine if a file or folder exists, open and close workbooks, save workbooks under new names, and as CSV files. Create and rename worksheets, copy and move worksheets within and between workbooks. Plus, learn to use built-in functions, create and manage UserForms, and manage PivotTables using VBA. Combined with techniques to create and manage charts, work with PivotTables, and capture data using User Forms, file management in Excel VBA will greatly enhance your Excel workflows.
Learning objectives
- Understand how to import and export data using Excel VBA.
- Articulate how to create and manage workbooks using Excel VBA.
- Determine how to create and manage worksheets using Excel VBA.
- Examine how to utilize built-in functions in Excel VBA.
- Adapt methods to manage charts using Excel VBA.
- Implement ways to manage PivotTables using Excel VBA.
Excel VBA: Managing Files and Data
