Ebook Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg
Reviewing publication Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg, nowadays, will not compel you to consistently acquire in the establishment off-line. There is a great place to get guide Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg by on the internet. This site is the very best site with whole lots numbers of book collections. As this Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg will certainly remain in this publication, all publications that you require will be right below, as well. Merely search for the name or title of guide Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg You can locate exactly what you are looking for.
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg
Ebook Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg
How if there is a site that allows you to look for referred publication Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg from all around the globe author? Automatically, the website will certainly be amazing finished. Numerous book collections can be found. All will be so easy without complicated point to move from website to site to obtain the book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg wanted. This is the website that will certainly provide you those assumptions. By following this website you can acquire great deals varieties of book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg collections from variations sorts of author and also author popular in this globe. The book such as Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg and others can be gotten by clicking wonderful on link download.
Well, e-book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg will certainly make you closer to exactly what you want. This Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg will certainly be always buddy at any time. You might not forcedly to constantly finish over checking out an e-book in brief time. It will be only when you have downtime and also spending couple of time to make you really feel satisfaction with exactly what you review. So, you can obtain the definition of the message from each sentence in the book.
Do you understand why you must read this website as well as exactly what the connection to reviewing book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg In this modern era, there are numerous methods to get guide and also they will certainly be much simpler to do. Among them is by getting the e-book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg by on the internet as what we inform in the link download. The publication Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg could be a selection considering that it is so proper to your necessity now. To obtain the e-book on the internet is quite easy by only downloading them. With this opportunity, you can read the publication any place and whenever you are. When taking a train, hesitating for list, and also awaiting an individual or other, you could review this on-line publication Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg as a buddy again.
Yeah, checking out an e-book Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg could include your buddies checklists. This is one of the formulas for you to be effective. As known, success does not mean that you have excellent things. Recognizing and also knowing greater than other will provide each success. Close to, the message and perception of this Excel VBA: For Non-Programmers (Programming In Everyday Language), By Maayan Poleg can be taken and also picked to act.
Excel VBA
Microsoft Excel has, over the years, become the greatest software in the field of electronic worksheets.
Its strength is that it meets the demands of huge numbers of users worldwide. Nonetheless - despite the advancement and expanding use of this software - there is ever-increasing demand from the end users; much of which can only be solved by VBA programming (Visual Basic for Applications).
Therefore, “Excel VBA – In Everyday Language” was written in order to provide a response to the growing demand for the advanced capabilities of Microsoft Excel.
This book was written:
• For the “non-programmers” among us who have to create the same reports in Microsoft Excel time and again, and would like to automate the process.
• For people who wish to develop forms, screens and “machines” for data management within their organization.
• For individuals who wish to turn Microsoft Excel into a powerful tool in their daily work.
For Non-Programmers
During the writing process I tried to visualize Microsoft Excel software and the VB editor through the eyes of the end users; people who may not have programming background, but aspire to reap the utmost from the program.
For this reason the book, based on many years' of experience in programming and training, has been written in everyday language, using as few technical terms as possible, to make for easy reading.
My goal, when writing this book, was to convey the main principles of VBA language and allow beginners, taking their first steps, to learn without requiring individual training.
For this purpose there are files of exercises accompanying the book. These may be downloaded from this link.
The exercise files are in .xls format, allowing the end users to use either the “Ribbon Versions” (2007 and higher) or other older versions of Microsoft Excel.
This new edition has undergone extensive processing and addresses Microsoft Excel 2010/2013 users, along with explanations for anyone using the older versions (2003 and 2007). Therefore, wherever there is a significant difference between Excel 2010/2013 and the old versions, explanations are provided in full.
While reading the book and using the practice files, you will know to:
• Add the Developer Tap
• Change Excel's security, Including trusted locations
• Enter the VBE (Visual Basic Editor)
• Change the VBE structure
• Record an absolute macro
• Record a relative macro
• Improve your recorded macro
• Apply to ranges (Cells, ranges, columns, rows, sheets, offset)
• Use Variables
• Use the 'With' command
• Manipulate strings
• Calculate Date and Time
• Interact with the user (Msgbox and Inputbox)
• Use conditions (IF)
• Loop through data (Do loops, For loops)
• Create your own functions (UDF)
• Create an Event macro
• Handle Errors
You will also learn some cool tips and tricks, and get some useful codes
The book includes excercises. you can download the files from:
bit.ly/Excel-VBA
- Sales Rank: #30512 in eBooks
- Published on: 2014-04-14
- Released on: 2014-04-14
- Format: Kindle eBook
About the Author
Maayan Poleg holds an MA in Education Administration. She instructs and develops Excel's applications since 1996. Maayan has an extensive knowledge and experience in the field of VBA training You can contact Maayan at: Maayan@excel-vba.guru
Most helpful customer reviews
18 of 19 people found the following review helpful.
Not really for "non-programmers"
By Bob Kaplan
For several years now I have been looking for a resource that truly explains how to use VBA to people who are not programmers. This does the job partially.
Maybe I'm just looking for something that doesn't exist. But, I would just like someone to explain in simple (non-programming) elementary terms what common terms in VBA mean.
For example: "Activecell.value" - I think that means something about the cell you have highlighted and where your cursor is is the "active cell". But, TELL ME that. THEN, what does the addition of the term "value" mean? etc etc.
10 of 11 people found the following review helpful.
I could do this manually but I figured it will take a half day and it will be boring. so I downloaded the book and start reading
By A2life
I consider myself as a fairly experienced weekend programmer (python,c++, javascript etc.,) However, I have never touched VBA before. Time over time I thought about learning VBA but never had a chance. I finally looked up Amazon when I was given a task list in Excel form which needed a serious reworking. the list item count was about 400. Some of the item need to be duplicated multiple times par the information on one column value. I could do this manually but I figured it will take a half day and it will be boring.
so I downloaded the book and start reading. I went through the whole material in one sitting. I started to experiment with the test file when I was at 50% of the book, at 80% of the book, I had a working VBA code that solved my problem. and now I have a cleaned up list with 600+ item count. Since I already knew about decision tree and looping, What I needed to start learning was how the program will interact with Excel cells and its contents. The book gave me these learning points very quickly. Also the author introduce "record macro" as the way to read and learn the VBA code and debugging technique early in the book. this turned out to be very helpful. Money and time worth spent. It was an exciting three hours.
15 of 18 people found the following review helpful.
VBA book that will boost up your Excel performance if you do not know VBA
By VitoshAcademy
I am a blogger, writing articles for VBA, C# and other interesting programming languages. Upon a request from my site, I was provided with a Kindle version of the book for a review
First things first - I am not sure what should be done to pursue the non-IT people, that VBA is not something difficult and every hour you spend, trying to master it would pay out by saving 20 others, pressing ctrl+arrows and copying endless ranges in Excel. That is why I am always eager to take a look into the VBA books and to review them in my site. As far as this one was for non programmers and I am not exactly a non-programmer, I was really interested what it can teach a person with no idea in VBA and I tried to find at least 3 VBA tricks I did not know. So here they are.
The things I did not know before reading:
1. The fact that if you record a macro in excel in the Personal Macro Workbook, it would be recorded into a Personal.xlsb file, loaded when Excel starts and available for all workbooks, as shown in the next two screenshots:
PersonalMacroWorkbookPersonalMacroWorkbook2
2. The "Use Relative References" possibility for recording a macro - a good option, if you want to avoid hardcoding of the range. Thus, the code is recorded with offsets, based on the current selection. Quite useful for a beginner.
RelativeReferenceOption
3. Creating a "switch for value changes - this is simply a macro, which takes into account the current state of a given TRUE/FALSE feature and returns it with the other one. E.g. if a column is hidden, it makes it not hidden and vice versa. I was doing this with if, but the current code is way better and faster. It simply takes the status of the column and makes it reverse. Here is what it looks like:
[code]
Sub HideUnhideColumnB()
Dim bStatus As Boolean
bStatus = Columns("B:B").EntireColumn.Hidden
Columns("B:B").EntireColumn.Hidden = Not bStatus
End Sub
[/code]
Lets start with the real review now :)
The screenshots of the Kindle edition were clear and easy to understand. I liked the way the range selection was thoroughly explained. It was explained with the Excel shortcuts and the VBA code, which actually runs them.
E.g. Ctrl+Shift+8 => ActiveCell.CurrentRegion.Select. This was worthy! Some valuable tips for beginners were given, that save a lot of time - e.g. "do not copy a single cell value to another cell, but use Range("a4").Value - Range("a3").Value". Local and watch window are explained. If you are new to Excel VBA, try to make a habit to use the Watch window, it would be of use later. I myself do it rarely, but if I was accustomed to it from the beginning my performance would have been higher. At a later stage, the variables are explained, with some good explanation for Date and Time, which is a key variable in VBA (and is not mistaken as in Excel, good work for Microsoft there). At a later stage I liked the way the message box and the conditional operators were explained together. This saves time for the reader :) User defined functions, error handling and events were also explained on a level that would be understandable for a beginner.
What I liked really much in the book, was the last two chapters - the last one was concerning some useful codes, that may increase your interest into VBA development. (The switch for value changes from above is from there.). The last chapter is with exercises. You can solve them with your knowledge from the book, the correct code is not provided.
So, long story short - the book is for beginners in programming. If you are working with Excel on a daily basis, you will profit from the book, if you have no VBA experience. If you are an experienced VBA user, then look for something else. And just do not be afraid to try the code as it goes.
That's all from me! :)
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg PDF
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg EPub
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg Doc
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg iBooks
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg rtf
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg Mobipocket
Excel VBA: for Non-Programmers (Programming in Everyday Language), by Maayan Poleg Kindle
Tidak ada komentar:
Posting Komentar