Excel VBA: Managing Files and Data

Excel VBA: Managing Files and Data
Duration: 3hr 13m | Video: h264, yuv420p, 1280x720 30fps | Audio: aac, 44100 Hz, 2ch | 315 MB
Genre: eLearning | Language: English

Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course extends the techniques taught in Up and Running with Excel VBA, showing members how to work more efficiently in this powerful and popular spreadsheet program. Curt Frye shows how to focus in on important data, with filters; manage workbooks and worksheets; access built-in functions; create charts; and build UserForm interfaces for data entry.

Topics include:

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

------------------------------------------------------------------------------------------

Would you like to be a Author?

Friends (email)