Automate Excel with VBA The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently. Why Microsoft VBA? VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge you’ll be able to automate tasks in Excel and turbocharge your data handling capabilities. We’ll take you from beginner to advanced user in only 9 hours on this online video training course. On this 4-hour course you will: Learn how to automate tasks and operations that you perform frequently. Discover how to define and manage variables, set up subroutines, and create functions. Find out how to use input boxes and message boxes to interact with end users. Learn practical methods for using macro errors to improve your VBA code. Learn about the PivotTable object and basic approaches to utilizing it. Discover what variables are, and how they relate to functions versus methods and subroutines. Create cross-functional flowcharts. We’re confident you’ll love your new courses, but if you are not 100% happy you have 30 days to exchange or refund

VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first.  

Microsoft Access is a powerful program that allows you to build a robust “data landing page”. You can transform how you manage data with the incredible range of functions. Create custom web apps and track assets, organise contacts, manage inventory, and much more.  

Become a VBA virtuoso You’ve completed the beginner course in VBA, or have some experience. Now challenge yourself with the next step. Advanced VBA is a learner-friendly course that takes you through more powerful features, expanding the possibilities of what you can make VBA do for you. Why Microsoft VBA? VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge you’ll be able to automate tasks in Excel and turbocharge your data handling capabilities. On this 5 hour course you will cover: Advanced methods for automating tedious Excel jobs. How to write and implement Excel events. Discover how to modify a variety of standard behaviors, such as double clicking, opening files and saving files. Learn how to design and implement specialized classes of objects. Discover how to customize the right click menu within cell ranges. Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options. How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code. We’re confident you’ll love your new courses, but if you are not 100% happy you have 30 days to exchange or refund

Take control of your database with Microsoft Access Dive deeper into Microsoft access with our Advanced Microsoft Access course. With our advanced course you’ll learn how to automate tasks to save you time, how to apply advanced techniques such as macros and VBAs and overall Access best practice. Why Microsoft Access? Microsoft Access is a powerful program that allows you to build a robust “data landing page”. From creating custom web apps and tracking assets to organizing contacts and managing inventory plus much more, the incredible range of functions will transform how you manage data. Best of all, it is easily accessible to anyone with just a basic knowledge of spreadsheets. We’ll make you an to advanced user on this video training course. Add Microsoft Access to your skillset to become more effective at work, stand out and get ahead. Here’s what you’ll learn on your journey to become a Microsoft Access master: Discover how to effectively link to other data sources. Learn how to split a database by splitting the frontend and backend. Follow along as you learn to create and maintain macros. Explore the use of Visual Basic for Applications (VBA). Discover advanced options for the use of forms. Dive into options for packaging your application for distribution. Test your knowledge with an online quiz and Certificate of Completion. Supported Microsoft Access Versions – 2013 & 2016. If you are not 100% happy with your EwB course, you have 30 days to exchange or refund

Not ready for Advanced Excel? Have a look at our Standard Excel Course. Looking To Finally Be An Advanced Excel User? Do you have an intermediate understanding of Excel but are keen to break through to true mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user? Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more. Why Excel Matters: We all know Excel is essential for any business. When applied effectively it is a powerful tool, allowing you to manipulate huge amounts of data, automate tasks and present complex information however you see fit. We also know how difficult it is to find quality instruction that is: Easy to follow Gets you the results you want Teaches you advanced methods that you can quickly put into practise That’s why we developed our online Advanced Excel course. It’s split into 5 clear sections to get the results you want right away. Your teacher is Simon Hurst, an Excel expert and trainer for 20+ years, whose experienced instruction will transform your Excel skills in under a week with none of the usual frustration. Customised Learning: Included with the course is a powerful tool to help you reduce the time needed to upskill. We call it The Filter. The Filter is a machine learning algorithm designed to get you the answers you need as quickly as possible.That means you can and get started on the same day. By taking your answers to a few questions, the Filter creates a program tailored to your existing knowledge and learning goals. That means you can get started immediately, retain more knowledge, and pick the fastest path to the results you need, saving time wasted on going over things you already know. Inside you will learn easy-to-follow, step-by-step methods to: Use advanced graphs in minutes instead of wasting hours trying to figure them out Increase interactivity by automating your spreadsheets with macros and VBA Solve complex problems with superpower functions Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots. And more! Are you ready to advance your Excel skills with a course so good it is backed by a 30-day money back guarantee? Get the Advanced Excel Course Today. Available in Versions: 2007,2010,2013 and 2016/365 PC If you are not 100% happy with your EwB course, you have 30 days to exchange or refund

Learn to use VBA to enhance Excel's functionality to increase efficiency and productivity

Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.

Simple, easy step by step approach to creating your own applications using UserForms in Excel

Power up your workbooks with Visual Basic for Applications automation