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


Table of Contents

  • 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 User Forms
  • Conclusion
  • Lynda - Excel VBA: Managing Files and Data


    Information
    Members of Guests cannot leave comments.




    rss