Excel VBA: Managing Files and Data (2014)

- [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.