Excel VBA & SQL Essentials for Reporting Automation

Use Excel & Access with Excel VBA macros & SQL to automate any Excel report, and become a master at Data Analytics!

Created by: Benjamin Termonia
Blockchain & Cryptos Passionate, Data Geek

What Will I Learn?

• Learn how to automate recurrent tasks with Excel VBA
• Learn how to create and structure a Microsoft Access database, and how to interact with it by using SQL
• Learn how to automate data transfer between Excel and Access by using VBA and SQL
• Learn how to automate recurring custom reports by using Excel, Access, VBA and SQL
• Learn how to use Outlook together with VBA to automatically distribute your reports.

Requirements

• A Windows-based computer. While most of the code should work in Office for Mac, the compatibility is not guaranteed.
• Microsoft Office installed on the computer. Any version among 2010, 2013, 2016, 2019 or Microsoft 365 will work. The course has been created with Office 2019.
• Some general experience with Excel and VBA is considered a plus by students.

Target audience

• Anyone willing to expand their knowledge of Excel VBA
• Anyone willing to learn how to build automated processes from scratch
• Anyone willing to expand their data analyst skillset and make a further step in their career
• Anyone tired of creating the same report and doing the same repetitive tasks, over and over again