Excel VBA - Managing Files & Data | 4+ hrs Course

Excel VBA: Managing Files and Data | 4+ hrs Video Course

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. Excel expert 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.

Topics covered | duration : 4+ hrs Video Course

01 Focusing Data Using Filters

02 Managing Files Using VBA

03 Managing Worksheets Using VBA

04 Taking Advantage of Built-In Functions

05 Managing Charts Using VBA

06 Creating UserForms

07 Managing PivotTables Using VBA