This Excel, VBA and SQL course contains over 390 video lectures and years of real-life experience I gained working for companies such as IBM, Morgan Stanley, and Siemens.
My name is Mark and I will be your instructor throughout this course. The course is divided into 3 parts.
First we will learn about Excel. Functions, formulas, data organization, formatting, charts, pivot tables and more!
In the second part of the course you will learn about VBA. You'll not only learn the VBA programming language, but the basics of programming as well! We'll learn about subroutines, functions, variables, macros, objects and more!
In the third part of the course we'll learn the SQL programming language so that we can get data from an actual database and execute SQL queries from your Excel worksheet! You'll learn about creating tables, inserting records, updating records, using aggregate functions, and of course, writing complex queries!
By the end of this course you will be the go-to person at your company for Excel problems!
Check out the free lessons and start learning now!