|
|
1. Workout Example 1- PartA- Introduction to Excel VBA forms.mp4
|
MP4
|
13.1 MB
|
|
|
1. Workout Example 1- PartA- Introduction to Excel VBA forms.srt
|
SRT
|
7.29 KB
|
|
|
1.1 03_01_Form_for_compound_interest_calculation.txt
|
TXT
|
2.32 KB
|
|
|
1.2 03_01_Form_For_Compound_Interest.xlsm
|
XLSM
|
162.25 KB
|
|
|
1.3 03_temp.xlsm
|
XLSM
|
16.01 KB
|
|
|
10. Workout Example 5 - Reading microsoft access data and writing into a text file.mp4
|
MP4
|
16.32 MB
|
|
|
10. Workout Example 5 - Reading microsoft access data and writing into a text file.srt
|
SRT
|
7.56 KB
|
|
|
10.1 03_05_Fetch_Access_Data_and_write_into_a_text_file_using_Excel_VBA.xlsm
|
XLSM
|
256.13 KB
|
|
|
10.2 03_05_Fetch_Access_Data_and_write_into_a_text_file_using_Excel_VBA.txt
|
TXT
|
2.17 KB
|
|
|
11. Workout Example 6 - Part A- Design survey form in excel VBA (deal with list etc..mp4
|
MP4
|
23.79 MB
|
|
|
11. Workout Example 6 - Part A- Design survey form in excel VBA (deal with list etc..srt
|
SRT
|
12.88 KB
|
|
|
11.1 03_06_Survey_Form_n_Data_to_An_Access_Database.txt
|
TXT
|
3.15 KB
|
|
|
11.2 03_06_Survey_Form_n_Data_to_An_Access_Database.xlsm
|
XLSM
|
161.72 KB
|
|
|
12. Workout Example 6 - Part B- Design survey form in excel VBA (deal with list etc..mp4
|
MP4
|
18.28 MB
|
|
|
12. Workout Example 6 - Part B- Design survey form in excel VBA (deal with list etc..srt
|
SRT
|
10.22 KB
|
|
|
13. Workout Example 7 - Storing Excel VBA Form data into MS Access database.mp4
|
MP4
|
17.97 MB
|
|
|
13. Workout Example 7 - Storing Excel VBA Form data into MS Access database.srt
|
SRT
|
9.25 KB
|
|
|
13.1 03_07_Excel_VBA_code.txt
|
TXT
|
286 B
|
|
|
13.2 03_07_Survey_Result_Store.zip
|
ZIP
|
20.5 KB
|
|
|
14. Workout Example 8 - Part A- Using Pivot Table, VLOOKUP etc. inside a VBA code.mp4
|
MP4
|
38.21 MB
|
|
|
14. Workout Example 8 - Part A- Using Pivot Table, VLOOKUP etc. inside a VBA code.srt
|
SRT
|
17.37 KB
|
|
|
14.1 Sales_Calling_18th_Dec.xlsx
|
XLSX
|
16.31 KB
|
|
|
14.2 Collections_Calling_19th_Dec_done.xlsx
|
XLSX
|
43.48 KB
|
|
|
14.3 Collections_Calling_19th_Dec.xlsx
|
XLSX
|
16.67 KB
|
|
|
14.4 03_08_Using_Pivot_for_Sampling_through_VBA.xlsm
|
XLSM
|
38.34 KB
|
|
|
14.5 03_08_Using_Pivot_for_Sampling_through_VBA.txt
|
TXT
|
12.56 KB
|
|
|
14.6 Sales_Calling_17th_Dec.xlsx
|
XLSX
|
17.72 KB
|
|
|
14.7 Collections_Calling_17th_Dec.xlsx
|
XLSX
|
17.44 KB
|
|
|
15. Workout Example 8 - Part B- Using Pivot Table, VLOOKUP etc. inside a VBA code.mp4
|
MP4
|
36.54 MB
|
|
|
15. Workout Example 8 - Part B- Using Pivot Table, VLOOKUP etc. inside a VBA code.srt
|
SRT
|
14.13 KB
|
|
|
16. Workout Exp 09 - 01 Windows based user authentication and Voice notification.mp4
|
MP4
|
10.31 MB
|
|
|
16. Workout Exp 09 - 01 Windows based user authentication and Voice notification.srt
|
SRT
|
6.84 KB
|
|
|
16.1 03_09_Windows_Based_User_Authentication_n_Voice_Notification_Through_VBA.txt
|
TXT
|
719 B
|
|
|
16.2 03_09_Windows_Based_User_Authentication_n_Voice_Notification_Through_VBA.xlsm
|
XLSM
|
15.94 KB
|
|
|
17. Workout Exp 09 - 02- Windows based user authentication and Voice notification.mp4
|
MP4
|
2.83 MB
|
|
|
17. Workout Exp 09 - 02- Windows based user authentication and Voice notification.srt
|
SRT
|
1.44 KB
|
|
|
18. Workout Exp 10 - Reading worksheet data into a table and Running SQL inside VBA,.mp4
|
MP4
|
19.65 MB
|
|
|
18. Workout Exp 10 - Reading worksheet data into a table and Running SQL inside VBA,.srt
|
SRT
|
8.51 KB
|
|
|
18.1 03_10_Running_SQL_Command_Inside_VBA.txt
|
TXT
|
2.6 KB
|
|
|
18.2 03_10_Running_SQL_Command_Inside_VBA.xlsm
|
XLSM
|
77.32 KB
|
|
|
19. Workout Exp 11 - 01 Voice based reminder to make sure people stick to schedule.mp4
|
MP4
|
2.11 MB
|
|
|
19. Workout Exp 11 - 01 Voice based reminder to make sure people stick to schedule.srt
|
SRT
|
1.32 KB
|
|
|
2. Workout Example 1 - Part B 01- Design your first Excel VBA form.mp4
|
MP4
|
22.67 MB
|
|
|
2. Workout Example 1 - Part B 01- Design your first Excel VBA form.srt
|
SRT
|
13.46 KB
|
|
|
2.1 03_02_Temp_1.xlsm
|
XLSM
|
20.9 KB
|
|
|
20. Workout Exp 11 - 02 Voice based reminder to make sure people stick to schedule.mp4
|
MP4
|
2.18 MB
|
|
|
20. Workout Exp 11 - 02 Voice based reminder to make sure people stick to schedule.srt
|
SRT
|
1.39 KB
|
|
|
20.1 03_11_Voice_Reminder_Tool_Using_VBA.xlsm
|
XLSM
|
18.37 KB
|
|
|
20.2 03_11_Voice_Reminder_Tool_Using_VBA.txt
|
TXT
|
2.07 KB
|
|
|
21. Workout Exp 11 - 03 Voice based reminder to make sure people stick to schedule.mp4
|
MP4
|
11.93 MB
|
|
|
21. Workout Exp 11 - 03 Voice based reminder to make sure people stick to schedule.srt
|
SRT
|
6.1 KB
|
|
|
22. Workout Exp 12 - Schedule a VBA macro to run as per schedule.mp4
|
MP4
|
18.83 MB
|
|
|
22. Workout Exp 12 - Schedule a VBA macro to run as per schedule.srt
|
SRT
|
10.82 KB
|
|
|
22.1 Schedule_n_Auto_Execute_Macro.xlsm
|
XLSM
|
14.78 KB
|
|
|
22.2 Batch_n_Script_file_details.txt
|
TXT
|
558 B
|
|
|
23. Workout Exp 13 - Recursive file size of all the files n folders within a folder.mp4
|
MP4
|
127.26 MB
|
|
|
23. Workout Exp 13 - Recursive file size of all the files n folders within a folder.srt
|
SRT
|
13.4 KB
|
|
|
23.1 03_13_Recursive_File_n_size.xlsm
|
XLSM
|
198.62 KB
|
|
|
23.2 03_13_Recursive_File_n_size.txt
|
TXT
|
2.9 KB
|
|
|
24. Workout Exp 14 Combine multiple files through VBA.mp4
|
MP4
|
120.61 MB
|
|
|
24. Workout Exp 14 Combine multiple files through VBA.srt
|
SRT
|
14.76 KB
|
|
|
24.1 03_14_Combined_Multiple_Files_through_VBA.xlsm
|
XLSM
|
25.11 KB
|
|
|
24.2 Data_files.zip
|
ZIP
|
26.68 KB
|
|
|
24.3 03_14_Combine_Multiple_Files_Through_VBA.txt
|
TXT
|
2.36 KB
|
|
|
3. Workout Example 1 - Part B 02- Design your first Excel VBA form.mp4
|
MP4
|
21.15 MB
|
|
|
3. Workout Example 1 - Part B 02- Design your first Excel VBA form.srt
|
SRT
|
12.84 KB
|
|
|
4. Workout Example 1 - Part C - Explanation of demo Excel VBA form & code.mp4
|
MP4
|
24.3 MB
|
|
|
4. Workout Example 1 - Part C - Explanation of demo Excel VBA form & code.srt
|
SRT
|
11.54 KB
|
|
|
5. Workout Example 2 - Fetching data from MS Access database using Excel.mp4
|
MP4
|
27.05 MB
|
|
|
5. Workout Example 2 - Fetching data from MS Access database using Excel.srt
|
SRT
|
14.38 KB
|
|
|
5.1 03_02_Fetch_Access_Data_using_Excel_VBA.xlsm
|
XLSM
|
265.78 KB
|
|
|
5.2 Back_End_Access_DB.zip
|
ZIP
|
27.71 KB
|
|
|
5.3 03_02_Fetch_Access_Data_using_Excel_VBA.txt
|
TXT
|
1.97 KB
|
|
|
6. Workout Example 3 - Part A - One sheet per agent or product.mp4
|
MP4
|
32.11 MB
|
|
|
6. Workout Example 3 - Part A - One sheet per agent or product.srt
|
SRT
|
15.74 KB
|
|
|
6.1 Data_Sheet.xlsx
|
XLSX
|
29.33 KB
|
|
|
6.2 03_03_One_Sheet_per_Agent_or_product.txt
|
TXT
|
2.87 KB
|
|
|
6.3 03_03_One_Sheet_per_Product_or_Agent.xlsm
|
XLSM
|
18.97 KB
|
|
|
7. Workout Example 3 - Part B - One sheet per agent or product.mp4
|
MP4
|
33.77 MB
|
|
|
7. Workout Example 3 - Part B - One sheet per agent or product.srt
|
SRT
|
15.6 KB
|
|
|
8. Workout Example 4 - Part A - Coupon Assignment and Inventory management.mp4
|
MP4
|
26.07 MB
|
|
|
8. Workout Example 4 - Part A - Coupon Assignment and Inventory management.srt
|
SRT
|
12.48 KB
|
|
|
8.1 03_04_VBA_code.txt
|
TXT
|
4.66 KB
|
|
|
8.2 Demand_Tool.xlsm
|
XLSM
|
21.85 KB
|
|
|
8.3 Coupon_Store.xlsx
|
XLSX
|
11.2 KB
|
|
|
9. Workout Example 4 - Part B - Coupon Assignment and Inventory management.mp4
|
MP4
|
24.28 MB
|
|
|
9. Workout Example 4 - Part B - Coupon Assignment and Inventory management.srt
|
SRT
|
12.22 KB
|