We have a challenge in our VBA class. Many of the students who join our VBA program have no formal programming background. They may have written a few simple programs long time ago, but most of them lack basic understanding of programming. Teaching VBA can be difficult if we do not address this problem.
So, we have added a lesson on “Introduction to Programming”. In this lesson, our aim is to introduce programming to non-programers.
Since many of you are considering to join our VBA classes, it is appropriate that we give this introduction to programming lesson as a demo lesson. Please watch it below.
Introduction to Programming lesson
What is in this lesson?
In this lesson, we will learn,
- What do the terms program and programming mean?
- Hello World Programs in VBA
- Programming Concepts – Variables
- Operators
- Conditions
- Loops
- Exception Handling
- Modularization
- Commenting
- Graphical Elements
Watch the lesson [55 Min, Part 1]:
Download the Presentation & Workbook
Click here to download the presentation slides [pdf]
Click here to download the workbook with HelloWorld example macros (you need to view code on the workbook).
To Watch the second part of this video + more on VBA:
There is more to this lesson. In Part 2 (30 more mins), we discuss various programming jargon & share tips on how to start programming.
You can get the part 2 and more lessons on VBA by joining our VBA classes.
Click here to learn more about VBA Classes & Enroll.
Please note that registrations will be closing next Friday – 20th May.
How would you introduce programming to a layman:
Please tell me how you would introduce programming to a layman, using comments. I would like to learn from your perspective.
PS: Go ahead and join our VBA Class if you want to become awesome in VBA.
PPS: Check out introduction to Excel too.
7 Responses to “Extract data from PDF to Excel – Step by Step Tutorial”
Dear Chandoo,
Thank you very much for this and it is very helpful.
However, all the Credit Card Statements are now password protected.
Please advise how can we have a workaround for that
Hello sir,
How to check two names are present in the same column ?
Thanks and Regards
Hi, Thank you for the great tip. One problem, when I click on get data >> from file, I don't see the PDF source option. How can I add it?
I tried to add it from Quick Access toolbar >>> Data Tab, but again the PDF option is not listed there.
I am using Office 365
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. Your video would work except that I can't get the composite table and each of the tables I do get or the pages does not have all the info. what to do?
Dear Chandoo,
How do we select multiple amount of tables/pages in one PDF and repeat the same for rest of the PDF;s in the same folder and then extract that data only on power query.
Thank you
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. nice share
One bank statement takes up 20 tables and four pages in this document. I need to consolidate roughly thirty different bank statements that I have. Your video would be useful if I could only get the composite table, which I can't for some reason, and each of the tables or pages that I can get is missing some information.