This webinar will give you the building blocks for learning code, as well as Spreadsheet automation to increase productivity.
You will create a variety of macros learning how to best automate repetitive tasks, create customised forms and programme solutions in Excel.
Learn how to harness the power of Excel through macros and coding and how it can open up a world of possibilities in transforming the way you do work.
Spreadsheet automation is an essential skill for Excel users who want to take their day to day use of Excel to the next level.
Demonstration of how to relate the code to an Excel worksheet, ranges and cells.
We will learn how to:
• Generate emails from Excel.
• Attach pdfs to an email.
• Generate a variety of loops to perform these tasks numerous times that we can control.
There are no pre requisites for this course apart from being a competent user of Excel. The code we generate will come from macro recordings and forums we find on the internet. We will take this code, ensure we understand what the code does the add our own enhancements to complete set tasks. This is exactly the way 95% of programmers operate!
For over 20 years, Jason Leiper has provided leadership while training in qualified systems, business and information management training in government, while also training in universities and private circles.
You will be provided with:
• PowerPoint presentation slide deck
• Supporting documentation
• Webinar Recording to view multiple times for up to 6 months
• An opportunity to ask questions to the presenter
Introductory overview of Macros and VBA (Visual Basic for Applications).