Excel VBA and Macros with MrExcel LiveLessons (video Training) [DVD-ROM]
English | FLV | FLV 1119 kbps 30 fps | 320?180 | MP3 96 kbps 44 KHz | 1h27mns | 3.43 GB

Genre: elearning

In Excel VBA and Macros with MrExcel, renowned Excel instructor and author Bill Jelen (MrExcel) teaches all the skills you’ll need to automate virtually any routine task with Excel and build powerful Excel macros!
This package brings together nearly eight hours hours of personalized, expert video training: 50 quick, practical video lessons that demonstrate all the skills you’ll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. 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.
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!

For all serious Excel users: managers, financial pros, entrepreneurs, marketers, analysts, and more.

Table of Contents

Part I Recording Macros
Lesson 1 Enable the Developer Tab
Lesson 2 Recording Your First Macro
Lesson 3 Running a Macro
Lesson 4 Keys to Successful Recording
Lesson 5 Variable Number of Rows
Lesson 6 Adding Totals
Lesson 7 Opening a Workbook with Macros

Part II Visual Basic Editor
Lesson 8 Introducing the VBA Editor
Lesson 9 VBA Help
Lesson 10 object Browser
Lesson 11 Stepping Through Code
Lesson 12 Immediate Window
Lesson 13 The Watch Window
Lesson 14 Breakpoints

Part III VBA Syntax
Lesson 15 VBA Parts of Speech
Lesson 16 Using Regular Variables
Lesson 17 Using object Variables
Lesson 18 Better Ways to Refer to Cells
Lesson 19 To Declare or Not To Declare?

Part IV Making Decisions
Lesson 21 If…Then…Else
Lesson 22 Select Case

Part V Looping
Lesson 23 Finding the Final Row
Lesson 24 Basic Looping
Lesson 25 Loop Example
Lesson 26 Deleting While Looping
Lesson 27 Every Other Row Loops
Lesson 28 Other Legacy Loops
Lesson 29 For Each Loops
Lesson 30 Creating Worksheets
Lesson 31 Creating Workbooks
Lesson 32 Listing Files in a Folder
Lesson 33 Combining Workbooks

Part VII Formulas
Lesson 34 A1-style Formulas
Lesson 35 R1C1-style Formulas
Lesson 36 Using Excel Functions in Code
Lesson 37 Adding Functions to Excel

Part VIII Power Tools
Lesson 38 Advanced Filter
Lesson 39 Filter Instead of Looping
Lesson 40 Pivot Tables
Lesson 41 Charts
Lesson 42 Event Handler Macros

Part IX Interacting
Lesson 43 Interacting
Lesson 44 Getting File Names
Lesson 45 Userforms
Lesson 46 Error Handling
Lesson 47 Suppressing alerts
Lesson 48 Faster Code
Lesson 49 Separating Code and Data
Lesson 50 Cleaning Recorded Code

Product details
DVD-ROM: 144 pages
Publisher: QUE; 1 edition (9 April 2009)
Language English
ISBN-10: 0789739380
ISBN-13: 978-0789739384
DVD includes:
7+ HOURS OF VIDEO INSTRUCTION
50 TIPS & TECHNIQUES
SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESS

About the Author

Bill Jelen is the host of MrExcel.com and the author of 24 books on Microsoft Excel, including Special Edition Using Microsoft Office Excel 2007, Pivot Table Data Crunching for Microsoft Office Excel 2007, VBA and Macros for Microsoft Excel, Excel Gurus Gone Wild, Excel for Marketing Managers, and Guerilla Data Analysis Using Microsoft Excel. He has made more than 60 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the
Computer America radio show. He has produced more than 900 episodes of his daily video podcast “Learn Excel from MrExcel.” Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years in the trenches as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year–for free–for readers all over the world. Jelen joins us from Akron, Ohio.

Download
http://ul.to/fz698ieo/Macros.part7.rar
http://ul.to/c1o334bj/Macros.part8.rar
http://ul.to/93iotmaf/Macros.part6.rar
http://ul.to/ouq8f27t/Macros.part5.rar
http://ul.to/hh84a9tc/Macros.part4.rar
http://ul.to/9o50zsev/Macros.part3.rar
http://ul.to/hmeifqnj/Macros.part2.rar
http://ul.to/rssis0d9/Macros.part1.rar

Mirror For Japan, EU, UAE, China, Au, Ru, SA, Brazil and Sing...
http://raload.com
http://downloadine.net/dl/3RKZRC2J18/Macros.part7.rar
http://downloadine.net/dl/R07TP1T36C/Macros.part8.rar
http://downloadine.net/dl/VX762SYSSQ/Macros.part6.rar
http://downloadine.net/dl/5M92277T8Q/Macros.part5.rar
http://downloadine.net/dl/540LT21927/Macros.part4.rar
http://downloadine.net/dl/63UY1JTGA8/Macros.part3.rar
http://downloadine.net/dl/8SL3R1BS8Z/Macros.part2.rar
http://downloadine.net/dl/LYGRJGOJ63/Macros.part1.rar