Course
Excel Advanced Macros
Course Duration
1 Day
This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.
We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.
It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.
For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.
Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.
Public Scheduled Dates
We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.
It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.
For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.
Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.
<<
<
>
Public scheduled prices per delegate +VAT
Private courses start from £745 for up to 8 delegates
Prerequisites
-
- This course is designed for someone who has experience of using Excel, they are comfortable creating formulas and using functions such as SUM, IF, AVERAGE, LOOKUP these are just an example of the functions they may use on a regular basis. They are very comfortable using cell references in their formulas. They know how to type the formulas into cells and do not need to use the automated functions. They are keen to push the limits of Excel beyond the user interface. They have tried recording a macro and maybe even had a go at editing it. It would suit people who are unsure whether programming is for them but would like to try the experience without too much commitment.
Objectives
-
- Automate tasks by recording a Macro
- Explain where Macros are stored and how you can organise them
- Create a macro by typing in (or copying and pasting) the instructions and not recording it
- Explain the different methods for starting a macro
- Get a macro to ask a yes/no question of the user and respond to that question, thus allowing the Macro user the option to the run the macro or not.
- Alter the code that is created when you record a Macro, How to step though your code one line at a time to see what the Macro is actually doing, this way you can decide if you wish to keep the action or remove it
- Add comments to your macros so that you can understand them in the months and years to come
- Move around a worksheet using macros
- Select an area of the worksheet and add information to the end of the selection
What's included
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
Course Content
-
Getting Started with MacrosIdentifying a reason for using a Macro
Recording methods
Overview of other methods -
Running MacrosRunning Macros from the Ribbon
Adding Macros to the Quick Access Toolbar
Using Keyboard Shortcuts
Attaching Macros to Objects or Clip Art -
Visual Basic for Applications (VBA)The VBA environment and components
Creating the Personal Macro Workbook
Managing the Personal Workbook -
Recording Macros in StagesJoining code to create more advanced Macros
Using the IF statement in VBA -
Creating Macros Using VBA codeWhen to use Absolute or Relative references
For and Next statements
Using Do While and Do Until statements
Creating interactive Macros
Following this training what are you going to do differently
"Going to implement them into my work now I have a better understanding"
S.R. Yorwaste, Excel Advanced Macros
"Very useful to learn about the various ways that you can use Macros to not only process data but also to assist with input and validation via forms."
S.T. Barratt Developments Plc, Excel Advanced Macros
Following this training what are you going to do differently
"Going to try and utilize macros more often within the business to automate processes."
S.T. Barratt Developments Plc, Excel Advanced Macros
Other Courses In This Series
Microsoft 365 Copilot for Business Users - Introduction This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool that uses artificial intelligence to provide real-time intelligent assistance within Microsoft 365 productivity apps including Word, Excel, PowerPoint, Teams and O
VBA Essentials using Excel This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.
Excel Level 1 - Essentials Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create
Excel Level 2 In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gai
Excel Analysing and Presenting Data with Dashboards and Pivot Tables This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to
Excel Level 3 This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and an
Your Excel course can be delivered online or in-person. You can choose your Excel path with introduction to advanced levels. Master Excel Business Intelligence and Power Tools, VBA and more. Learn in-person or online with our virtual classrooms. Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master Excel, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.BespokeBespokeBespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/20/2024 1:03:20 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/20/2024 1:03:20 AM