Course Description: Put Microsoft Excel's more advanced features and functions under your fingertips. Learn to make your work easier with 'if statements,' cost extensions, amortization tables, and much more.
| Lessons |
Time
(Min:Sec) |
|
|---|---|---|
| Introduction PREVIEW, CLICK HERE | 00:32 | |
| Data Tables (Part 1) PREVIEW, CLICK HERE | 03:57 | |
| Data Tables (Part 2) PREVIEW, CLICK HERE | 03:06 | |
| Data Tables (Part 3) | 06:28 | |
| PivotTables | 17:48 | |
| Hyperlinks | 08:21 | |
| Importing External Data | 07:48 | |
| Importing External Data from Access | 02:48 | |
| Importing a Text File | 09:49 | |
| Concatenation Strings | 07:03 | |
| Creating Queries | 12:17 | |
| Linking Worksheets and Workbooks | 26:32 | |
| Conditional Formatting and Comments | 17:27 | |
| VLOOKUP and Name Ranges | 21:05 | |
| Working with Macros | 08:34 | |
| Debugging Techniques | 20:51 | |
| VBA Code | 09:18 | |
| Visual Basic Commands | 20:40 | |
| Recording Macros | 06:42 | |
| Macro Codes and Commands | 14:56 | |
| The Case Command | 09:51 | |
| Debugging and Saving Your Macros | 06:45 | |
| Templates | 10:17 | |
| Working with Large Worksheets | 28:12 | |
| Subtotals | 12:52 |
To access this lesson, you need to log in to your account.
Enter your username and password in the boxes at the top right corner of this page.
