Automate complex tasks and get more meaningful insights from data in Excel using Visual Basic for Applications (VBA) code. This course demonstrates 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; build UserForm interfaces for data entry; and manage PivotTables using Excel VBA.
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