Develop the Excel skills that you need to produce spreadsheet solutions to your business needs - instantly! There are an estimated 400 million Excel users, but the majority of them haven't worked out a way to effectively use Excel VBA (Visual Basic for Applications). This book is for those that use Excel at work and who want to use the advanced features of Excel but don't have the time to have extensive training. It takes you through each task (as all Brilliant books do) and describes everything you could want to find out, for example: - how to use the macro recorder - how to take that recorded code and turn it into something useful that will really help you day to day - how to automate reports and design applications Users will then improve their Excel skills so they can in the end save a lot of time and get more done. Brilliantguides allow you to find the info you need quickly, easily and without fuss. It guides you through all the tasks using a highly visual, step-by-step approach - providing exactly what you need to know when you need it.
Introduction 1 Recording and running macros Record a macro Run a macro Edit a macro Delete a macro Record a macro using relative references Assign a macro to a keyboard shortcut Run a macro by clicking a shape Add a macro to the Quick Access Toolbar Customise a Quick Access Toolbar button Save a macro-enabled workbook Managing Excel 2010 security settings Change Protected View settings Change message bar settings Change data connection security settings Add a digital signature to a workbook 2 Starting with the Visual Basic Editor Introduce object-orientated programming Display the Developer ribbon tab Display the Visual Basic Editor Set project properties Create a code module Create a subroutine Create a function Add a comment to your code Run a VBA routine Rename a code module Delete a code module Export a code module to a text file 3 Working with data and variables Understand data types in Excel VBA Declare a variable Require variable declaration before use Manage variable scope Perform calculations using mathematical operators Define a constant Define a static variable Define an array Define a multidimensional array Redefine an array Define a dynamic array Display an object type Define an object variable 4 Managing workbooks and files Open a workbook Open a text file as a workbook Open a file the user selects Save a workbook Save a workbook in a different format Detect if a workbook is open Close a workbook Create a new workbook Delete a file 5 Managing worksheets Add a worksheet Delete a worksheet Move a worksheet Copy a worksheet Hide or unhide a worksheet Rename a worksheet Protect a worksheet Print a worksheet 6 Managing ranges Activate a cell range Select a cell range Select the active region Refer to cells using Offset Insert a cell range Delete a cell range Hide worksheet columns or rows Create a named range Resize a selectedrange Set the column width Set the row height 7 Managing cells Cut and paste a cell range Copy and paste a cell range Copy and paste values in cells usi
Accessing your eBook through Kortext
Once purchased, you can view your eBook through the Kortext app, available to download for Windows, Android and iOS devices. Once you have downloaded the app, your eBook will be available on your Kortext digital bookshelf and can even be downloaded to view offline anytime, anywhere, helping you learn without limits.
In addition, you'll have access to Kortext's smart study tools including highlighting, notetaking, copy and paste, and easy reference export.
To download the Kortext app, head to your device's app store or visit https://app.kortext.com to sign up and read through your browser.
NB: eBook is only available for a single-user licence (i.e. not for multiple / networked users).
