Jon Muller: Excel SQL

Excel | SQL
jon-muller

Excel SQL: Free videos to learn how to do database editing with Excel.

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 to 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.

LEARN SOMETHING NEW

Follow Us on The KuduTek Channel

Learn about Excel and SQL and all kinds of cool stuff!