EIJOC1

@UCWIgelyZJrSn_zcHkAtArww - 81 subscribers

EXCELLENT INSTITUTE OF JOB ORIENTED COURSES (E.I.J.O.C) Provides An Excellent Coaching With Real Professional Office Work Examples. ( Weekends | Alternate Days Classes ) Courses:- Excel, VBA & Macros, Ms-SQL, Power-Bi, Ms-Access, RPA Ui-Path, Python, Visual-Basic, MIS, WFM, Powerpoint, Outlook, Ms-Office, Ms-Word Etc. Contact at ( Email_ID : [email protected] )

Home Videos Live Playlists

Class_51_EXCEL VBA & MACROS_0036_26.0412_Create Dashboard & Report by VBA Code - Part-1

Class_51_EXCEL VBA & MACROS_0036_26.0412_Create Dashboard & Report by VBA Code - Part-1 EIJOC1

1 views - 2 days ago

Class_19_Power Bi_Tutorials_0037_26.0412_DAX_Part-7_COUNTROWS, VALUES, DISTINCT, LOOKUPVALUE

Class_19_Power Bi_Tutorials_0037_26.0412_DAX_Part-7_COUNTROWS, VALUES, DISTINCT, LOOKUPVALUE EIJOC1

12 views - 2 days ago

Class_50_EXCEL VBA & MACROS_0036_26.0329_MsgBox Coding, Return multiple values, Make Zip or Unzip.

Class_50_EXCEL VBA & MACROS_0036_26.0329_MsgBox Coding, Return multiple values, Make Zip or Unzip. EIJOC1

7 views - 2 weeks ago

Class_18_Power Bi_Tutorials_0037_26.0329_DAX_Part-6_SWITCH,IF, NestedIF, AND,OR,NOT,COUNTROWS,FILTER

Class_18_Power Bi_Tutorials_0037_26.0329_DAX_Part-6_SWITCH,IF, NestedIF, AND,OR,NOT,COUNTROWS,FILTER EIJOC1

4 views - 2 weeks ago

Class_49_EXCEL VBA & MACROS_0036_26.0322_Workbook.SaveAs with Password, MsgBox Programming Code.

Class_49_EXCEL VBA & MACROS_0036_26.0322_Workbook.SaveAs with Password, MsgBox Programming Code. EIJOC1

3 views - 3 weeks ago

Class_48_EXCEL VBA & MACROS_0036_26.0315_Sheet.Protect, Range.Protect, Workbook.Protect, Share File

Class_48_EXCEL VBA & MACROS_0036_26.0315_Sheet.Protect, Range.Protect, Workbook.Protect, Share File EIJOC1

1 views - 4 weeks ago

Class_17_Power Bi_Tutorials_0037_26.0315_DAX_Part-5_SUM, SUMIF, SUMIFS, CALENDAR, CALENDARAUTO

Class_17_Power Bi_Tutorials_0037_26.0315_DAX_Part-5_SUM, SUMIF, SUMIFS, CALENDAR, CALENDARAUTO EIJOC1

1 views - 4 weeks ago

Class_16_Power Bi_Tutorials_0037_26.0222_DAX_Part-4_Columns & Measure, All, AllExcept, AllSelected

Class_16_Power Bi_Tutorials_0037_26.0222_DAX_Part-4_Columns & Measure, All, AllExcept, AllSelected EIJOC1

4 weeks ago

Class_15_Power Bi_Tutorials_0037_26.0215_DAX_Part-3_FORMAT,FIND, SEARCH, SUM, SUMX, & CALCULATE

Class_15_Power Bi_Tutorials_0037_26.0215_DAX_Part-3_FORMAT,FIND, SEARCH, SUM, SUMX, & CALCULATE EIJOC1

1 views - 4 weeks ago

Class_47_EXCEL VBA & MACROS_0036_26.0301_Active_Items, Cell Border Formatting, Resize, VBA Run Fast

Class_47_EXCEL VBA & MACROS_0036_26.0301_Active_Items, Cell Border Formatting, Resize, VBA Run Fast EIJOC1

2 views - 1 month ago

Class_46_EXCEL VBA & MACROS_0036_26.0222_Sheets.Add, Sheets.delete, Sheet.Name, Workbooks.Add.

Class_46_EXCEL VBA & MACROS_0036_26.0222_Sheets.Add, Sheets.delete, Sheet.Name, Workbooks.Add. EIJOC1

2 views - 1 month ago

Class_45_EXCEL VBA & MACROS_0036_26.0208_Application.SendKey, Debugging or Error Handling in VBA.

Class_45_EXCEL VBA & MACROS_0036_26.0208_Application.SendKey, Debugging or Error Handling in VBA. EIJOC1

1 views - 1 month ago

Class_44_EXCEL VBA & MACROS_0036_26.0125_Call Procedure, Application.Wait, Application.OnTime, OnKey

Class_44_EXCEL VBA & MACROS_0036_26.0125_Call Procedure, Application.Wait, Application.OnTime, OnKey EIJOC1

1 month ago

Class_43_EXCEL VBA & MACROS_0036_26.01118VBA Function ByRef & ByVal, Optional, Default, HYPERLINK

Class_43_EXCEL VBA & MACROS_0036_26.01118VBA Function ByRef & ByVal, Optional, Default, HYPERLINK EIJOC1

10 views - 1 month ago

Class_42_EXCEL VBA & MACROS_0036_26.0111_User Defined VBA Functions, Use functions in Excel Sheet.

Class_42_EXCEL VBA & MACROS_0036_26.0111_User Defined VBA Functions, Use functions in Excel Sheet. EIJOC1

2 views - 1 month ago

Class_41_EXCEL VBA & MACROS_0036_26.0104_ConvertDataType, PublishObjects, & UserDefined VBA Function

Class_41_EXCEL VBA & MACROS_0036_26.0104_ConvertDataType, PublishObjects, & UserDefined VBA Function EIJOC1

3 views - 1 month ago

Class_40_EXCEL VBA & MACROS_0036_25.1221_FileDialog Open, SaveAs, File&FolderPicker, GetOpenFilename

Class_40_EXCEL VBA & MACROS_0036_25.1221_FileDialog Open, SaveAs, File&FolderPicker, GetOpenFilename EIJOC1

3 views - 1 month ago

Class_39_EXCEL VBA & MACROS_0036_25.1214_Create Pivot Tables & Pivot Charts by VBA Code, VBA-Shell

Class_39_EXCEL VBA & MACROS_0036_25.1214_Create Pivot Tables & Pivot Charts by VBA Code, VBA-Shell EIJOC1

4 views - 1 month ago

Class_38_EXCEL VBA & MACROS_0036_25.1207_VBA Connectivity with MicroSoft SQLServer, Insert, Update

Class_38_EXCEL VBA & MACROS_0036_25.1207_VBA Connectivity with MicroSoft SQLServer, Insert, Update EIJOC1

1 month ago

Class_37_EXCEL VBA & MACROS_0036_25.1123_VBA Connectivity with MS-Access& Excel,Insert,Update,Delete

Class_37_EXCEL VBA & MACROS_0036_25.1123_VBA Connectivity with MS-Access& Excel,Insert,Update,Delete EIJOC1

61 views - 1 month ago

Class_14_Power Bi_Tutorials_0037_26.0118_DAX_Part-2_ISNUMBER, ISTEXT,ISODD,ISEVEN, IFERROR, MIN, MAX

Class_14_Power Bi_Tutorials_0037_26.0118_DAX_Part-2_ISNUMBER, ISTEXT,ISODD,ISEVEN, IFERROR, MIN, MAX EIJOC1

2 views - 1 month ago

Class_13_Power Bi_Tutorials_0037_25.1221_PowerBI DAX_Part-1, Columns Addition,Substract,Divide, Left

Class_13_Power Bi_Tutorials_0037_25.1221_PowerBI DAX_Part-1, Columns Addition,Substract,Divide, Left EIJOC1

1 views - 1 month ago

Class_12_Power Bi_Tutorials_0037_25.1214_Pivot & Un-Pivot Data, Move Columns Position, Query Setting

Class_12_Power Bi_Tutorials_0037_25.1214_Pivot & Un-Pivot Data, Move Columns Position, Query Setting EIJOC1

10 views - 1 month ago

Class_11_Power Bi_Tutorials_0037_25.1130_Extract from Time,Duration, TransposeData,Change Data Types

Class_11_Power Bi_Tutorials_0037_25.1130_Extract from Time,Duration, TransposeData,Change Data Types EIJOC1

7 views - 1 month ago

Class_10_Power Bi_Tutorials_0037_25.1123_Extract from Date Week, Day, SubtractDays, Combine DateTime

Class_10_Power Bi_Tutorials_0037_25.1123_Extract from Date Week, Day, SubtractDays, Combine DateTime EIJOC1

1 views - 1 month ago

Class_09_Power Bi_Tutorials_0037_25.1116_Custom &,Conditional Column,Format & Extract Text, Rounding

Class_09_Power Bi_Tutorials_0037_25.1116_Custom &,Conditional Column,Format & Extract Text, Rounding EIJOC1

1 month ago

Class_36_EXCEL VBA & MACROS_0036_25.1116_VBA connectivity with Notepad, Loop Through Notepad File

Class_36_EXCEL VBA & MACROS_0036_25.1116_VBA connectivity with Notepad, Loop Through Notepad File EIJOC1

12 views - 1 month ago

Class_35_EXCEL VBA & MACROS_0036_25.1109_VBA Connectivity With Powerpoint & Ms-Word.

Class_35_EXCEL VBA & MACROS_0036_25.1109_VBA Connectivity With Powerpoint & Ms-Word. EIJOC1

10 views - 5 months ago

Class_08_Power Bi_Tutorials_0037_25.1109_Create, Manage, & Edit Parameter, New Parameter - Numeric

Class_08_Power Bi_Tutorials_0037_25.1109_Create, Manage, & Edit Parameter, New Parameter - Numeric EIJOC1

18 views - 5 months ago

Class_34_EXCEL VBA & MACROS_0036_25.1026_Outlook_P2, Send Excel Range, Save Email Attachments.

Class_34_EXCEL VBA & MACROS_0036_25.1026_Outlook_P2, Send Excel Range, Save Email Attachments. EIJOC1

8 views - 5 months ago

Class_33_EXCEL VBA & MACROS_0036_25.1012_UserFormControl Add by Button, Early&LateBinding,Outlook_P1

Class_33_EXCEL VBA & MACROS_0036_25.1012_UserFormControl Add by Button, Early&LateBinding,Outlook_P1 EIJOC1

24 views - 6 months ago

Class_07_Power Bi_Tutorials_0037_25.1012_Merge Queries (Left,Right,Inner,Full,Left-Anti), GroupBy

Class_07_Power Bi_Tutorials_0037_25.1012_Merge Queries (Left,Right,Inner,Full,Left-Anti), GroupBy EIJOC1

15 views - 6 months ago

Class_32_EXCEL VBA & MACROS_0036_25.1005_Userform to Change Font &CellColor, TextBox&UserForm Events

Class_32_EXCEL VBA & MACROS_0036_25.1005_Userform to Change Font &CellColor, TextBox&UserForm Events EIJOC1

5 views - 6 months ago

Class_06_Power Bi_Tutorials_0037_25.1005_Split Column Data, Append & Merge Queries.

Class_06_Power Bi_Tutorials_0037_25.1005_Split Column Data, Append & Merge Queries. EIJOC1

11 views - 6 months ago

Class_31_EXCEL VBA & MACROS_0036_25.0928_Banking_APP-P5, WebBrowser, MediaPlayer, ControlsValidation

Class_31_EXCEL VBA & MACROS_0036_25.0928_Banking_APP-P5, WebBrowser, MediaPlayer, ControlsValidation EIJOC1

29 views - 6 months ago

Class_05_Power Bi_Tutorials_0037_25.0928_Keep & Remove Rows, Choose & Remove Columns

Class_05_Power Bi_Tutorials_0037_25.0928_Keep & Remove Rows, Choose & Remove Columns EIJOC1

28 views - 6 months ago

T0004_25.0924_Download & Install MS SQL Server Developer Edition

T0004_25.0924_Download & Install MS SQL Server Developer Edition EIJOC1

4 views - 6 months ago

T0003_25.0924_Download & Install PowerBI

T0003_25.0924_Download & Install PowerBI EIJOC1

4 views - 6 months ago

T0002_25.0924_C Drive Partitions

T0002_25.0924_C Drive Partitions EIJOC1

4 views - 6 months ago

T0001_25.0924_Change System User Name

T0001_25.0924_Change System User Name EIJOC1

3 views - 6 months ago

Class_30_EXCEL VBA & MACROS_0036_25.0914_Banking_APP-P4, Edit & View Records Coding, Print to PDF

Class_30_EXCEL VBA & MACROS_0036_25.0914_Banking_APP-P4, Edit & View Records Coding, Print to PDF EIJOC1

17 views - 6 months ago

Class_29_EXCEL VBA & MACROS_0036_25.0907_Banking_APP-P3, Add Records Button Coding, Save Data

Class_29_EXCEL VBA & MACROS_0036_25.0907_Banking_APP-P3, Add Records Button Coding, Save Data EIJOC1

18 views - 7 months ago

Class_04_Power Bi_Tutorials_0037_25.0907_ColumnCharts, PieChart, Cards, Multi-Cards, Table &Metrices

Class_04_Power Bi_Tutorials_0037_25.0907_ColumnCharts, PieChart, Cards, Multi-Cards, Table &Metrices EIJOC1

18 views - 7 months ago

Class_28_EXCEL VBA & MACROS_0036_25.0831_Banking_APP-P2, Load Data into ListBox & ComboBox.

Class_28_EXCEL VBA & MACROS_0036_25.0831_Banking_APP-P2, Load Data into ListBox & ComboBox. EIJOC1

59 views - 7 months ago

Class_03_Power Bi_Tutorials_0037_25.0831_Get Data from MicroSoft SQL Server, MS- Access & Excel File

Class_03_Power Bi_Tutorials_0037_25.0831_Get Data from MicroSoft SQL Server, MS- Access & Excel File EIJOC1

16 views - 7 months ago

Class_27_EXCEL VBA & MACROS_0036_25.0824_Array Option Base 1, , UserForm Controls, Banking_APP-P1

Class_27_EXCEL VBA & MACROS_0036_25.0824_Array Option Base 1, , UserForm Controls, Banking_APP-P1 EIJOC1

25 views - 7 months ago

Class_02_Power Bi_Tutorials_0037_25.0824_Get Data from Excel, Text File, Folder, PDF File, & Website

Class_02_Power Bi_Tutorials_0037_25.0824_Get Data from Excel, Text File, Folder, PDF File, & Website EIJOC1

16 views - 7 months ago

Class_26_EXCEL VBA & MACROS_0036_25.0817_Array, Single & Multi Dimension Array, Redim Preserve, Join

Class_26_EXCEL VBA & MACROS_0036_25.0817_Array, Single & Multi Dimension Array, Redim Preserve, Join EIJOC1

91 views - 7 months ago

Class_25_EXCEL VBA & MACROS_0036_25.0803_WorkbookEvents e.g. Open, Close, Activate,Deactivate,Change

Class_25_EXCEL VBA & MACROS_0036_25.0803_WorkbookEvents e.g. Open, Close, Activate,Deactivate,Change EIJOC1

38 views - 8 months ago

Class_01_Power Bi_Tutorials_0037_25.0803_Download and Install Power BI, Architecture, & Components

Class_01_Power Bi_Tutorials_0037_25.0803_Download and Install Power BI, Architecture, & Components EIJOC1

23 views - 8 months ago

Class_24_EXCEL VBA & MACROS_0036_25.0727_WorksheetEvents e.g. Change, SelectionChange, Activate Etc

Class_24_EXCEL VBA & MACROS_0036_25.0727_WorksheetEvents e.g. Change, SelectionChange, Activate Etc EIJOC1

25 views - 8 months ago

Class_23_EXCEL VBA & MACROS_0036_25.0720_FSO, Read TextFile, Test Exist Folder & Files, MkDir, RmDir

Class_23_EXCEL VBA & MACROS_0036_25.0720_FSO, Read TextFile, Test Exist Folder & Files, MkDir, RmDir EIJOC1

24 views - 8 months ago

Class_22_EXCEL VBA & MACROS_0036_25.0713_ FSO, Create, Copy, Move, Delete, Rename Files & Folders.

Class_22_EXCEL VBA & MACROS_0036_25.0713_ FSO, Create, Copy, Move, Delete, Rename Files & Folders. EIJOC1

60 views - 9 months ago

28_25.0713_MicroSoft SQL Server Tutorials_0034_Logon Triggers, Import from Excel Table Import Wizard

28_25.0713_MicroSoft SQL Server Tutorials_0034_Logon Triggers, Import from Excel Table Import Wizard EIJOC1

29 views - 9 months ago

Class_21_EXCEL VBA & MACROS_0036_25.0706_Copy Data from Multiple Sheets & Workbooks, Design by Loop.

Class_21_EXCEL VBA & MACROS_0036_25.0706_Copy Data from Multiple Sheets & Workbooks, Design by Loop. EIJOC1

39 views - 9 months ago

Class_20_EXCEL VBA & MACROS_0036_25.0629_For-Next P2, For-Each, Do While, Do Until, While-Wend Loops

Class_20_EXCEL VBA & MACROS_0036_25.0629_For-Next P2, For-Each, Do While, Do Until, While-Wend Loops EIJOC1

55 views - 9 months ago

Class_19_EXCEL VBA & MACROS_0036_25.0622_Data Validation-Part2 Date, Time,List,For-Next Loops Part-1

Class_19_EXCEL VBA & MACROS_0036_25.0622_Data Validation-Part2 Date, Time,List,For-Next Loops Part-1 EIJOC1

70 views - 9 months ago

27_25.0622_MicroSoft SQL Server Tutorials_0034_Instead of Insert, Update, Delete Triggers

27_25.0622_MicroSoft SQL Server Tutorials_0034_Instead of Insert, Update, Delete Triggers EIJOC1

26 views - 9 months ago

Class_18_EXCEL VBA & MACROS_0036_25.0615_FormatConditions P-2, Data Validation-Part1 (Whole Number)

Class_18_EXCEL VBA & MACROS_0036_25.0615_FormatConditions P-2, Data Validation-Part1 (Whole Number) EIJOC1

19 views - 9 months ago

26_25.0615_MicroSoft SQL Server Tutorials_0034_ALL Type of TRIGGERS, After TRIGGERS DML.

26_25.0615_MicroSoft SQL Server Tutorials_0034_ALL Type of TRIGGERS, After TRIGGERS DML. EIJOC1

12 views - 9 months ago