lynda

Excel VBA: Managing Files and Data


  • flag Lynda
  • student Expert
  • database eLearning
  • earth English
  • clock 3h 13m

About

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 ^ 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.

Covered topics:

  • Business
  • Business Intelligence
  • IT
  • Excel