Learn how to streamline data and file management in Microsoft Excel by using VBA.
Course details
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.
Homepage:

https://www.linkedin.com/learning/excel-vba-managing-files-and-data-25320834