Excel VBA: Managing Files and Data
With Curt Frye
Liked by 487 users
Duration: 4h 4m
Skill level: Advanced
Released: 2/28/2025
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
AGWO AMADU A.
AGWO AMADU A.
HSEA-9 years +,ADNOC approved in (AGP & AON) IGC, 14001,45001, Oshad, Idip in process, PMP incident investigation, etc agwo5252@gmail.com
-
-
Contents
What’s included
- Practice while you learn 1 exercise file
- Learn on the go Access on tablet and phone
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.