Coverart for item
The Resource Excel VBA and macros with MrExcel : video training, by Bill Jelen

Excel VBA and macros with MrExcel : video training, by Bill Jelen

Label
Excel VBA and macros with MrExcel : video training
Title
Excel VBA and macros with MrExcel
Title remainder
video training
Statement of responsibility
by Bill Jelen
Contributor
Subject
Language
eng
Summary
"Using Microsoft Excel 2007's built-in VBA scripting capabilities, serious Excel users can potentially save dozens - or even hundreds - of hours per year. But most Excel users have never truly mastered VBA scripting, and many don't have time to read a book on the subject. That's where VBA and Macros for Microsoft Excel (Video LiveLessons) comes in. In more than 60 bite-sized, self-contained video lessons, Bill Jelen ('MrExcel') helps Excel users master all the scripting techniques they need to automate virtually any repetitive Excel task - and gives them specific answers and solutions for their scripting problems immediately, whenever they need them. He begins by introducing Excel's simple built-in macro recorder, explaining what it can and can't do, and walking through the code it produces. Next, he introduces Microsoft Excel's powerful VBA editor and debugging tools, and shows how to write the crucial code that can't be created automatically by the macro recorder. One step at a time, viewers will discover how to use loops, variables, ranges, flow control, and more. Next, Jelen puts it all together with start-to-finish case study applications, and introduces advanced techniques that automate everything from filters to PivotTables, user input to error and event handling."--Resource description page
Member of
Cataloging source
UMI
Characteristic
videorecording
http://library.link/vocab/relatedWorkOrContributorName
Jelen, Bill
Runtime
475
Series statement
LiveLessons
http://library.link/vocab/subjectName
  • Business
  • Electronic spreadsheets
Technique
live action
Label
Excel VBA and macros with MrExcel : video training, by Bill Jelen
Link
http://databases.mvlc.org/connect/safari?uiCode=&xmlId=9780768690729
Instantiates
Publication
Note
Title from resource description page (viewed Apr. 24, 2009)
Accompanying material
downloadable exercise files.
Carrier category
  • online resource
  • other
Carrier category code
  • cr
  • vz
Carrier MARC source
  • rdacarrier
  • rdacarrier
Color
multicolored
Configuration of playback channels
unknown
Content category
two-dimensional moving image
Content type code
  • tdi
Content type MARC source
rdacontent
Control code
ocm319836357
Dimensions
unknown
Extent
1 streaming video file (7 hr., 55 min., 2 sec.)
Form of item
electronic
Isbn
9780768690729
Media category
  • computer
  • video
Media MARC source
  • rdamedia
  • rdamedia
Media type code
  • c
  • v
Medium for sound
other
Other physical details
digital, sound, color +
Reproduction note
Electronic reproduction.
Sound
sound
Sound on medium or separate
sound on medium
Specific material designation
  • remote
  • other
Stock number
CL0500000040
System details
System requirements: Adobe Flash Player, version 8 or higher; or QuickTime Player, version 7.2 or higher; or Windows Media Player, version 11 or higher
Video recording format
other
Label
Excel VBA and macros with MrExcel : video training, by Bill Jelen
Link
http://databases.mvlc.org/connect/safari?uiCode=&xmlId=9780768690729
Publication
Note
Title from resource description page (viewed Apr. 24, 2009)
Accompanying material
downloadable exercise files.
Carrier category
  • online resource
  • other
Carrier category code
  • cr
  • vz
Carrier MARC source
  • rdacarrier
  • rdacarrier
Color
multicolored
Configuration of playback channels
unknown
Content category
two-dimensional moving image
Content type code
  • tdi
Content type MARC source
rdacontent
Control code
ocm319836357
Dimensions
unknown
Extent
1 streaming video file (7 hr., 55 min., 2 sec.)
Form of item
electronic
Isbn
9780768690729
Media category
  • computer
  • video
Media MARC source
  • rdamedia
  • rdamedia
Media type code
  • c
  • v
Medium for sound
other
Other physical details
digital, sound, color +
Reproduction note
Electronic reproduction.
Sound
sound
Sound on medium or separate
sound on medium
Specific material designation
  • remote
  • other
Stock number
CL0500000040
System details
System requirements: Adobe Flash Player, version 8 or higher; or QuickTime Player, version 7.2 or higher; or Windows Media Player, version 11 or higher
Video recording format
other

Library Locations

    • Merrimack Valley Library ConsortiumBorrow it
      4 High Street, Suite 175, North Andover, MA, 01845, US
      42.7009413 -71.1255084
Processing Feedback ...