Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel

Excel VBA and Macros with MrExcel LiveLessons (Video Training), (Downloadable Video)

Register your product to gain access to bonus material or receive a coupon.

Excel VBA and Macros with MrExcel LiveLessons (Video Training), (Downloadable Video)

Downloadable Video

  • Your Price: $39.99
  • List Price: $49.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Description

  • Copyright 2010
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4556-9
  • ISBN-13: 978-0-7897-4556-9

7+ Hours of Video Instruction

Excel VBA and Macros with MrExcel is the world’s first complete video training course on the topic. 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!

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

LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more.  View All LiveLessons

http://www.quepublishing.com/imprint/series_detail.aspx?st=87397

Downloads

Downloads

Download the extras

Sample Content

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

Updates

Submit Errata

More Information

ONE MONTH ACCESS!

WITH PURCHASE


Get unlimited 30-day access to thousands of Books & Training Videos about technology, professional development and digital media If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months.