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!
4.65 (347 reviews)
7 340
students
5 hours
content
Nov 2021
last update
$74.99
regular price
What you will 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.
Course Gallery
Charts
Students
Price
Rating & Reviews
Enrollment Distribution
Comidoc Review
Our Verdict
Excel VBA & SQL Essentials for Reporting Automation is a solid course that excels at providing hands-on experience automating recurrent tasks, creating databases, and generating custom reports using Excel, VBA, and SQL. Despite minor flaws such as the instructor's accent, which can be challenging, and rapid presentation of examples, the course offers valuable insights for data analytics professionals seeking to enhance their skillset in report automation. However, beginners might struggle without prior knowledge of VBA basics.
What We Liked
- In-depth coverage of Excel VBA, SQL, and Access database automation, ideal for data analytics professionals.
- Practical business cases that apply to corporate employees, enhancing real-world applicability.
- Comprehensive course materials, working files, and output files available for self-paced learning.
- Clearly presented slides and an expert instructor who knows the subject matter.
Potential Drawbacks
- Accents can be challenging to understand for some learners; transcripts would be helpful if they were accurate.
- Examples sometimes move too quickly, making it difficult to grasp or copy the code presented.
- Lacks a thorough introduction to VBA basics, potentially causing confusion among beginners.
- Minor discrepancies in automated captions and transcripts; requires manual proofreading.
3238603
udemy ID
15/06/2020
course created date
14/07/2020
course indexed date
Bot
course submited by