Excel VBA Programming Course

Excel VBA
Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 17.24 GB | Duration: 26h 22m

What you'll learn
Programming in Excel from scratch
Implementing an automation in Excel
Creating application in Excel
Best programming techniques in Excel
Advanced programming techniques in Excel
Requirements
In this course, I will teach you how to program in excel using VBA code. You don't need to have any programming experience to participate in this course as we will start from the total basics, explaining each step, and ending up on complex programming tasks.
To follow along with this course and Excel 2010, 2013, 2016, 2019 or Microsoft Office 365 is required
Description
This course is dedicated to everyone who wants to learn how to use VBA in Excel. You will learn how to create complex applications and perform automations in Excel environment.In this course we will start from total basics, so you don't need any programming experience at all to participate and learn how to code in Excel.We will mostly focus on practical and just a little on theoretical aspect of programming in Excel. I will show you best programming techniques I have learnt myself.We will cover topics such as enabling developer section, recording the macro, reading the recorded code, code debugging, creating user interfaces (UI), creating applications, usage of classes and objects in excel VBA.This course is split into 6 sections in which we will discuss each of mentioned topics. We will use gained knowledge to create 3 applications in Excel.These applications will be Life Game, Minesweeper Game and Diet Application. Each of them will present different level of task complexity. By creating these applications, we will learn different project approaches and programming techniques.To each programming lesson there will be an attachment with excel file and code created in current lecture so it will be easier for you to follow along with the course and find bugs by comparing the code you have created, with the one from the course.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Recording Macro
Lecture 2 Setting up environment
Lecture 3 Recording Macro
Lecture 4 Data Types in Excel VBA
Lecture 5 Modules, Variables & Methods Declaration
Lecture 6 Reading recorded macro
Lecture 7 Modifying recorded macro
Lecture 8 Declaring variables
Section 3: Life Game
Lecture 9 Section Overview & introduction to algorithm
Lecture 10 Introduction to User Forms
Lecture 11 User Form controls
Lecture 12 User Form logic implementation
Lecture 13 Generate Field 1
Lecture 14 Generate Field 2
Lecture 15 Int positive limit for field generator
Lecture 16 Generate random population
Lecture 17 Generate 1 Life Cycle - read data
Lecture 18 Generate 1 Life Cycle - apply rules
Lecture 19 Generate 1 Life Cycle - count alive neighbours
Lecture 20 Generate 1 Life Cycle - investigate count alive neighbours
Lecture 21 Generate 1 Life Cycle - copy data from memory to excel
Section 4: Minesweeper Game
Lecture 22 Section overview & introduction
Lecture 23 Minesweeper UI Creating Game Panel
Lecture 24 Minesweeper UI adding modes and background sheets
Lecture 25 Adding global variables
Lecture 26 Generate Field
Lecture 27 Generate Field investigate recorded macro
Lecture 28 Generate Field - moving generated code
Lecture 29 Generate Field - read size from cells using global variables
Lecture 30 Generate mines 1
Lecture 31 Generate mines 2
Lecture 32 Generate mines 3 - speed up macro
Lecture 33 Calculate number of mines
Lecture 34 Reveal Fields - catching double click event 1
Lecture 35 Reveal Fields - catching double click event 2
Lecture 36 Reveal Fields - count score and win condition
Lecture 37 Reveal Fields - loosing condition
Lecture 38 Populate win-loose information
Lecture 39 Reveal zeros automatically
Lecture 40 Reveal zeros automatically - bug fix
Lecture 41 Right Mouse Button click catch - mark fields
Lecture 42 Right Mouse Button click - glitch clearing reveald field
Lecture 43 Statistics
Lecture 44 Delete Anti Cheat - Challenge
Lecture 45 Anti Cheat Solution
Lecture 46 Loose Won effect
Lecture 47 Hiding sheets - final
Section 5: Class Module & OOP
Lecture 48 Section overview & introduction
Lecture 49 OOP & Design Patterns
Lecture 50 Classes in Excel
Lecture 51 Class example, creating class
Lecture 52 Class Example, object creation
Lecture 53 Factory method overview
Lecture 54 Factory method implementation
Section 6: Diet Application
Lecture 55 Section overview & introduction
Lecture 56 Ingredient Class construction
Lecture 57 Ingredient Class Factory
Lecture 58 Meal Class construction
Lecture 59 Meal Class Factory
Lecture 60 Daily Meals Class construction
Lecture 61 Daily Meals Factory
Lecture 62 Meal Class Amend construction and Factory
Lecture 63 Weekly Diet Plan Class construction
Lecture 64 Weekly Diet Plan Factory
Lecture 65 Main View
Lecture 66 Ingredients View
Lecture 67 Ingredients View Modify New Buttons
Lecture 68 Meals View
Lecture 69 Meals View adding UI elements through code 1
Lecture 70 Meals View adding UI elements through code 2
Lecture 71 Meals View dynamically added UI element event handling
Lecture 72 Meals View moving ingredient rows
Lecture 73 Meals View Modify Button
Lecture 74 Weekly Diet View 1
Lecture 75 Weekly Diet View 2
Lecture 76 Weekly Diet dynamic UI generation 1
Lecture 77 Weekly Diet dynamic UI generation 2
Lecture 78 Weekly Diet dynamically added UI element event handling
Lecture 79 Weekly Diet Modify New buttons
Lecture 80 Diet Application File structure and storing data
Lecture 81 Ingredient View Adding New Ingredient 1
Lecture 82 Ingredient View Adding New Ingredient 2
Lecture 83 Ingredient View Adding New Ingredient 3
Lecture 84 Ingredient View Populate Ingredients in ComboBox
Lecture 85 Ingredient View load ingredient from ComboBox
Lecture 86 Meals View Adding New Meal 1
Lecture 87 Meals View Adding New Meal 2 - Check if Numeric Value
Lecture 88 Meals View Adding New Meal 3 - Check if Numeric Value in Dynamic elements
Lecture 89 Meals View Adding New Meal 4 - calculate Kcal 1
Lecture 90 Meals View Adding New Meal 5 - calculate Kcal 2
Lecture 91 Meals View Adding New Meal 6 - calculate Kcal 3
Lecture 92 Meals View Adding New Meal 7 - calculate Kcal 4 Dynamic elements
Lecture 93 Meals View Adding New Meal 8 - calculate Kcal 5 Dynamic elements - bug tracking
Lecture 94 Meals View Adding New Meal 9 - Save data 1
Lecture 95 Meals View Adding New Meal 10 - Save data 2
Lecture 96 Meals View Adding New Meal 11 - Save data 3
Lecture 97 Meals View Adding New Meal 12 - Save data 4
Lecture 98 Meals View Adding New Meal 13 - Save data 5
Lecture 99 Meals View Adding New Meal 14 - Save data 6
Lecture 100 Meals View - fixing errors
Lecture 101 Meals View Populate Meals in Combobox
Lecture 102 Meals View Load Meals to User Form 1
Lecture 103 Meals View Load Meals to User Form 2
Lecture 104 Meals View Load Meals to User Form 3
Lecture 105 Weekly Diet View Adding New Daily Meals 1
Lecture 106 Weekly Diet View Adding New Daily Meals 2 - dynamic combobox list
Lecture 107 Weekly Diet View Adding New Daily Meals 2 - dynamic combobox list - fixing bug
Lecture 108 Weekly Diet View Adding New Daily Meals 3 - calculate total nutrition for day
Lecture 109 Weekly Diet View Adding New Daily Meals 4 - week day comboboxes
Lecture 110 Weekly Diet View Adding New Daily Meals 5 - create diet plan object
Lecture 111 Weekly Diet View Adding New Daily Meals 6 - adding data to object 1
Lecture 112 Weekly Diet View Adding New Daily Meals 7 - adding data to object 2
Lecture 113 Weekly Diet View Adding New Daily Meals 8 - adding data to object 3
Lecture 114 Weekly Diet View Adding New Daily Meals 9 - adding data to object 4
Lecture 115 Weekly Diet View Adding New Daily Meals 10 - adding data to object 5
Lecture 116 Weekly Diet View Adding New Daily Meals 11 - adding data from dynamic elements 1
Lecture 117 Weekly Diet View Adding New Daily Meals 12 - adding data from dynamic elements 2
Lecture 118 Weekly Diet View Adding New Daily Meals 13 - display specific day data 1
Lecture 119 Weekly Diet View Adding New Daily Meals 14 - display specific day data 2
Lecture 120 Weekly Diet View Adding New Daily Meals 15 - remove item from list
Lecture 121 Weekly Diet View Adding New Daily Meals 16 - save meal plan 1
Lecture 122 Weekly Diet View Adding New Daily Meals 16 - save meal plan 2
Lecture 123 Weekly Diet View Load Weekly Diet Plans to Combo Box
Lecture 124 Weekly Diet View Load Weekly Diet Plan to memory 1
Lecture 125 Weekly Diet View Load Weekly Diet Plan to memory 2
Lecture 126 Weekly Diet View Load Weekly Diet Plan to memory 3
Lecture 127 Weekly Diet View Load Weekly Diet Plan to memory 4
Lecture 128 Weekly Diet View Load Daily Plan To UI 1
Lecture 129 Weekly Diet View Load Daily Plan To UI 2
Lecture 130 Weekly Diet View Load Daily Plan To UI 3
Lecture 131 Weekly Diet View Load Daily Plan To UI 4
Lecture 132 Weekly Diet View Load Daily Plan To UI 5
Lecture 133 Weekly Diet View Load Daily Plan To UI 6
Lecture 134 Weekly Diet View Generate Diet To Excel Worksheet 1
Lecture 135 Weekly Diet View Generate Diet To Excel Worksheet 2
Lecture 136 Weekly Diet View Generate Diet To Excel Worksheet 3
Lecture 137 Weekly Diet View Generate Diet To Excel Worksheet 4
Lecture 138 Weekly Diet View Generate Diet To Excel Worksheet 5
Lecture 139 Weekly Diet View Generate Diet To Excel Worksheet 6
Lecture 140 Weekly Diet View Generate Diet To Excel Worksheet 7
Lecture 141 Bug Fixes
This course is dedicated to everyone who wants to learn or improve programming skills in Excel VBA.

Homepage

https://www.udemy.com/course/excel-vba-programming-course/

Links are Interchangeable - No Password - Single Extraction

Вернуться назад

Навигация

Рекомендуем

Статистика

Excel VBA Programming Course

Коментарии

Рекомендуем

Популярное