Bill Jelen - Livelessons Excel VBA and Macros
English | FLV | FLV 1119 kbps 30 fps | 320x180 | MP3 96 kbps 44 KHz | 1h27mns | 3.43 GB
Genre: elearning
* 7+ HOURS OF VIDEO INSTRUCTION
* 50 TIPS & TECHNIQUES
* SKILLS YOU CAN LEARN IN Fifteen MINUTES OR LESS
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
http://www.filesonic.com/file/3983842134/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part1.rar
http://www.filesonic.com/file/3983841274/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part2.rar
http://www.filesonic.com/file/3983842034/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part3.rar
http://www.filesonic.com/file/3983835854/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part4.rar
http://www.filesonic.com/file/3983833994/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part5.rar
http://www.filesonic.com/file/3983832914/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part6.rar
http://www.filesonic.com/file/3983829884/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part7.rar
http://www.filesonic.com/file/3983822624/Livelessons___Excel_VBA_and_Macros_61_videos_FLV__51_spreadsheets_XLS__EXE.part8.rar
