1 option
Excel VBA: Managing Files and Data. / with Curt Frye.
- Format:
- Video
- Author/Creator:
- Frye, Curtis, 1968- speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Video recordings.
- Physical Description:
- polychrome
- Place of Publication:
- Carpenteria, CA linkedin.com, 2020.
- System Details:
- Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
- Summary:
- 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 Manipulating PivotTables with VBA
- 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.
- Participant:
- Presenter: Curt Frye
- Notes:
- 10/13/202012:00:00AM
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.