A short course on Excel programming. A precursor to Hiran’s Global Enterprise Excel course for Beginners.
This is all the VBA you need to know to take this course. Any new tricks will be introduced at the right time.
Contents
A little bit of VBA – 010 – Developer Tab (2:21)
A little bit of VBA – 020 – Enter Data in a Cell (8:02)
A little bit of VBA – 030 – Looping (12:40)
A little bit of VBA – 040 – If (12:15)
A little bit of VBA – 050 – Dropdowns (15:43)
A little bit of VBA – 060 – Format Header Row (5:39)
A little bit of VBA – 070 – Call (2:04)
A little bit of VBA – 080 – Triggers (7:40)
A little bit of VBA – 090 – Objects (8:28)
A little bit of VBA – 100 – String Manipulation (25:01)
Duration : 1:27:53
A Little Bit of SQL
A short course on SQL (Structured Query Language). A precursor to Hiran’s Global Enterprise Excel course for Beginners.
This is all the SQL you need to know to take this course. Any new tricks will be introduced at the right time.
First you will need to save the Access database SQLIntroduction on your hard drive.
I shall email the Access database (SQLIntroduction.accdb) to you.
NOTE: There’s a short introductory Lesson before the 010. I am looking for it. You don’t really need it. It simply says ‘here’s the Access database which has a table called tblRockstars that has a few rows of data in it.’
A little bit of SQL – 010 – SELECT (11:57)
A little bit of SQL – 020 – INSERT (8:26)
A little bit of SQL – 030 – UPDATE (6:07)
A little bit of SQL – 040 – DELETE (7:09)
Duration : 33:39