Excel is the powerful, figure-based spreadsheet component of Microsoft Office used by many businesses for its calculating and data manipulation capacity. Your business might use many of Excel’s built-in features and functions, but are you making the most of Excel’s capacity to analyse data quickly; customise calculations; and obtain information from, and supply output to, a general user without their needing to have direct access to the spreadsheet grid and any underlying calculations? All of this can be achieved with Excel’s programming language Visual Basic.
Are your spreadsheets inefficient or poorly designed? Do they require considerable maintenance to update? Are they difficult to understand? Do you need to manipulate list data? If any answer is ‘Yes’ then this course could help you!
In addition to an extensive range of built-in functions, used for sophisticated calculations and data manipulation, Excel contains part of the Visual Basic programming language Visual Basic for Applications (VBA) as an aid to creating stored, reusable instructions called macros. Visual Basic macros allow you to automate repetitive and complex tasks, analyse data quickly, and customise calculations. Macros and VBA work with and beyond the built-in functions to enhance Excel’s functionality, especially when combined with user-friendly interface forms for data input and output.
Although manipulating figures is Excel’s primary purpose, its row-and-column format lends itself to creating and storing lists of data. Frequent Excel users are usually comfortable with this format and easily enter list data directly into spreadsheet cells. This can, however, be cumbersome, error-prone, and unsuitable for less experienced users. One solution is to create customised user forms with objects - such as command buttons, lists, and check boxes – which use Visual Basic programming code to manage users’ requests for data gathering and manipulation.
Enhance your business use of Microsoft Excel by learning to program in Visual Basic, the structures and commands of which are common to many programming languages. This course introduces and develops Excel macros, Visual Basic programming, and the creation and use of user forms. Specific references are made to Excel’s spreadsheet and cell objects and their properties.
This course is one of a series of three weekly Excel courses which introduce and develop a variety of skills in designing and creating spreadsheets. These range from discovering essential built-in functions and features to developing Excel User Forms with Visual Basic and Object-Oriented Programming (OOP). The first of these courses is “Calculating With Excel and Introducing Visual Basic” which will be held “in-person” at Rewley House and starts in September 2022. The third course is online and forms part of our WOW series; this is “Introduction to Object Oriented Programming using Excel and Visual Basic” which starts in January 2023.