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.

Author: Jane Herrick

Runtime: 5hrs. 5min.

Lessons: 25

Lessons	Time (Min:Sec)
Introduction PREVIEW, CLICK HERE	00:32
Data Tables 1 PREVIEW, CLICK HERE	03:57
Data Tables 2 PREVIEW, CLICK HERE	03:06
Data Tables 3	06:28
Pivot Tables	17:48
Hyperlinks	08:21
Importing External Data	07:48
Importing External Data from Access	02:48
Importing a Text File	09:49
Concatenation Screens	07:03
Creating Queries	12:17
Linking Worksheets and Workbooks	26:32
Conditional Formatting and Comments	17:27
V Lookups 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

How does this Corporate Excel Training Program work?
With your multi-user corporate account, your entire company will have unlimited access to this course—and to every other course in our library—for one full year. Your employees can access this course from anywhere at anytime. They will also be able to achieve a Certificate of Proficiency after reviewing the entire course and passing the test we have provided. All you have to do is log in, select, click, and watch.