{"product_id":"excel-vba-for-non-programmers-paperback","title":"Excel VBA: for Non-Programmers - Paperback","description":"\u003cp\u003eby \u003cb\u003eMaayan Poleg\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eWhile reading the book and using the practice files, \u003cstrong\u003eyou will know to\u003c\/strong\u003e \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eRecord a macro (absolute + relative )\u003c\/li\u003e\n\u003cli\u003eImprove your recorded macro\u003c\/li\u003e\n\u003cli\u003eUse VBA to apply to ranges (Cells, ranges, columns, rows, sheets, offset)\u003c\/li\u003e\n\u003cli\u003eUse Variables\u003c\/li\u003e\n\u003cli\u003eUse the 'With' command\u003c\/li\u003e\n\u003cli\u003eManipulate strings\u003c\/li\u003e\n\u003cli\u003eCalculate Date and Time\u003c\/li\u003e\n\u003cli\u003eInteract with the user (Msgbox and Inputbox)\u003c\/li\u003e\n\u003cli\u003eUse conditions (IF)\u003c\/li\u003e\n\u003cli\u003eLoop through data (Do loops, For loops)\u003c\/li\u003e\n\u003cli\u003eCreate your own functions (UDF)\u003c\/li\u003e\n\u003cli\u003eCreate an Event macro\u003c\/li\u003e\n\u003cli\u003eHandle Errors You will also learn some cool tips and tricks, and get some useful codes\u003c\/li\u003e\n\u003cli\u003eChange Excel's security, Including trusted locations\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e \u003c\/p\u003e\u003cp\u003eMicrosoft Excel has, over the years, become the greatest software in the field of electronic worksheets.\u003c\/p\u003e\u003cp\u003eIts strength is that it meets the demands of huge numbers of users worldwide.\u003c\/p\u003e\u003cp\u003eNonetheless - 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).\u003c\/p\u003e\u003cp\u003eTherefore, Excel VBA - In Everyday Language was written in order to provide a response to the growing demand for the advanced capabilities of Microsoft Excel. \u003cbr\u003eThis book was written: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFor 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.\u003c\/li\u003e\n\u003cli\u003eFor people who wish to develop forms, screens and \"machines\" for data management within their organization.\u003c\/li\u003e\n\u003cli\u003eFor individuals who wish to turn Microsoft Excel into a powerful tool in their daily work.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eDuring the writing process I tried to visualize Microsoft Excel software and the VB editor through the eyes of the end users; \u003cbr\u003epeople who may not have programming background, but aspire to reap the utmost from the program. \u003cbr\u003eFor this reason the book, based on many years' of experience in programming and training, \u003cbr\u003ehas been written in everyday language, \u003cbr\u003eusing as few technical terms as possible, to make for easy reading. \u003cbr\u003eMy goal, when writing this book, was to convey the main principles of VBA language \u003cbr\u003eand allow beginners, taking their first steps, to learn without requiring individual training. \u003cbr\u003eFor this purpose there are files of exercises accompanying the book. \u003cbr\u003eThese may be downloaded from this link.\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003eMaayan 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\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 176\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.38 x 9.02 x 5.98 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e September 23, 2013\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42117480054919,"sku":"9781492993315","price":18.32,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0601\/2623\/2711\/files\/3941808b32493c117a314f7a8ff29024.webp?v=1732524935","url":"https:\/\/booksby.splitshops.com\/products\/excel-vba-for-non-programmers-paperback","provider":"Books by splitShops","version":"1.0","type":"link"}