TRENDING REPORTING COURSES
Power BI | MS-SQL | Power Apps | Power Automate
Power BI | MS-SQL | ETL with SSIS | VBA | SSAS
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Formulas | Pivots | Advance Dashboards
TAILORED BI REPORTING COURSES
BY INDUSTRY
Course on Business Reporting & Process Automation
Course on Business Process Automation
20-hours Course | 90-Scenarios | Live VBA Project | View Schedule
This is a 20-hour program designed for Advanced Excel users, focusing on automating routine Excel reports or processes using VBA Programming and Excel macros. The course includes 90+ small-scale scenarios, 7 case studies, and a Live VBA project (post-training) to provide hands-on experience in real-time automation.
Write VBA code - that works, to automate and streamline your Excel workflows.
It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Is VBA a valuable skill?This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
15 best practices for VBA codingMany people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Key benefits of MS Office AutomationThis section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros and Cons of Web ScrapingWe live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
When are APIs useful?It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Yes – If you are a “BUSINESS USER” (non-programmer).
From a reporting perspective, Excel is hundred times more powerful when you learn VBA.
This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
Many people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Leverage Excel to capture, import, consolidate, lookup, calculate, analyze, summarize, and visualize data. Then update a variety of documents, including:
This section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros
Cons
We live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
APIs are useful when fetching continuously varying data like stock price or currency exchange rate. Getting data from APIs is much faster than screen-scraping. Screen-scraping is also affected by UI changes. APIs with response in XML or JSON format can be called using the xmlhttp feature.
Tips for using APIs
VBA Learning Redefined.
LEARN from Microsoft Certified Trainers
EXPLORE 90+ Small Scale VBA Scenarios
PRACTICE with 7 VBA Case Studies
HANDS-ON experience with a Live VBA Project
ON-JOB Support to implement learnings
A snapshot of what you'll be learning in 2 weeks.
Computer
Software
Webcam
A working webcam is required to participate in online sessions. Please ensure it is functional and positioned properly for clear visibility.
Secondary Monitor (optional, but recommended)
Having a secondary monitor, will greatly assist in following the pace of the trainer. It allows you to view instructions, and your own Excel workspace simultaneously, enhancing your learning experience.
Course Fee
$ 49920 hours of Instructor-led training
90+ VBA Scenarios
7 large VBA automation (case studies)
30-Days post-training support (via Email)
Report Automation Specialist Certification
At Excelgoodies, we believe in practical and results-driven training. We understand that just learning in the classroom may not be enough, so we offer our trainees an amazing opportunity to work on a live VBA project from their own company post-training. This way, you can put your newly learned skills into practice and become more confident in your abilities.
And when you successfully save at least 2 hours of work per week with your newfound expertise, you'll earn the highly-coveted "Report Automation Specialist" Certificate. This recognizes your exceptional skills in automation and shows that you've truly mastered the craft.
Report Automation Specialist using Excel VBA Programming Eligibility: On implementing a successful live VBA project View Sample Certificate |
Business Associate
Tel: +1 650 491 3131
Email: support@excelgoodies.com
Connect us on30,000+
Students Trained
18+
Year of Experience
4.9
Reviews
Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.
He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.
With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.
Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.
Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.
With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.
A snapshot of what you'll be learning in 2 weeks.
20 hours of Instructor-led training
90+ VB Scenarios
7 large VBA automation (case studies)
30-Days post-training support (via Email)
Report Automation Specialist Certification
Computer
Software
Webcam
A working webcam is required to participate in online sessions. Please ensure it is functional and positioned properly for clear visibility.
Secondary Monitor (optional, but recommended)
Having a secondary monitor, will greatly assist in following the pace of the trainer. It allows you to view instructions, and your own Excel workspace simultaneously, enhancing your learning experience.
Eligibility: On implementing a successful live VBA project
Sample Certificate: View here
Training Schedule
Session | Date | Time (ET) |
---|
Course Fee
$499We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.
You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.
30,000+
Students Trained
18+
Year of Experience
4.9
Reviews
Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.
He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.
With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.
Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.
Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.
With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.
Total Reviews
4583
Overall growth till now
Average Rating
4.9
Average rating this year
Graph
5
2.0K
4
1.0K
3
500
2
200
1
0
Star Rating
Trainer's Expertise
Course Structure
Course Content
Assignments
Certification Process
Scott A. Reifsynder
Power BI Training
Chief Financial Officer
Nexterus
United States
This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.
Wendy Flowers
Power BI Training
Financial and Business Analyst
First Light
United States
This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!
Tim Palacios
Power BI Training
WFM Data Developer
World Connection
United States
This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.
Total Reviews
4583
Overall growth till now
Average Rating
4.9
Average rating this year
Scott A. Reifsynder
Power BI Training
Chief Financial Officer
Nexterus
United States
This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.
Wendy Flowers
Power BI Training
Financial and Business Analyst
First Light
United States
This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!
Tim Palacios
Power BI Training
WFM Data Developer
World Connection
United States
This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.
Industry Insights
VBA
VBA for Project Management: Automating Task Tracking
VBA
5 things you can do to Optimize your VBA Macro
VBA
VBA for Web Development: Creating Dynamic Web Pages
VBA
VBA for Project Management: Automating Task Tracking
VBA
5 things you can do to Optimize your VBA Macro
VBA
VBA for Web Development: Creating Dynamic Web Pages
Contact Us
Excelgoodies Consulting, inc.
575 7th Avenue, 5th Floor
New York City, NY 10018
Tel: +1 650 491 3131
You will learn to use the right and hybrid technology for end-to-end advanced power reporting.
Tools: Power BI, Power Pivot, VBA, Excel,
M-Programming, MS-SQL, SSIS, and many more.
Power BI
Micorsoft T-SQL
MS-SQL Integrated Services
Python
Microsoft Excel VBA
MS-Excel
Power Query