Excel VBA Essentials for Reporting Automation
5.0 /5- Offered byUDEMY
Excel VBA Essentials for Reporting Automation at UDEMY Overview
Duration | 5 hours |
Total fee | ₹455 |
Mode of learning | Online |
Credential | Certificate |
Excel VBA Essentials for Reporting Automation at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Learn from 2 articles and 19 downloadable resources
Excel VBA Essentials for Reporting Automation at UDEMY Course details
- For anyone willing to expand their knowledge of Excel VBA and anyone willing to learn how to build automated processes from scratch
- 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
- Start creating your Excel Dashboard and Data Analytics reports today with VBA macros
- The objective of this course is thus to show that it is possible for everyone to automate many different data processes from start to finish
- The key to doing this is using the right tools, so students will find that Excel is great, but it is even more powerful when used with other applications
- Among other things, students will work with Microsoft Access, which is the Office database tool
- Students will see how more efficient it is to use access compared to Excel for certain tasks, but also how these two applications can be used together to build an even more efficient process
Excel VBA Essentials for Reporting Automation at UDEMY Curriculum
Introduction to VBA
What is VBA?
Visual Basic Editor
(Excel Practice) Setting up Excel and the Editor
(Excel Practice) Worksheet Control with VBA
Loops
(Excel Practice) Loops with VBA
Conditions
(Excel Practice) VBA Code Debugger
End of Section Test
What's Next?
Subs, Variables & Functions
(Excel Practice) Single Workbook
(Excel Practice) Multiple Workbooks
Introduction (1/6)
(Excel Practice) Multiple Workbooks
Folder and Files (3/6)
(Excel Practice) Multiple Workbooks
Keep Track (4/6)
(Excel Practice) Multiple Workbooks
Data Transfer (5/6)
(Excel Practice) Multiple Workbooks
Code Optimization (6/6)
Code Refactoring
End of Section Test
What's Next?
Data Structure
MS Excel vs. MS Access
Data Workflow
(Access Practice) Tables Creation
Introduction to SQL
SQL - SELECT
SQL - JOIN
SQL - Others
(Access Practice) SQL SELECT
(Access Practice) SQL Others
End of Section Test
What's Next?
Database Download
(Excel Practice) Database Download with VBA and SQL
Database Upload
(Excel Practice) Database Upload with VBA and SQL
End of Section Test
What's Next?
Input Upload to Database
(Excel Practice) Input Process Introduction
(Excel Practice) Sales Process
Introduction (1/3)
(Excel Practice) Sales Process
Move Files (2/3)
(Excel Practice) Sales Process
Refining and Testing (3/3)
(Excel Practice) Performance Process
(Excel Practice) Report 1
Introduction (1/7)
(Excel Practice) Report 1
Notepad++ (2/7)
(Excel Practice) Report 1
SQL Queries (3/7)
(Excel Practice) Report 1
VBA Code (4/7)
(Excel Practice) Report 1
File Save As (5/7)
(Excel Practice) Report 1
Send Email with Outlook (6/7)
(Excel Practice) Report 1
Refining and Testing (7/7)
(Excel Practice) Report 2
Introduction (1/5)
(Excel Practice) Report 2
SQL Queries (2/5)
(Excel Practice) Report 2
VBA Code (3/5)
(Excel Practice) Report 2
Refining and Testing (5/5)
(Excel Practice) Report 3
End of Section Test
Excel VBA Essentials for Reporting Automation at UDEMY Faculty details
Excel VBA Essentials for Reporting Automation at UDEMY Entry Requirements
- Prerequisites : Some general experience with Excel and VBA is considered a plus by students
- Not mentioned
Other courses offered by UDEMY
Excel VBA Essentials for Reporting Automation at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?