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

Excel VBA: Managing Files and Data
Excel VBA: Managing Files and Data
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.


  • Introduction
  • 1. Focusing Data Using Filters
  • 2. Managing Files Using VBA
  • 3. Managing Worksheets Using VBA
  • 4. Taking Advantage of Built-In Functions
  • 5. Managing Charts Using VBA
  • 6. Creating UserForms
  • 7. Managing PivotTables Using VBA
  • Conclusion


 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