This package brings together nearly eight hours hours of personalized, expert video training: 50 Quick, Practical video lessons All That Demonstrate the skills you'll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development Environment.
LiveLessons are video courses on DVD with a book supplement, that are organized into bite-sized, self-contained sessions – you’ll learn key skills in as little as fifteen minutes. You’ll learn one step at a time, at your own pace – using hands-on examples that reflect realistic challenges and showcase Excel’s remarkable capabilities. Along the way, Jelen will take you from the absolute basics through PivotTables and data filtering.
Delivers the power of the best classroom training!

Excel VBA and Macros with MrExcel delivers the power of the best classroom training at a small fraction of the cost. If you don’t have time to read a huge book on Excel macros and scripting, this is exactly what you’ve been searching for! Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress. Follow along as your trainer shows you how to make the most of Excel’s macro recorder and its powerful VBA development environment!

Part 4: Making Decisions
Lesson 20: Simple If Then
Lesson 21: If Then Else
Lesson 22: Case Select

Part 5: Looping
Lesson 23: Find the last row in the data set today
Lesson 24: The basic For-Next Loop
Lesson 25: Typical Loop Example
Lesson 26: Loops when you have to delete
Lesson 27: Loops to do every other row
Lesson 28: Other loops like While, Do, etc
Lesson 29: The VBA Loop: For Each

Part 6: Dealing with Multiple Worksheets & Workbooks
Lesson 30: Creating new Worksheets
Lesson 31: Creating new workbooks
Lesson 32: Looping through all files in a folder
Lesson 33: Combining All Files in a Folder