This course is designed for users of Microsoft Excel wanting to extend their existing skills in using the product. It is aimed at those who have no prior knowledge of Visual Basic for Applications and who want to be able to automate tasks and create custom user-interfaces within Excel.
The course is based upon the subject areas listed below and each chapter includes tutor-led demonstrations followed by hands-on practical exercises for delegates. Please note that the subject areas covered will depend on the ability of the delegates attending and time available.
For those who have a reasonable working knowledge of Excel and who wish to automate tasks and extend the functionality of Excel further.
By actively participating in this course, you will learn about the following:
Using the Developer Tab.
Recording and running macros.
Swapping values in a macro.
Understanding Workbook/Worksheet Objects and their properties.
Understanding how to declare Range, Cell, Row, and Column Objects.
Understanding variables such as Integers, Strings, Double and Boolean.
To ensure your success, we recommend that you have a reasonable working knowledge of Excel or have attended the courses detailed below:
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses. Delegates may notice differences in their software if using a MAC.
Create a Macro
Run Code from a Module
Use Relative References
Add a Macro to the Toolbar
Worksheet and Worksheet Object
Path and FullName
Close and Open
Loop through Books and Sheets
Files in a Directory
Entire Rows and Columns
From Active Cell to Last Entry
Union and Intersect
Test a Selection
Possible Football Matches
Font and Background Colours
Areas Collection and Compare Ranges
Life of Variables