Author
Released
12/23/2014- Creating filters
- Chaining and combining filter criteria
- Determining whether workbooks and worksheets exist, with VBA
- Opening, closing, and saving workbooks
- Using VBA to calculate data via Excel's built-in functions
- Creating charts with sparklines
- Adding fields to UserForms
Skill Level Advanced
Duration
Views
- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel VBA Managing Files and Data. In this course, I will show you how to use visual basic for applications to enhance the capabilities of Microsoft Excel. I will start by showing you how to filter your data. Next, I'll show you how to manage your Excel workbooks by determining if a workbook exists, detecting if a workbook is open and opening, closing, and saving your workbooks using VBA. Chapter three shows you how to manage worksheets.
Chapter four shows you how to take advantage of built in worksheet functions in VBA while chapter five shows you how to create charts. Finally, chapter six discusses user forms. I'm sure that you'll find your time with Excel VBA Managing Files and Data will be time well spent. Dive right in.
Related Courses
-
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced -
Cleaning Up Your Excel 2013 Data
with Dennis Taylor1h 59m Intermediate
-
Introduction
-
Welcome51s
-
-
1. Focusing Data Using Filters
-
Selecting the current region3m 25s
-
Creating a filter6m 11s
-
Chaining criteria using AND2m 46s
-
Combining criteria using OR5m 27s
-
-
2. Managing Files Using VBA
-
Opening a workbook3m 45s
-
Closing a workbook5m 15s
-
3. Managing Worksheets Using VBA
-
4. Taking Advantage of Built-In Functions
-
5. Managing Charts Using VBA
-
Creating a chart4m 7s
-
Creating a line sparkline2m 15s
-
Creating a column sparkline2m 36s
-
Deleting a sparkline1m 27s
-
-
6. Creating User Forms
-
Running a UserForm2m 13s
-
Conclusion
-
Further resources1m 26s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome