1 Introduction.mp4 (28.93 MB)
MP4
2 L02 Important How to choose the lessons for your level!.mp4 (14.82 MB)
MP4
10 L09 While Loop with a new way to find last row in dataset ().mp4 (71.95 MB)
MP4
11 L10 Mini Report with Loops ().mp4 (148.8 MB)
MP4
2 L01 Use For Next Loop to filter Data ().mp4 (145.58 MB)
MP4
3 L02 Reverse For Next Loop ().mp4 (92.1 MB)
MP4
4 L03 Do Until Do While Do ().mp4 (93.08 MB)
MP4
5 L04 Do Loop with InputBox ().mp4 (92.94 MB)
MP4
6 L05 Find 1 Match ().mp4 (103.87 MB)
MP4
7 L06 Find Multiple Matches ().mp4 (91.39 MB)
MP4
8 L07 Timer to Measure Code RunTime ().mp4 (48.88 MB)
MP4
9 L08 Stop an infinite Loop ().mp4 (26.69 MB)
MP4
2 L01 Error Handling ().mp4 (93.96 MB)
MP4
3 L02 Speed up your code ().mp4 (38.65 MB)
MP4
4 L03 Modular Coding ().mp4 (25.2 MB)
MP4
5 L04 Passing Arguments (Byval vs ByRef) to Procedures & Procedure Scope ().mp4 (91.43 MB)
MP4
2 L01 Overview + Left, Right, Mid ().mp4 (70.55 MB)
MP4
3 L02 Replace ().mp4 (51.49 MB)
MP4
4 L03 Instr ().mp4 (61.46 MB)
MP4
5 L04 Check if string is empty ().mp4 (16.63 MB)
MP4
6 L05 Pitfall to avoid with Trim and Change Case of String ().mp4 (54.84 MB)
MP4
7 L06 Mini Project - Extract Ratings ().mp4 (240.9 MB)
MP4
2 L01 Overview and basic date functions ().mp4 (78.97 MB)
MP4
3 L02 Play with Date, Time and Use YearFrac ().mp4 (106.37 MB)
MP4
4 L03 Number of days between dates (Simple subtraction & Networkdays) ().mp4 (85.14 MB)
MP4
5 L04 Number of MonthsYears between dates - Datediff and DateDif ().mp4 (155.41 MB)
MP4
6 L05 Mini Project - Fill the calendar ().mp4 (141.45 MB)
MP4
2 L01 Overview and your first custom function ().mp4 (64.19 MB)
MP4
3 L02 Move your function under a category a provide definitions to the user().mp4 (79.68 MB)
MP4
4 L03 Mini Project - Find the Expiry date ().mp4 (124.77 MB)
MP4
5 L04 Function example - How to manipulate text ().mp4 (49.23 MB)
MP4
6 L05 Run Functions from Subs Other functions ().mp4 (56.48 MB)
MP4
7 L06 Optional Parameters in Functions ().mp4 (79.13 MB)
MP4
2 L01 One-Dimension Array ().mp4 (97.67 MB)
MP4
3 L02 Dynamic Sized Arrays ().mp4 (44.3 MB)
MP4
4 L03 Keep your existing values when Rediming your array ().mp4 (26.97 MB)
MP4
5 L04 Multidimensional Arrays ().mp4 (48.38 MB)
MP4
5 1 15 04 2DimArrays.mp4 (145.94 MB)
MP4
6 L05 Variant Array ().mp4 (103.26 MB)
MP4
7 L06 Mini Project - Generate Sub Reports by City ().mp4 (120.08 MB)
MP4
1 4 SampleFolder.zip (49.54 KB)
ZIP
2 L01 Check if File Folder Exists and Create a new folder ().mp4 (128.5 MB)
MP4
3 L02 Allow user to select the file to open via dialog box ().mp4 (107.76 MB)
MP4
4 L03 Picking a Folder with FileDialog ().mp4 (155.55 MB)
MP4
5 L04 Save your files in different formats ().mp4 (62.79 MB)
MP4
6 L05 Open statement for more control over txt file ().mp4 (66.28 MB)
MP4
7 L06 Copy paste data into CSV file with custom delimiter ().mp4 (97.66 MB)
MP4
8 L07 Mini Project - Create a consolidated scorecard from selected files ().mp4 (227.04 MB)
MP4
2 L01 Crash course on Excel Tables ().mp4 (238.59 MB)
MP4
3 L02 Pivot Table VBA theory and Trick to get the right code-no memorizing ().mp4 (154.23 MB)
MP4
4 L03 Pivot Table Main activities ().mp4 (174.83 MB)
MP4
2 L01 Create a PDF File from your excel sheets ().mp4 (152.14 MB)
MP4
3 L02 Manipulate Word from VBA ().mp4 (228.41 MB)
MP4
4 L03 Create a Presentation on PowerPoint from VBA ().mp4 (211.58 MB)
MP4
5 L04 Create automatic Emails with attachments from VBA ().mp4 (157.63 MB)
MP4
10 L09 Textbox - ActiveX Tricks Part 1 (Tabbing, Change and Focus Events) ().mp4 (97.62 MB)
MP4
11 L10 Textbox - ActiveX Tricks Part 2 (Restrict user inputs) + recap ().mp4 (55.75 MB)
MP4
12 L11 Checkbox - ActiveX Properties and Example ().mp4 (137.77 MB)
MP4
13 L12 Checkbox - Form Control Properties and Example.mp4 (93.54 MB)
MP4
14 L13 Option Button ActiveX - Grouping and example ().mp4 (72.14 MB)
MP4
15 L14 Option Button - Form Control Grouping and example ().mp4 (94.55 MB)
MP4
16 L15 Option Button and Checkbox Recap ().mp4 (12.71 MB)
MP4
17 L16 Spin Buttons - ActiveX & Form Control Properties and example ().mp4 (138.55 MB)
MP4
18 L17 Labels - ActiveX & Form Control Practical use cases ().mp4 (95.8 MB)
MP4
19 L18 Combo box - ActiveX & Form Control Additional properties ().mp4 (103.41 MB)
MP4
2 L01 Button Properties + Difference between ActiveX and Form controls ().mp4 (128.89 MB)
MP4
20 L19 Combo box - ActiveX Main activities ().mp4 (150.62 MB)
MP4
21 L20 Combo box - Form Control Main activities ().mp4 (115.46 MB)
MP4
22 L21 List box -Active & Form Control Additional properties ().mp4 (44.57 MB)
MP4
23 L22 List box - ActiveX Main activities ().mp4 (122.11 MB)
MP4
24 L23 List box - Form Control Main activities ().mp4 (78.22 MB)
MP4
25 L24 Scroll bar Quick overview ().mp4 (59 MB)
MP4
3 L02 Button Key Press Events Capture keys pressed - ActiveX ().mp4 (91.04 MB)
MP4
4 L03 Button Key Press Event Capture Control, Shift and Alt - ActiveX ().mp4 (24.75 MB)
MP4
5 L04 Button Mouse Over Event - ActiveX ().mp4 (64.76 MB)
MP4
6 L05 Button Simulate a Mouse Leave Event - ActiveX ().mp4 (59.89 MB)
MP4
7 L06 Button Write in Shape - Form Controls + Recap of what we learned ().mp4 (65.44 MB)
MP4
7 1 19 06 FormControlRecap.mp4 (111.72 MB)
MP4
8 L07 Textbox - ActiveX Additional Properties ().mp4 (101.86 MB)
MP4
9 L08 Textbox - Form Controls Properties ().mp4 (49.52 MB)
MP4
2 L01 Basic Set up and Introduction to VBE ().mp4 (92.99 MB)
MP4
3 L02 Copy Paste & Save your code ().mp4 (55.11 MB)
MP4
4 L03 Forget your fear and write your first macro ().mp4 (66.87 MB)
MP4
5 L04 Run your Macro 10 Ways ().mp4 (102.55 MB)
MP4
6 L05 Use ChatGPT to write your code! ().mp4 (70.98 MB)
MP4
7 L06 Code Color, Useful Shortcuts & Basic Debugging ().mp4 (53.29 MB)
MP4
8 L07 Useful shortcuts & Debugging techniques ().mp4 (63.26 MB)
MP4
10 L09 Initialize List Box ().mp4 (48.3 MB)
MP4
11 L10 Tab it the right way! ().mp4 (50.9 MB)
MP4
12 L11 Wow your stakeholders with an Image ().mp4 (95.61 MB)
MP4
13 L12 Validate the Userform data entry or you might be in trouble ().mp4 (161.6 MB)
MP4
14 L13 Save your data ().mp4 (122.14 MB)
MP4
15 L14 Edit Form Set up ().mp4 (118.54 MB)
MP4
16 L15 Dynamic Search Box ().mp4 (64.93 MB)
MP4
17 L16 Get info form Database into the form ().mp4 (227.47 MB)
MP4
18 L17 Saving edited data ().mp4 (109.41 MB)
MP4
2 L01 Intro to UserForms + a look at a new control! ().mp4 (61.71 MB)
MP4
3 L02 UserForms Property ().mp4 (93.51 MB)
MP4
4 L03 Button Aesthetic trick ().mp4 (46.4 MB)
MP4
5 L04 Is TabStrip right for our mini project ().mp4 (72.91 MB)
MP4
6 L05 Use Multipage to set up the form in a professional way ().mp4 (89.87 MB)
MP4
7 L06 Using a Frame to Group Option buttons automatically ().mp4 (23.6 MB)
MP4
8 L07 Don't forget to initialize your form ().mp4 (60.75 MB)
MP4
9 L08 Initialize Combo Box ().mp4 (26.14 MB)
MP4
2 L01 Chart Intro ().mp4 (17.78 MB)
MP4
3 L02 Easiest way to create and modify a chart ().mp4 (125.29 MB)
MP4
4 L03 Animate your chart to wow your audience ().mp4 (160.01 MB)
MP4
5 L04 Load your chart into a UserForm ().mp4 (65.86 MB)
MP4
2 L01 Workbook events ().mp4 (56.45 MB)
MP4
3 L02 Worksheet events ().mp4 (40.22 MB)
MP4
4 L03 Intersect to trigger an action only on certain cells ().mp4 (82.62 MB)
MP4
5 L04 Reset a dependent dropdown menu ().mp4 (67.19 MB)
MP4
6 L05 Use the BeforePrint event to fix your header issues ().mp4 (43 MB)
MP4
10 L08 Copy Paste(Special) ().mp4 (87.88 MB)
MP4
11 L09 Resize a Range ().mp4 (93.04 MB)
MP4
12 L10 Mini Project Part 1- Sort Data and generate a report using a template ().mp4 (106.52 MB)
MP4
13 L10 Mini Project Part 2- Sort Data and generate a report using a template ().mp4 (131.53 MB)
MP4
14 L11 Mini Project - Report Analyzer ().mp4 (178.74 MB)
MP4
2 L01 Cell Referencing, Row Height & Column Width ().mp4 (161.71 MB)
MP4
3 L02 Common Properties & Methods related to Cells ().mp4 (83.96 MB)
MP4
4 L03 Finding Last RowLast Column in dataset ().mp4 (130.11 MB)
MP4
5 L04 Select Data, Get the address & Delete Data ().mp4 (110.51 MB)
MP4
6 L05 Part 1 Formatting with VBA ().mp4 (112.9 MB)
MP4
7 L05 Part 2 Trick to extract RGB from a color ().mp4 (57.96 MB)
MP4
8 L06 Sheet Referencing ().mp4 (77.06 MB)
MP4
9 L07 Workbook Referencing ().mp4 (61.18 MB)
MP4
2 L01 The Excel Object Model ().mp4 (35.41 MB)
MP4
3 L02 Object Properties ().mp4 (18.33 MB)
MP4
4 L03 Object Methods ().mp4 (20.7 MB)
MP4
5 L04 Don't Memorize -Different ways to get find Objects, Properties & Methods().mp4 (69.64 MB)
MP4
2 L01 File & Edit Menus ().mp4 (87.88 MB)
MP4
3 L02 View Menu ().mp4 (44.65 MB)
MP4
4 L03 Insert, Format, Debug & Run Menus ().mp4 (51.24 MB)
MP4
5 L04 Tools Menu ().mp4 (46.97 MB)
MP4
2 L01 Intro to Variables & Types ().mp4 (51.69 MB)
MP4
3 L02 Declaring Variables - best practices ().mp4 (88.09 MB)
MP4
4 L03 Object Variables ().mp4 (90.76 MB)
MP4
5 L04 Variable Scope - Rock Paper Cisor Game ().mp4 (170.17 MB)
MP4
6 L05 Order of Preference in Calculations ().mp4 (64.98 MB)
MP4
7 L06 Convert to a different Data Type ().mp4 (73.89 MB)
MP4
8 L07 Formulas ().mp4 (144.82 MB)
MP4
9 L08 Mini Project Expense Report ().mp4 (213.26 MB)
MP4
2 L01 Macro Recorder ().mp4 (89.01 MB)
MP4
3 L02 R1C1 Notation ().mp4 (152.08 MB)
MP4
4 L03 Practical use of Macro Recorder to automate Task ().mp4 (108.47 MB)
MP4
5 L04 Absolute vs Relative Reference in Recording ().mp4 (84.19 MB)
MP4
2 L01 With End With ().mp4 (69.54 MB)
MP4
3 L02 For Each In Next ().mp4 (60.7 MB)
MP4
4 L03 If Statement with ProtectUnprotect Sheet ().mp4 (76.5 MB)
MP4
5 L04 And Or Logical Operators ().mp4 (44.84 MB)
MP4
6 L05 Like Operator ().mp4 (88.85 MB)
MP4
7 L06 IsNumeric ().mp4 (41.76 MB)
MP4
8 L07 Select Case ().mp4 (75.32 MB)
MP4
2 L01 MsgBox Deep Dive ().mp4 (131.17 MB)
MP4
3 L02 InputBox ().mp4 (144.6 MB)
MP4
4 L03 Get a Range of Cells with InputBox ().mp4 (46.77 MB)
MP4
5 L04 Mini Project - Identify the winners ().mp4 (95.04 MB)
MP4