Livelessons Excel VBA and Macros | 3.43 GB
English | FLV | FLV 1119 kbps 30 fps | 320×180 | MP3 96 kbps 44 KHz | 1h27mns
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
Download (extabit.com)
Code:
http://extabit.com/file/2dvakkdr1pd7z/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part1.rar
http://extabit.com/file/2dvakkdr1pd8f/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part2.rar
http://extabit.com/file/2dvakkdr1pdcf/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part3.rar
http://extabit.com/file/2dvakkdr96mhb/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part4.rarMirror (turbobit.net)
Code:
http://turbobit.net/download/folder/1231287Mirror (turbobit.net)
Code:
http://turbobit.net/batxwe0k98ih/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part1.rar.html
http://turbobit.net/9p8jgz4r50di/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part2.rar.html
http://turbobit.net/8bxpr5t8yql7/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part3.rar.html
http://turbobit.net/jtfsddn34fmv/Livelessons - Excel VBA and Macros [61 videos (FLV) + 51 spreadsheets (XLS) + (EXE)].part4.rar.html
