->
Excel VBA: Managing Files and Data
Categories: Tutorials » Other Tutorials

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

 

Excel VBA: Managing Files and Data
------------------------------------------------------------------------------------------
Excel VBA: Managing Files and Data
    


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Gamystyle   |  

Information
Members of Guests cannot leave comments.


Categories Sitemap



rss