Udemy

The 3-in-1 Excel, VBA & SQL Master Course

Enroll Now
  • 3,717 Students
  • Updated 8/2024
4.6
(686 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Language
English
Taught by
Mark Lengyel
Rating
4.6
(686 Ratings)

Course Overview

The 3-in-1 Excel, VBA & SQL Master Course

Learn valuable Excel, VBA, SQL and Programming Skills! Go from beginner to expert and get a Competitive job!

Hello!

Thank you for visiting our course page.

Do you want to become the go-to person at your company for Microsoft Excel problems? Do you want to nail your next job interview? Or just want a new skill? If yes, then this course is for you.

Watch the FREE video lectures to see how the course is structured and delivered!

Join the course risk-free thanks to the 30-day no questions asked money-back guarantee! If you decide it's not for you, just ask for a refund.

I'm Mark and I will be your instructor. I have worked at companies like IBM, Morgan Stanley, and Siemens, so believe me, I know what skills these companies need! I'm a self-taught software developer, who will teach you how to use Excel like a pro, but we will not stop there! I'll also teach you how to write clean and professional VBA code to automate Excel tasks! And on top of that, you'll also learn the SQL programming language, so by the end of the course, you'll know how to work with an actual database!

This course is made up of 3 different courses, and packed with over 40 hours of video lectures.

*** UPDATE! Google Sheets course is being added to this course! ***


1. EXCEL

The first part is dealing with Excel itself. It takes you from the VERY BASICS to EXPERT level. If you already have some Excel knowledge, you can skip the introductory parts!

By the end of this part you will use Excel confidently, and be able to handle advanced tasks. You will learn the ins and outs of functions, formulas, charts, pivot tables, conditional formatting and a lot more.

At the end of this part we will have a live project also.


2. VBA

The VBA sections of this course will enhance your Microsoft Excel knowledge even further and will introduce you to programming. VBA stands for Visual Basic for Applications. Excel VBA is Microsoft's programming language for Excel. It is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.

In the VBA sections of this course you will learn for example

  • Subroutines, variables, data types

  • Core VBA programming concepts

  • VBA functions and more challenging concepts

  • Macros, recordings and enhancing them

  • Debugging and error handling

  • Essential VBA operations

  • Events

  • Managing your VBA code

  • Classes and Object-based programming


3. SQL

In this part of the course you will learn how to work with a database and execute SQL statements within Excel.

In the SQL part of the course you will:

  • learn SQL and how to set up your database

  • learn about data types

  • learn basic operations

  • learn how to set up VBA for SQL

  • learn how to query data

  • learn about basic statements

  • learn how to work with a table

  • learn about joins

  • learn about SQL functions and security


So what are you waiting for? Enroll now and become an EXCEL expert!


4. Google Sheets

The Google Sheets sections start from the very beginning, assuming that the learner is an absolute beginner. If you have some knowledge of Google Sheets, you can skip the introductory parts.

Course Content

  • 10 section(s)
  • 543 lecture(s)
  • Section 1 Introduction
  • Section 2 EXCEL: Introduction to Excel
  • Section 3 EXCEL: Basics of formulas, functions and formatting
  • Section 4 EXCEL: Some important math functions
  • Section 5 EXCEL: Data types and formatting
  • Section 6 EXCEL: More challenging formulas
  • Section 7 EXCEL: Handling Errors
  • Section 8 EXCEL: Sanitizing your data
  • Section 9 EXCEL: Conditional Functions and Formatting
  • Section 10 EXCEL: Cells and References

What You’ll Learn

  • Learn Microsoft Excel from Beginner to Advanced
  • VBA programming
  • Learn a large number of Excel functions
  • Master advanced Excel functions
  • Work with charts and pivot tables
  • Learn how to execute SQL statements in Excel
  • Task-based learning
  • Help from me with real life experience who works with Excel every day


Reviews

  • A
    Ashish Verma
    3.5

    Hi Sir Thank you for conducting the training sessions. The Excel session was very good, and I learned many useful points. The VBA session covered basic information, which was helpful. The Google Sheets session was wonderful and very informative. The Power BI session also covered basic information, and I gained good understanding. I have one request — please provide PDF notes for every session, so that it becomes easier for us to revise and learn after class. Thank you again for your guidance and support.

  • R
    Rakshit Prem
    5.0

    yess

  • L
    Luisa Maria Martinez MacHado
    5.0

    Si perfecto hasta ahora, solo me hubiera encantado una versión en español

  • V
    Vincent Loignon-Duchesne
    5.0

    Easy to follow or to retrace on what point we left. Many learns I'd get here. thanks!

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed