Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Drop Servicing

DevelopmentDatabase Design & DevelopmentExcel

Advanced Excel: New Data Entry Forms - start without VBA

Excel with this A-Z Guided Excel Course. Easy way to create Excel User Forms with MySQL database. Start without VBA.
Rating: 3.3 out of 53.3 (100 ratings)
5,319 students
Created by Davor Geci
Last updated 11/2021
English
English [Auto]

What you'll learn

  • Create Modern and Impressive Excel User Forms Without a Single Line of VBA Code.
  • Become one of the Top Excel users in your team and Leave Your Boss Speechless.
  • You Will Get the Virtual Forms for Excel for FREE from the creator of the tool himself as a gift for buying the course.
  • Make your work-life easier with Excel VBA advanced techniques, tips and tricks to Skyrocket your Productivity in Excel.
  • Transform your Excel Database to a Relational Excel Database.
  • Learn how to easily create MySQL databases using Free MySQL Workbench, cutting out the useless fluff and filler.
  • Create Professional Excel Lookup Forms and Master-Detail Forms Without Coding.
  • Impress with Professional & Paginated Pixel-perfect Reports created with Microsoft Report Builder right from Excel.
  • Get Access to a Professional Trainer with 20+ years of experience in programming and database development.

Requirements

  • No Prior Excel or Database Knowledge Required.
  • Microsoft Excel 2007, 2010, 2013, 2016, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along is Recommended.
  • As I'm the creator of Virtual Forms for Excel tool, you don't need to buy it, you will get it for FREE as a gift for buying the course.
  • All the other tools used in the course are free, and we will together install them when needed.

Description

______________________________________________________________________________________________

November 2021 announcement:

Starting in November 2021, I started recording all the videos from scratch and replacing section by section with new videos and materials.

New videos and materials are based on the new version 3 of Virtual Forms for Excel which along with the new modern design also simplifies certain processes and adds new and advanced functionalities.

Take this course and you will receive educational emails when I post new videos and materials and when I replace existing ones.

Within the course resources, you can download for free a fully functional version 3 of Virtual Forms for Excel which is not limited in any of the features. Since I am the creator of the Virtual Forms for Excel tool, this is my gift to you when you buy this course.

______________________________________________________________________________________________


6 Courses in 1

Covering 6 major Excel & Databases topics - this course is "incredible value for money!" as one student said.

We'll cover:

  1. Excel Advanced Tips, Tricks & Techniques.

  2. Excel VBA Advanced Techniques.

  3. How to create MySQL databases Step by Step.

  4. Create New Modern Excel Data Entry Forms with Virtual Forms.

  5. How to create Master-Detail (Parent-child) & Lookup Forms in Excel without Coding (using Virtual Forms).

  6. How to convert Virtual Forms from Excel VBA to Visual Studio .NET to remove the dependency on Excel.


Microsoft Excel & Microsoft Power BI are the most popular and used tools for analyzing and visualizing data.

BUT, Microsoft Excel is not created for gathering data, especially in gathering relational data like master-detail structures.

One basic, simple Excel example. You want to gather (or track) Orders in Excel and then for these Orders you want to track Order Details and, for example, Order Payments and all that using Excel as the Excel database.

Not to mention, to do this in a multi-user environment also in Excel.


Boy,….., You will have a tough time doing this with Excel, because Excel is simply not created for challenges like this, to gather master-detail data and also in a multi-user environment within the normal Excel environment.

But in this course, You will learn how you can do this by using Excel VBA as a front end and MySQL database as a backend, whether the MySQL database is on your local machine, your local network, or on the webserver. We will do this with help of a small tool called Virtual Forms.


Hello,

I’m Davor Geci the CEO and the Lead Developer of WinPIS, the company that’s behind a popular tool that brings to Excel what Access developers are having for decades.

It is the ability to create CRUD Excel VBA Forms, forms to create, read, update and delete records that are stored in databases like MySQL, MSSQL, Access (On-premise or on the web), and use the data within Excel VBA and all that in minutes.

It is similar to what Access can do, but you could also port these Virtual forms from Excel VBA to Visual Studio (C# or VB NET)


You can not do this with Access VBA or natively with Excel VBA!


So, you just need to create a database and tell the Designer which fields you want on your form.

Once created, Virtual Forms can be also used as LookUp forms in Excel VBA with no extra work, just as you would do VLOOKUP and HLOOKUP in Excel functions & formulas.


All the controls, that are generated on these Virtual forms, can be accessed with Excel VBA (or if you use Visual Studio with  C# or VB NET).

Virtual form control also fires events, so it allows us to interact with it, in a similar way normal UserForms in Excel VBA do. But in a more data-centric way.


Before you dive in, it’s probably a good idea to just check out the structure of the course.

In this course, You will learn how to quickly create database applications using Microsoft Excel VBA and a MySQL database that is hosted somewhere on the internet or in your building (so-called on-premise) and all that with help of the Excel VBA & a small tool called Virtual Forms.


In the first part of this course, You will learn how to create your first database app (Excel VBA forms) that will use Excel VBA as the front end, and a MySQL database as the back end. You will also learn how to install a MySQL server on your machine or anywhere in your network and use it as a data source. Also, in the first part of the course, you will learn how to install and use MySQL Workbench that help us to create and maintain MySQL databases.


Don’t worry, I will go slow!


And then, you will also learn how to transform your Excel VBA database applications with MySQL database as the data source, to C# or VB NET with almost no change to the Excel VBA code.


If you ever get stuck with something in the course, (like Excel VBA code or MySQL databases) just post a message in the Q&A of this course and I will respond as soon as I can to help you out.


I do everything I can to make this a 5-star course and I hope you like it too and leave a review.

Feel free to take a look at preview lectures and the course description before making a decision to buy.

And yes, this course is covered with Udemy 30-day money-back guarantee.

You don’t have anything to lose.


So, enroll now, learn new things in Excel VBA and MySQL, have fun with me and create your Microsoft Excel VBA apps in minutes. 


Join me inside NOW!

Davor

Who this course is for:

  • Want to Master Excel & Quickly learn to build stunning Desktop Database Applications in Excel VBA & MySQL database in minutes.
  • Business Professionals & data analyst who'd like to learn to simplify & automate workflow using Excel & VBA.
  • You currently use Excel and want to learn how to improve your skills from Beginner to Advanced in Excel VBA programming.
  • Want to learn Excel VBA advanced techniques - How to Master Microsoft Excel from Beginner to Advanced and collect data for later data analysis​ and data visualization.
  • Want to become an Excel Expert on All Levels (from Excel Basic to Excel Intermediate and Excel Expert level).
  • This has not been tested on Mac Excel.

Instructor

Davor Geci
CEO @ WinPIS, Programmer | Excel VBA Access VB SQL Databases
Davor Geci
  • 3.5 Instructor Rating
  • 102 Reviews
  • 12,536 Students
  • 2 Courses

Davor is a veteran programmer with 20 years of being a professional programmer and 15 years of building companies as CEO or helping others as an HR consultant in employee recruitment.

Specialties: VB, VBA, Error Handling, Google Analytics, Azure Application Insights, SQL, Databases, Excel, Access, MySQL, MSSQL.

Currently: CEO & Founder at WinPIS

Recent projects:

Virtual Forms for Microsoft Excel VBA (NEW UserForms for Excel VBA)

VBA Telemetry (connect VBA & Google Analytics or (and) Microsoft Azure Application Insights)

Recent projects in detail:

Virtual Forms for MS Excel VBA:

“Simple but powerful Userform control for Excel VBA so that anyone can use it, even without a single line of Excel VBA code!   “Create a few sheets in Excel Workbook, or create few tables in the database like MySQL. Tell the Virtual Form Designer which fields you want that UserControl will use. And you’re done.”

#####################################

VBA Telemetry:
Log & Track Events, Metrics & Errors from VBA (Excel, Access, Word, Powerpoint, ...) projects in real-time using Google Analytics or (and) Microsoft Azure Application Insights.

------------------------------------------------
VBA TELEMETRY:
Allows us to log and track events, metrics, and errors from VBA in real-time.
Track usage of your VBA (Excel workbooks, Access projects) from around the world.

Example: You have created a killing Microsoft Excel Workbook or Access project. Then you distribute this Excel Workbook or Access project to your users or customers. 

But how do you know if there are any errors, what parts of your VBA project is used the most, which function, routine or part of the code is executed faster or slower on your users or customer's computers, or is it used at all?

Now you can, with help from VBA Telemetry and Google Analytics or (and) Microsoft Azure Application Insights.

------------------------------------------------
IN A NUTSHELL:
Add online Error Tracking, Usage Tracking of your Excel Workbooks, Access projects, or any VBA project, from around the world.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.