Excel VBA and Macros with MrExcel LiveLessons (Video Training)
Fler böcker inom
Format
Mixed media product
Språk
Engelska
Antal sidor
144
Utgivningsdatum
2009-05-11
Upplaga
1
Förlag
QUE
Illustrationer
sd., col.
Dimensioner
233 x 192 x 25 mm
Vikt
400 g
Antal komponenter
2
Komponenter
DVD-ROM (1), Paperback (1)
ISBN
9780789739384
Excel VBA and Macros with MrExcel LiveLessons (Video Training)

Excel VBA and Macros with MrExcel LiveLessons (Video Training)

Excel VBA +Macros W/MrExcel_1

Mixed media product Engelska, 2009-05-11
349
Specialorder (osäker tillgång). Skickas inom 11-20 vardagar.
Fri frakt inom Sverige för privatpersoner.
DVD includes:

  • 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 youll 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 youll need to successfully use both the Excel macro recorder and the Visual Basic for Applications development environment. Youll learn one step at a time, at your own paceusing hands-on examples that reflect realistic challenges and showcase Excels 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 dont have time to read a huge book on Excel macros and scripting, this is exactly what youve been searching for!

 

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

 

Looking for a better way to master todays rapidly changing technologies? Want expert help, but dont have the time or energy to read a book? Cant find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the worlds leading technology experts.

  • LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessionsyoull learn key skills in as little as fifteen minutes!
  • Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
  • Follow along as your trainer shows you how to make the most of Excels macro recorder and its powerful VBA development environment!
 

Bill Jelen is called MrExcel for a reason! Nobody knows more about Excel macros and scriptingand nobody knows more about teaching these skills to working professionals! Thought youd never write your own Excel macros and programs? Think again! You willand you can start in just minutes!

 

Bill Jelen, known worldwide as MrExcel, presents live Excel seminars across the United States and appears in over 800 podcast episodes. His 20 Excel books include Special Edition Using Excel 2007 and VBA and Macros for Microsoft Excel. His website, MrExcel.com, answers 30,000 Excel questions per year.

 

System Requirements

  • OS: Windows 98, 2000, XP, and Windows Vista; Mac OS X; versions of Linux with the Flash 8 Player or later.
  • Multimedia: DVD drive, an 1024x768 or higher display, and a sound card with sp...
Visa hela texten

Passar bra ihop

  1. Excel VBA and Macros with MrExcel LiveLessons (Video Training)
  2. +
  3. Excel Charting Laminated Tip Card

De som köpt den här boken har ofta också köpt Excel Charting Laminated Tip Card av Bill Jelen (pamphlet).

Köp båda 2 för 404 kr

Kundrecensioner

Bloggat om Excel VBA and Macros with MrExcel LiveLes...

Övrig information

Bill Jelen is known worldwide as MrExcel. He presents live Excel seminars to accountants throughout the U.S., and has logged over 60 appearances on The Lab with Leo Laporte. He is author of 20 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel.

Innehållsförteckning

Part 1 Recording Macros XIV

Lesson 1    Enable the Developer Tab 1

    What You Will Learn................................................................................1

    Notes from the Lesson............................................................................1

    Differences in Excel 2003........................................................................1

Lesson 2    Recording Your First Macro 2

    What You Will Learn................................................................................2

    Notes from the Lesson............................................................................2

    In Excel 2003 ...........................................................................................2

    Code from the Lesson.............................................................................3

Lesson 3    Running a Macro 4

    What You Will Learn................................................................................4

    Notes from the Lesson............................................................................4

    In Excel 2003 ...........................................................................................5

    Code from the Lesson.............................................................................5

Lesson 4    Keys to Successful Recording 6

    What You Will Learn................................................................................6

    Notes from the Lesson............................................................................6

    In Excel 2003 ...........................................................................................6

    Code from the Lesson.............................................................................7

Lesson 5    Variable Number of Rows 8

    What You Will Learn................................................................................8

    Related Lessons.......................................................................................8

    Notes from the Lesson............................................................................8

    Code from the Lesson.............................................................................8

Lesson 6    Adding Totals 9

    What You Will Learn................................................................................9

    Notes from the Lesson............................................................