{"product_id":"visual-basic-for-excel-supports-2010-2013-2016-and-365-9798491450619","title":"Visual Basic For Excel: Supports 2010, 2013, 2016, and 365","description":"\u003cb\u003eExcel Visual Basic\u003c\/b\u003e is a programming tool used to enhance the capability of \u003cb\u003eExcel\u003c\/b\u003e and requires advanced skills to use it effectively. \u003cb\u003eVisual Basic\u003c\/b\u003e will help to automate repeating operations and redundant tasks. Once you understand how to use \u003cb\u003eExcel VBA\u003c\/b\u003e, you'll be able to apply your \u003cb\u003eVBA\u003c\/b\u003e programming knowledge to other \u003cb\u003eMS Office\u003c\/b\u003e products, including \u003cb\u003eMicrosoft Word and Access\u003c\/b\u003e.\u003cbr\u003e\u003cb\u003eObtain Your PDF Copy and Video Course\u003c\/b\u003e\u003cbr\u003eThis workbook includes an \u003cb\u003eOnline Recorded Video\u003c\/b\u003e course and \u003cb\u003ePDF Download\u003c\/b\u003e. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. \u003cp\u003e\u003c\/p\u003eThis \u003cb\u003eWorkbook\u003c\/b\u003e supports \u003cb\u003eExcel 2010\u003c\/b\u003e, \u003cb\u003e2013, \u003c\/b\u003e and \u003cb\u003e2016 \u003c\/b\u003ebecause the \u003cb\u003eVBA\u003c\/b\u003e commands are very similar. However, some commands function differently between \u003cb\u003eExcel\u003c\/b\u003e versions, and many of these will be noted in the courseware. Also, you will be able to create \u003cb\u003eVB\u003c\/b\u003e code and run routines that are not possible using standard \u003cb\u003eExcel\u003c\/b\u003e commands. \u003cp\u003e\u003c\/p\u003eThis \u003cb\u003eWorkbook\u003c\/b\u003e will employ the \u003cb\u003eVisual Basic Application (VBA) \u003c\/b\u003eprogramming language that is built into \u003cb\u003eExcel.\u003c\/b\u003e Students will begin by starting the command \u003cb\u003eRecorder\u003c\/b\u003e, performing a series of commands or operations in \u003cb\u003eExcel\u003c\/b\u003e, stopping the recorder, and then running the recording to see if it operates. These \u003cb\u003eMacros\u003c\/b\u003e are stored in the \u003cb\u003eVisual Basic Editor\u003c\/b\u003e and can be edited to troubleshoot problems. The \u003cb\u003eVisual Basic\u003c\/b\u003e programming commands are included in the \u003cb\u003eMacro\u003c\/b\u003e recording, but there are hundreds of other coding commands that can accomplish fantastic results, as well. Code can also be written to open display message boxes to status the end of a routine; \u003cb\u003eInput Boxes\u003c\/b\u003e can allow you to prompt for information needed, and there are \u003cb\u003eWorksheet\u003c\/b\u003e and \u003cb\u003eWorkbook\u003c\/b\u003e commands to create and manipulate information automatically. \u003cb\u003eVisual Basic\u003c\/b\u003e is designed to go beyond the capabilities of \u003cb\u003eExcel\u003c\/b\u003e and can replace a long process, completing a task in minutes.\u003cp\u003e\u003c\/p\u003eThe following are the major topics to be covered: \u003cul\u003e\n\u003cli\u003e\n\u003cb\u003eExcel Macros\u003c\/b\u003e - These can be recorded, stored, and run to automate many tasks.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eVisual Basic Editor\u003c\/b\u003e - Here, we will cover the editing, debugging, and storage locations of VB code.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eCell Manipulation\u003c\/b\u003e - \u003cb\u003eExcel\u003c\/b\u003e is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eFormatting Techniques\u003c\/b\u003e - Although \u003cb\u003eRecording Macros\u003c\/b\u003e would be the best approach to \u003cb\u003eFormat Cells\u003c\/b\u003e, there are many additional \u003cb\u003eVisual Basic\u003c\/b\u003e formatting tools to understand.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eVariables\u003c\/b\u003e - These are great methods to help remember specific items for use at a later time.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003e\u003ci\u003e\"\u003c\/i\u003e\u003c\/b\u003e\u003cb\u003eIf\u003ci\u003e\"\u003c\/i\u003e\u003c\/b\u003e \u003cb\u003eLogic\u003c\/b\u003e - This will be covered to help automate decisions and provide the logic necessary to make adjustments.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eMessage \u003c\/b\u003eand \u003cb\u003eInput Boxes\u003c\/b\u003e - These tools are methods to provide \u003cb\u003eInput Boxes\u003c\/b\u003e in a popup window with results being stored in a cell.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eLoops\u003c\/b\u003e - This will provide the logic to repeat steps in multiple cells.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eWorksheet\u003c\/b\u003e and \u003cb\u003eWorkbook\u003c\/b\u003e - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.\u003c\/li\u003e\n\u003cli\u003e\n\u003cb\u003eFunctions -\u003c\/b\u003e There are many more advanced programming techniques that can create more efficient code.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cb\u003eWhat's in the Workbook?\u003c\/b\u003e Click on the left side of the screen: \u003cb\u003eLook Inside!\u003c\/b\u003e\u003cbr\u003eEnter one of the following keywords: \u003cb\u003eVB, Programming, VBA, Variables, Forms, \u003c\/b\u003eetc.\u003cbr\u003e","brand":"Independently Published","offers":[{"title":"Default Title","offer_id":50915996074258,"sku":"9798491450619","price":12.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_009e65be-4b0a-417e-90b2-7ca636b3a754.jpg?v=1738833267","url":"https:\/\/surprise-castle.myshopify.com\/products\/visual-basic-for-excel-supports-2010-2013-2016-and-365-9798491450619","provider":"Surprise Castle","version":"1.0","type":"link"}