Excel SQL: Free videos to learn how to do database editing with Excel. Data Intelligence through Microsoft Excel - free advice, resources, tips and tricks.
Hi, my name is Jon Muller, founder of the company KuduTek.
I am excited and committed to sharing with you what I know about Excel and data. I will be teaching you all the bits of knowledge-gems that I have accumulated through my 20 years of consulting work. My goal will be to follow a weekly release schedule.
We will focus on using Excel as a practical solution and striking a balance between using SQL and Excel together. I will show you how to use real-time data connectivity with SQL for the heavy-lifting data crunching work and Excel as the presentation platform and for higher level light-weight data validation and processing.
Most Excel gurus focus on read-only data pulling. However, I will teach you practical ways to not only pull data but also update and add data into the database. We will be using the same disciplined approach and methodologies that software engineers use. Using Excel for bulk database data editing offers many advantages. Here is an example of an Excel workbook that I developed that enables the user to do Excel SQL bulk update work.
Subscribe to my mailing list today and you will receive actionable and practical Excel how-to information and receive email notifications whenever I publish a new video on my youtube channel.
Check Out My Latest Posts
As a subscriber, you never miss a post AND you get access to my exclusive free guides and weekly content and other free resources that I will be sharing in coming days. Sign up today and you will be a happy subscriber!