ComicsChildrenHumorFitnessReferenceITLawCookingHobbiesTeachingSelf-HelpPhotoFantasyHistoryTestsCalendarsFictionLGBTTeenagersTransportMemorisMedicineMysteryRelationshipsPoliticsBusinessSpiritualityRomanceBiblesMathSportTravelOtherNo category
» » Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series)
Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series) e-book

Author:

Dr. Gerard Verschuuren

Language:

English

Category:

IT

Subcategory:

Software

ePub size:

1418 kb

Other formats:

rtf docx doc txt

Rating:

4.7

Publisher:

Holy Macro! Books (October 1, 2003)

ISBN:

0972425853

Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series) e-book

by Dr. Gerard Verschuuren


It's 2,500 Excel VBA Examples - A CD ROM with TONS of ACTUAL VBA excel examples, though some are buggy.

It's 2,500 Excel VBA Examples - A CD ROM with TONS of ACTUAL VBA excel examples, though some are buggy. VBA and Macros for Microsoft Excel - Though I am not a fan of training myself by reading a book, this book is MUCH easier to follow and much better organized. This book also has a more conversational style, which is what keeps my eyes from glazing over. Overall, I'm sad to say that I'm disappointed with this CD-ROM

A self-guided Excel VBA training course A complete Excel.

A self-guided Excel VBA training course A complete Excel. This book is not yet featured on Listopia.

This course, developed by college professor Dr. Gerard Verschuuren is. .Even if you took a programming class 10 years ago, Excel VBA seems tough to learn. Learn Excel VBA in full color

This course, developed by college professor Dr. Gerard Verschuuren is the answer. It is not like the BASIC you are used to. The recorded macros rarely work the way you want them to. This course, developed by college professor Dr. He is author of Join the Excellers League and Excel for Scientists. Completely Visualized! Learn Excel VBA in full color. Every slide has rich illustrations to demonstrate the concept. Completely Visualized.

A self-guided Excel VBA training course A complete Excel training course, this CD-ROM contains three completeĀ .

Book Depository is an international bookseller. We really, really love books and offer millions of titles, currently over 10 million of them, with this figure increasing daily.

Developed and tested for business training, this CD-ROM is ideally suited for self-instruction using a screen shot approach versus an overabundance of text. More than 1,400 slides, with examples drawn from actual cases, are divided into three modules covering VBA basics, how to calculate with VBA, and letting VBA interact with the user.

Find nearly any book by Dr. Gerard Verschuuren

Find nearly any book by Dr. Gerard Verschuuren. Get the best deal by comparing prices from over 100,000 booksellers.

Microsoft Excel VBA Codes Are Fun, Simple, and Easy to Learn in OneĀ . Code that runs under the control of the CLR is called managed code.

PowerPivot Alchemy: Patterns and Techniques for Excel. You probably have been working with VBA for quite a while and like working with this programming tool. BCL (Base Class Libraries): BCL provides many regular functions such as MsgBox(), InStr(), and UCase().

You should never use Select and ActiveSheet that way, it is not necessary; and never use Cells without the sheet it should be referring to. (Val can be omitted if the cell is really already numeric and not text). This code works perfectly fine for me. Worksheets(1). NumberFormat "@" Worksheets(1). NumberFormat "000000" Worksheets(1).

Writing Excel Macros with VBA by Steven Roman, PhD Paperback Book The Cheap Fast.

A complete Excel training course, this CD-ROM contains three complete one-day modules that teach VBA basics and show how to use the macro recorder and then edit the code in order to make a usable macro. Examples demonstrate how to control charts and pivot tables using VBA, and clear explanations reveal the difference between methods and properties. The second module covers how to calculate with VBA covering loops, functions, formulas, and arrays. The third module discusses how to build a successful application that will interact with the user. Userforms and event handlers are also discussed.
Kerahuginn
I have worked with Excel on a daily basis for over 7 years now, and I tend to be pretty quick to pick up on computer-related topics, especially Excel. I am a Financial Analyst for a rather large company, and I decided that I would order "Slide Your Way Through Excel VBA" because I wanted to learn to use VBA with Excel and teach my co-workers, as well.
I honestly expected a lot more out of this CD ROM than I got, and ultimately I was disappointed. I'm not saying I won't *eventually* learn Excel VBA from this CD ROM, but I wish I'd had a test drive before buying. (technically, my company bought this...at my recommendation)

First, the CD ROM basically contains 3 Power Point slide shows. That's it. No handbook, no introductory information, nothing else, just a CD with 3 LENGTHY Power Point presentations. Oh yeah...and no audio either, which I mistakenly thought there might be. So it's a lot of reading and clicking through slides.

Second, the general appearance of the slides is unappealing with a bright magenta background and basic Comic font. Not only is the coloring difficult on the eyes after a while, but the format is very "homemade" looking. On the plus side, the graphics of the actual Excel Screens look nice.

Third, I found the presentation of the execution of VBA to be very sterile and lacking organization. I would have expected a more conversational or step by step approach, such as, "Suppose you want to..." followed by...."you might want to xxxx, or in some cases xxx...." or "the reason this must be formatted this way is xxxx". Most sections I felt like I had just walked in mid-way through a lecture.

Basically, I feel like the presentations is a collection of facts that aren't necessarily connected or laced together in a way that helps an inexperienced VBA user get the big picture. I asked my co-workers their opinions, and they all agreed.

Additionally, while in the power point presentation, there is a button to "mark this slide." This seems really handy at first. I thought I could mark the slide, close the presentation, open it later, and go back to THAT slide. What it actually does is only mark that slide while you have the presentation open; for instance, you may mark slide 10 and progress to slide 20, and then go back to slide 10 at the click of the button.

The down side is unless you're completing the ENTIRE presentation at once, you cannot just double-click the program icon to open up to where you left off. If you do that, it will open the presentation into slide-show format, and you will have to make your way through each slide from the beginning (and RE-Answer the questions from before) because the "right-click> go to slide #" feature is disabled in this slide show. The way around this is to not open by double-clicking the program icon; Instead open powerpoint, then go to File>Open and then select the slideshow you want...then you can preview the individual slides and select the one you need.

This became too tedious, so ultimately my co-workers and I printed the entire presentation out (in color-sorry to Jim in Re-Pro, but we *did* 2 slides per page and 2 sided copies) and placed it in a 3-ring binder. Now we can tab and flag different sections, AND have the slide in front of us and still be able to practice the approach in Excel. It's also helpful because we can write notes to ourselves by the content.

Two other products I ordered with this CD-ROM are also "MR. Excel" products, which I believe could take the place of the "Slide your way..." CD-ROM. Both are better organized and easier to follow:
**Holy Macro! It's 2,500 Excel VBA Examples -- A CD ROM with TONS of ACTUAL VBA excel examples, though some are buggy. I believe updates/corrections are available through the Mr. Excel Site.
**VBA and Macros for Microsoft Excel -- Though I am not a fan of training myself by reading a book, this book is MUCH easier to follow and much better organized. This book also has a more conversational style, which is what keeps my eyes from glazing over.

Overall, I'm sad to say that I'm disappointed with this CD-ROM. I will still use the content, but not in the slide show format, and it comes in 3rd place of the 3 reference pieces I bought to help myself learn VBA for Excel. I'd prefer to give a 2.5 star rating, but lucky for Mr. Excel Amazon has a "whole" star system, and I feel like I have to round up to 3 stars. I hope the Mr. Excel team can find this feedback to be useful and polish up a future version.
Ger
What I liked the most about this CD is its interactivity. The recurring self-checks are terrific - at the right moment and with the perfect challenge. I actually carry the CD with me to work, and whenever I have a spare moment, I enjoy learning new ways of controlling Excel. The examples have helped me a lot to develop my own code. It's a great didactic tool.
generation of new
I've gone through about a third of the slides and I feel that I've already learned enough VBA to create some amazing macros. The three powerpoint decks are enourmous - nearly 1,000 slides in all. While the slide formatting is a little funky, it's all about the content folks. If you want to learn VBA, buying this program is probably the best way to learn it. I truly believe that.
Bumand
I keep going back to this marvellous CD each time I need to refresh my memory. What I love about it is the fact that it is interactive and extremely clear, so it puts me right back on track.

e-Books related to Slide Your Way Through Excel VBA: Learn to Keep Excel Under Control with VBA (Visual Training series)