Introduction to VBA for Excel
Take in introduction to VBA with this video
-
The topics that are covered are:
- Naming conventions 06:47.
- For loops 29:46
- If loops 40:13
- Do while loops 54:29
- Searching for data 1:03:31
- Error messages 1:08:08
Excel User Forms Explained Part 1
Take in Excel User Forms Explained Part 1 with this video
-
The topics that are covered are:
- Message boxes :37
- Message buttons 12:14
- Starting User forms 15:25
- Display user form 30:44
- Formatting User forms 34:55
- Checkboxes and option buttons 45:00
- Combo list boxes 1:12:52
- Dependent Combo boxes 1:38:08
- Scrollbars and spin buttons 1:46:24
Part two of Excel User forms
-
The topics that are covered are:
- Tab-strip
- Multi-page
- Search Form
- clear button
Introduction to Pivot tables and Dashboards
Take Introduction to Pivot tables and Dashboards with this video
-
The topics that are covered are:
- Create a pivot table :37
- Change names and format, 9:48
- Enter a calculated field 16:59
- Insert timeline 24:25
- Percent of total 29:28
- Grouping and replace blank cells 33:16
- Create a Pivot chart 38:43
- Planning your dashboard 47:01
- Create your dashboard. 49:53
More Courses to follow
