A to Z Computer Mastery Course
May 27, 2022
0
57
rating:
5.00(4 Ratings)
Enrolment validity: Lifetime
Login
Course Benefits
materials include
course content
Ratings & Reviews
course description
70% डिस्काउंट !!!! कोर्स खरीदते समय टाइप करें COUPON CODE – PC Skill
इस कोर्स में प्रोफेशनल कोर्स + कोर्स कंम्पलीशन सर्टीफिकेट भी
अगर आप कंप्यूटर मास्टर बनना चाहते हैं कंप्यूटर के हर टर्म्स के बारे में जानकारी लेना चाहते हैं जिसमें कंप्यूटर सॉफ्टवेयर से लेकर कंप्यूटर हार्डवेयर, वेब डिजाइनिंग, ग्राफिक डिजाइनिंग और ऑफिस ऑटोमेशन यह सारी चीजें शामिल हों तो यह कोर्स आपके लिए है इस कोर्स में हमने कंप्यूटर से बेसिक से लेकर एडवांस तक ढेर सारी चीजें शामिल की हैं इस कोर्स को करने के बाद आपको खुद में महसूस होगा कि आपने बहुत कुछ सीखा है यह कोर्स ए टू जेड कंप्यूटर मास्टरी कोर्स है जो आपको कंप्यूटर के बेसिक से लेकर एडवांस तक सॉफ्टवेयर से लेकर हार्डवेयर तक हर चीज के बारे में जानकारी देगा
A to Z Computer Mastery Course
A to Z Computer Masteryमें आपको बहुत सारी चीजे सिखाई जाती है, अगर आपने अभी-अभी 10वीं पास की है या फिर आप 12वीं कर रहे हैं तो आप इस कोर्स को कर सकते हैं, इस कोर्स में आपको कंप्यूटर फंडामेंटल, एम एस ऑफिस (Microsoft Office) का पूरा कोर्स, फोटोशॉप, कोरल ड्रॉ, टैली ईआरपी 9, वर्डप्रेस कंम्यूटर हार्डवेयर इत्यादि रोजगार परक कोर्स कराए जाते हैं –
A to Z Computer Mastery Course Syllabus
- कंप्यूटर फंडामेंटल (Computer Fundamental)
- माइक्रोसॉफ्ट वर्ड (Microsoft Word)
- माइक्रोसॉफ्ट एक्सल (Microsoft Excel (Beginners to Advance)
- माइक्रोसॉफ्ट पावर पॉइंट (Microsoft PowerPoint)
- माइक्रोसॉफ्ट एक्सेस (Microsoft Access)
- माइक्रोसॉफ्ट पब्लिशर (Microsoft Publisher)
- माइक्रोसॉफ्ट आउटलुक (Microsoft Outlook)
- टैली प्राइम + जीएसटी रिटर्न्स (Tally Prime with GST Returns)
- फोटोशॉप (Photoshop Full Course)
- कोरल ड्रॉ (CorelDraw Full Course)
- एक्सेल एम आई एस (Excel MIS Full Course)
- एक्सेल पावर क्वेरी (Excel Power Query Full Course)
- गूगल शीट्स (Google Sheets Full Course)
- वीडियो एडिटिंग (Video Editing Full Course)
- एचटीएमएल (HTML Full Course)
- कंम्यूटर हार्डवयेर (Computer Hardware Course)
- वेबडिजानिंग कोर्स (WordPress Blogging Course)
- एक्सेल VBA (Excel VBA Mastery )
- डाटा एंट्री कोर्स ( Data Entry Operator Course)
Course Benefits
materials include
course content
796 Lessons
Computer Fundamental
1- Computer Parts Introduction00:13:38
2- CPU Hardware Parts00:9:19
3- Desktop Icon Settings00:8:44
4- Keyboard and Mouse Information00:11:14
5- Software Installation00:9:47
6- change Computer Password00:9:17
Microsoft Word
1- Introduction00:11:56
2- Use Clipboard Group Of Home Tab00:12:32
3- Text Formatting in Microsoft Word00:5:50
4- Line and Paragraph Spacing00:8:53
5- Sort Paragraph, Bullet and Number Lists00:9:55
6- Using Find, Replace, and GoTo00:6:44
7- Page Setup and Printing00:8:31
8- How to Create Custom Cover Pages00:6:55
9- Hyperlink, Bookmark And Cross Reference00:18:55
10- Creating and Formatting Tables00:10:38
11- Insert Pictures in Word00:9:22
12- Insert ClipArt & Online Image00:5:21
13- Using Word Text Boxes00:5:44
14- Create a SmartArt Graphic00:4:27
15- Add or Edit Shapes in Microsoft Word00:6:13
16- Create or Run a Macro00:5:21
17- Create Fillable Forms00:6:07
18- Use Autocorrect in Word00:4:51
19- How to Insert Watermarks00:3:33
20- Set Default Hindi Font And Font Size00:1:48
21- Check Spelling and Grammar00:5:31
22- Perfect Text Alignment Using Tabs00:9:50
23- Add Footnote And Endnote00:4:10
24- Insert Caption in Word00:5:28
25- Insert Table of Contents00:5:58
26- Create a Bibliography, Citations, and References son00:00:00
27- Microsoft Word Best Keyboard Shortcuts00:8:47
28- Letter Format Example and Writing Tips00:9:33
29- How to Create a Resume in Word00:6:43
30- Using Mail Merge in MS Word00:6:01
31- How to Use Sum Formula in Word00:5:05
32- Create Certificate in MS Word00:00:00
33- How to Make Visiting Card00:00:00
Microsoft Excel
1- Microsoft Excel Introduction00:10:56
2- How to Work in Excel And Use Basic Formulas00:11:10
3- Use Clipboard Like Pro Full Explain00:11:57
4- Organize Row Column And Worksheet00:8:48
5- Data Entry Like Pro00:5:45
6- Create Your Own Custom List00:6:31
7- How Make Password Your Excel File00:5:55
8- How To Create a Backup File00:6:01
9- How to Use Sum Formula00:6:15
10- How to Use Skip Blanks00:3:24
11- Subtract, Multiple, Divide And Percentage00:7:57
12- Use of Number Format in Excel00:11:14
13- Use Conditional Formatting00:13:37
14- How to Sort & Filter Data8:37
15- Using Find and Replace and Using GoTo00:7:20
16- How to Use Status Bar00:7:27
17- Freeze Panes Option00:4:42
18- Split Window00:4:41
19- Fill Option00:10:51
20- Flesh Fill00:8:09
21- Pivot Table00:11:40
22- All Table Option00:11:23
23- Picture Option00:11:37
24- Use Shape00:12:24
25- Use 3D Modal00:6:04
26- Smart Art00:8:28
27- Advance Charts & Graph Charts00:6:29
28- People Graph00:3:19
29- Create Hyperlinks00:7:45
30- Header and Footer00:7:30
31- Write, Insert, or Change an Equation00:4:27
32- Using the Draw Tab00:3:45
33- How to Use Themes00:4:46
34- Complete Page Setup00:15:03
35- Scale to Fit Setup00:4:45
36- IF Formula00:5:20
37- IF Formula With Multiple Conditions00:6:36
38- Change Case and Round Figure Formula00:5:07
39- VLOOKUP Formula00:6:49
40- VLOOKUP Formula Examples00:16:30
41- HLOOKUP Formula00:00:00
42- And Formula00:00:00
43- Convert Number into Word Formula00:4:37
44- Use Macros With Examples00:8:13
45- Subtotal Formula00:00:00
46- Link Data in Excel Spreadsheets Formula00:2:58
47- Data Consolidate Formula00:00:00
48- Calculate Age With Date, Date IF Formula00:00:00
49- E-Date and Eo-Month Formula00:00:00
50- Calculating Percent Formula00:00:00
51- Superscript and subscript Formula00:00:00
52- Group Ungroup Subtotal Formula00:00:00
53- Goal Seek Formula00:00:00
54- PMT Formula00:00:00
55- Goal With PMT Formula00:1:24
56- Concat Formula00:00:00
57- INDIRECT Formula00:00:00
58- Match Formula00:00:00
59- Count, Counta, Countblank, Formula00:00:00
60- EXACT Formula00:00:00
61- Sumif Formula00:3:08
62- Sumifs Formula00:7:25
63- Round, Roundup, RoundDown, MRound Formula00:00:00
64- Array Formula00:5:28
65- LEFT, RIGHT, MID, LEN Formula00:00:00
66- Split Name Using LEFT, RIGHT, MID, LEN, Formula00:00:00
67- Mod Formula00:00:00
68- Quotient Formula00:00:00
69- Replace Formula00:00:00
70- SUBSTITUTE Formula00:00:00
71- Excel Formula Error Types00:00:00
72- SUMPRODUCT Formula00:00:00
73- Text Formula00:00:00
74- Double VLOOKUP Formula00:5:51
75- simple Interest Formula00:00:00
76- Compound Interest Formula00:00:00
77- Ceiling And Floor Formula00:00:00
78- Index Formula00:00:00
79- INDEX + MATCH Formula00:00:00
80- Forecast Formula00:00:00
81- Value Formula00:00:00
82- Most Important Keyboard Shortcut00:00:00
83- Employees Payroll and Salary Slip00:00:00
84- Daily Stock Register00:8:38
85- Dynamic Unit Converter00:00:00
86- Dynamic Dropdown List00:8:52
87- School Marksheet With Grade00:00:00
88- Make Checklist & To Do List00:5:11
89- Make Attendance Sheet00:7:19
90- Student Database With Mail Merge00:32:55
Microsoft Powerpoint
1- Powerpoint Intro00:5:08
2- Make New Slideshow in Powerpoint00:6:37
3- Add Transitions to Powerpoint00:00:00
4- Text Animation in Powerpoint00:3:44
5- Add Animations to Powerpoint00:5:08
6- Create Custom Animation00:7:08
7- Record Slide Show as a Video00:4:43
Microsoft Access
1- MS Access Part 100:9:33
2- MS Access Part -200:10:23
3- MS Access part 300:8:52
4- MS Access part 400:9:38
Microsoft Outlook
Microsoft Outlook00:9:53
Microsoft Publisher
Microsoft Publisher00:9:15
Google Sheets Full Course
1- Google Sheets Introduction00:13:15
2- Use of Function00:9:24
3- Inserting and Deleting Sheets, Navigating Sheets00:11:48
4- Paint Format, Currency Format, %Age Formula00:12:23
5- Enable Keyboard Shortcuts, Format Sheet00:8:18
6- Hyperlink and Insert Comment00:8:41
7- Share Sheets with Multiple People and Word Together00:8:24
8- Insert Chart & Format Chart – 100:10:31
9- Insert Chart & Format Chart – 200:11:31
10- Sort and Filter Options00:12:23
11- Save Filter, Create Filter00:7:29
12- Filter Formula00:7:15
13- File Menu – Save Version History Open Excel File00:10:00
14- File Menu – Publish File to Web00:6:09
15- Printing Tips00:8:20
16- Edit Menu – Paste Special00:10:16
17- Edit Menu – Find and Replace00:8:44
18- View Menu – Freeze Panes00:8:45
19- Insert Menu -1- Image, Rows. Columns00:00:00
20- Insert Menu -2- Google Forms Link to Google Sheets00:00:00
21- Insert Menu -3- Check Boxes – Create To Do Lists00:6:02
22- Format Tab – Conditional Formatting, Number Formatting00:00:00
23- Data Menu – Use of Slicers00:00:00
24- Data Menu – Data Validation00:00:00
25- Pivot Table – Create Summerize Reports00:00:00
26- Add Named Ranges and Apply Formula00:00:00
27- Google Protect Worksheet and Range00:00:00
28- Split Text to Columns, Remove Duplicates00:08:41
29- Macro Recordings00:00:00
30- Accessibility Options00:00:00
31- Mail Merge – Send Bulk Emails00:00:00
32- IFS Formula Use00:00:00
33- Text Join and Concatenate Formula00:00:00
34- Google Translate Formula00:00:00
35- Vlookup and Hlookup in Google Sheet00:00:00
36- Countif, Countifs, Sumif, Sumifs00:00:00
37- Sumif, Sumifs, Formula in Google Sheet00:00:00
38- Count Unique IFS New Formula00:00:00
39- Sparklines Formula Bar Columnline Chart00:00:00
40- All IsFormula – Isemail, IsNumber, Istext00:00:00
41- Create QR Code Using Formula00:00:00
42- All Useful Text Formula00:00:00
43- All Useful Number Formulas00:00:00
44- Get Unique Record00:00:00
45- Use of Query Formula – Remove Blanks00:00:00
46- Import Data From Web00:00:00
47- Merge Sheets Data00:00:00
48- Merge Workbooks00:00:00
49- Remove Blank Rows Tricks00:6:13
50- Offset Formula Introduction00:00:00
51- Real Use of Offset Formula00:00:00
52- Created Monthly Report Dashboard00:00:00
53- Sequence and Rand Formulas00:00:00
54- Unique Rank Formula – 100:00:00
55- Send Auto Email – Add-Ons -100:00:00
56- Copy Down Formula Add-Ons00:00:00
57- Query Formula – 100:00:00
58- Query Formula – 200:00:00
59- Query Formula – 300:00:00
60- Project on Query Formula00:00:00
Tally Prime Course
1- Download and Install Tally Prime00:9:54
2- Create Company in Tally Prime00:12:53
3- Alter Company Data00:00:00
4- Tally Vault Password00:00:00
5- Tally Company Configuration00:00:00
6- Tally Create Users & Security00:00:00
7- View Tally Reports in Mobile / Browser00:00:00
8- What is Accounting Explain in Hindi00:00:00
9- What is Financial Year00:00:00
10- Create, Alter and Delete Group00:00:00
11- Create Ledgers in Tally Prime00:00:00
12- Create Multiple Ledgers in Tally Prime00:00:00
13- Different Ledgers and Their Meanings in Tally00:00:00
14- Business First Voucher Entry in Tally00:00:00
15- Receipt Voucher – Goods Sold on cash00:5:39
16- Receipt Voucher – Amount Received in Cash00:00:00
17- Receipt Voucher – Amount Received in Cheque00:00:00
18- Contra Voucher – 100:00:00
19- Contra Voucher – 200:00:00
20- Payment Voucher00:00:00
21- Payment Voucher00:00:00
22- Purchase Voucher00:00:00
23- Sales Voucher00:00:00
24- After Purchase Sales00:00:00
25- Journal Voucher00:00:00
26- Adjustment Entries – 100:00:00
27- Adjustment Entries -200:00:00
28- Purchase Return And Sales Return00:00:00
29- Assignment on Voucher Entries – 100:00:00
30- Assignment on Voucher Entries -200:00:00
31- Assignment on Voucher Entries – 300:00:00
32- What is Accounting Cycle00:00:00
33- What is Balance Sheet00:00:00
34- Stock Entries – 100:00:00
35- Stock Entries – 200:00:00
36- Stock Entries – 300:00:00
37- Stock Entries – 400:00:00
38- Cost Centers Introduction – 100:00:00
39- Cost Centers Hide Details00:00:00
40- Cost Centers Example – 100:00:00
41- Cost Centers Example – 200:00:00
42- Keyboard Shortcuts00:00:00
43- Multiple Stock Item Entries00:00:00
44- Stock Transfer – Stock Journal Vouchers00:00:00
45- Physical Stock Voucher00:00:00
46- Organization Types00:00:00
47- Trading Organization Accounting00:00:00
48- Purchase Order00:00:00
49- Receipt Note Voucher00:00:00
50- Rejection Out Voucher00:00:00
51- Purchase Invoice00:00:00
52- Debit Note – Purchase Return00:00:00
53- Sales Order00:00:00
54- Delivery Note -100:00:00
55- Rejection In – 100:00:00
56- Create Sales Bill – 100:00:00
57- Credit Note – Sales Return – 100:00:00
58- TDS Introduction – 100:14:40
59- TDS Introduction – 200:00:00
60- TDS on Interest00:00:00
61- Frequently Ask Questions00:00:00
62- TDS Entry in Tally00:00:00
63- TDS Adjustment Entries00:00:00
64- TDS Certificate – 100:00:00
65- TDS Related Questions00:00:00
66- TDS Entry as a Deductor 100:00:00
67- TDS Entry As a Deductor – 200:00:00
68- TDS Entry As a Deductor -300:00:00
69- TDS Entry As a Deductor -400:00:00
70- TDS Payment -100:00:00
71- GST Introduction00:00:00
72- SGST, CGST, and IGST Terms00:00:00
73- GST – What is HSN and SAC00:00:00
74- What is Regular Dealer and Composition00:00:00
75- Create Purchase Invoice Intrastate GST00:00:00
76- Create Purchase Invoice Interstate GST00:00:00
77- Check Stock and Purchase Register00:00:00
78- Create Sales Invoice Instrastate GST00:00:00
79- Create Sales Invoice Interstate GST00:00:00
80- Check Sales Register and Stock Summery00:00:00
81- GSTR1, GSTR2, GSTR3B00:00:00
82- What is E-Way Bill00:00:00
83- Genterate JSON of E-Way Bill00:00:00
84- Purchase RAW Material00:00:00
85- Create BOM (Bill of Material)00:00:00
86- Create Manufacturing Journal00:00:00
87- Sold Finish Goods00:00:00
88- Introduction of Service Organization00:00:00
89- Introduce Capital in Service Sector00:00:00
90- Purchased Fixed Assets With GST Invoice00:00:00
91- Purchased Stationery With GST Invoice00:00:00
92- Purchased Computers GST Invoice00:00:00
93- Taken Advertisement Service00:00:00
94- Provide Service and Received Payment – 100:00:00
95- Provide Service and Received Payment -200:00:00
96- Sales Service and Received Payment – 300:00:00
97- View Reports of Service Sectors00:00:00
98- Customize Sales Invoice Number00:00:00
99- Compound Unit and Alternate Unit00:00:00
100- Backup and Restore DATA00:00:00
101- Import and Export00:00:00
102- Export Data in Excel00:00:00
103- Payroll Introduction00:00:00
104- Create Employee Record00:00:00
105- Create Work Unit00:00:00
106- Create Earning Panhead00:00:00
107- Create Earning Payhead -200:00:00
108- Create Deduction Panhead00:00:00
109- Define Salary Structure00:00:00
110- Create Payroll Voucher00:00:00
111- GST Registration Process00:00:00
112- Export Data in CSV From Tally00:00:00
113- Create JSON File With GST Offline Tool00:00:00
114- Filling Gstr 1 (Sales) on GST Portal00:00:00
115- Making Payment on GST Portal Filling GSTR3B00:00:00
Tally ERP 9 Tutorial For Beginners
1- How to Download and Install Tally Software00:12:34
2- Create Company in Tally00:19:51
3- Shut Company and Select Company00:8:50
4- Delete Company and Change Company Information00:7:05
5- How to Create Password Protected Company00:00:00
6- Create Multiple Ledgers in Tally00:00:00
7- What is Accounting00:00:00
8- What is Financial Year, Assets, Debtors and Creditors00:00:00
9- Create Group in Tally00:00:00
10- Alter, Delete Group in Tally00:00:00
11- Create Ledger in Tally00:00:00
12- Create Multiple Ledgers in Tally00:00:00
13- Different Ledgers and Their Meanings in Tally00:00:00
14- Voucher Entries – Business First Voucher Entry00:00:00
15- Voucher Entries – Sold Goods on Cash00:00:00
16- Voucher Entries – Amount Received by Cheque00:00:00
17- Voucher Entries – Amount Received in cash00:00:00
18- Voucher Entries – Contra Voucher00:00:00
19- Voucher Entries – Contra Voucher 200:00:00
20- Voucher Entries – Payment Voucher00:00:00
21- Voucher Entries – Payment Voucher 200:00:00
22- Voucher Entries – Purchase Voucher00:00:00
23- Voucher Entries – Sales Voucher00:00:00
24- Voucher Entries – Purchase , Sales Report00:00:00
25- Voucher Entries – Journal Voucher00:00:00
26- Voucher Entries – JV Adjustment Entries00:00:00
27- Adjustment of Stationery Expenses00:00:00
28- Adjustment of Purchase Return and Sales Return00:00:00
29- Voucher Entries Practice -100:00:00
30- Voucher Entries Practice -200:00:00
31- Voucher Entries part -300:00:00
32- What is Accounting Cycle00:00:00
33- What is Balance Sheet00:00:00
34- Stock Entries – 100:00:00
35- Stock Entries – 200:00:00
36- Stock Entries – 300:00:00
37- Cost Centre’s in Tally00:00:00
38- Cost Centre’s in Tally -200:00:00
39- Cost Centre’s in Tally -300:5:08
40- Basic Tally Keyboard Shortcuts00:9:58
41- Trading Organization Accounting -100:00:00
42- Trading Organization Accounting -200:00:00
CorelDRAW Full Course
1- CorelDRAW Introduction00:4:42
2- Work Space Introduction00:12:19
3- Basic Settings00:00:00
4- How To Use Pick Tool00:00:00
5- How To Use Shape Tool00:00:00
6- How To Make Simple Logo00:00:00
7- How To Use Knife Tool00:00:00
8- Steps To Align Objects00:00:00
9- How To Merge Object00:00:00
10- Corel Draw Power Clip00:00:00
11- How To Use Envelope Tool00:00:00
12- Use 3D Text00:00:00
13- How To Use Blend Tool00:00:00
14- Text Setting Corel Draw00:00:00
15- How To Use Shape Tool00:00:00
16-How To Use Crop Tool00:00:00
17- How To Make Star Logo00:00:00
18- Interactive & Smart Fill option00:00:00
19- How To Use Clone Tool00:00:00
20- How To Use Freehand Tool00:00:00
21- How To Use Artistic Tool00:00:00
22- Livesketch & Smart Drawing Tool00:00:00
23- Rectangle & Ellipse Tool00:00:00
24-How To Use Polygon & Sprial Tool00:00:00
25-How To Use Impact Tool00:00:00
Photoshop Full Course
1- Introduction Adobe Photoshop CC 202100:12:44
2- Layer and Selection00:00:00
3- More Selections00:16:20
4- Magic Wand Tool00:10:37
5- Use of Feather00:7:55
6- Use Crop Tool00:6:01
7- Passport Size Photo Making00:7:05
8- Brush Tool00:11:49
9- Clone Stamp Tool00:10:24
10- Healing Tools00:8:13
11- Content Aware Fill & Move Tool00:5:08
12- Eraser Tools00:6:28
13- Blur Sharpen & Smudge Tools00:00:00
14- Layer Mask00:00:00
15- Black & White With Color00:11:17
16- History Brush00:00:00
17- Gradients00:00:00
18- Pen Tool and Path00:00:00
19- Define Pattern00:00:00
20- Use of Shapes00:00:00
21- Text Effects00:00:00
22- Clipping Mask00:00:00
23- Dodge, Burn, Sponge Tool00:00:00
24- File Menu00:00:00
25- Printing Tips00:9:36
26- Sky Replacement00:00:00
27- Vanishing Point00:00:00
28- Face Aware Liquify00:00:00
29- Puppet Warp00:00:00
30- Extract Hair00:00:00
31- Record An Action00:00:00
32- Create YouTube Thumbnail00:00:00
33- Create Glow Effect00:8:18
HTML Full Course
1- HTML Introduction00:10:40
2- Write First Program in HTML00:00:00
3- Heading Tag in HTML00:00:00
4- Indent and Comment00:00:00
5- Element and Attribute00:00:00
6- Formatting Tag00:00:00
7- Paragraph and Preadmitted Tag00:00:00
8- HTML Font Tag00:00:00
9- Quantitation and Citation00:00:00
10- External Hyperlink00:00:00
11- Internal Hyperlink00:00:00
12- HTML Image Tag00:00:00
13- Hyperlink on Images00:00:00
14- List Tag in HTML00:00:00
15- Nested List Tag00:00:00
16- Maquee Tag00:00:00
17- Marquee on Image00:00:00
18- HTML Color Code00:00:00
19- HTML Table Tag 100:00:00
20- HTML Table Tag 200:00:00
21- Video and Audio Tag00:00:00
22- Google Map , YouTube Video Tag00:00:00
23- iFrame Tag00:00:00
24- Add PDF Code00:00:00
25- HTML DIV and Span Tag00:00:00
26- Use of Code Editor00:00:00
27- Entities, Symbol And Emojis00:00:00
28- Semantic And Non-Semantic00:00:00
29- Responsive00:00:00
30 – Learn Image Map In HTML00:00:00
31 – Form In HTML00:00:00
32 – HTML – Forms – 200:00:00
33 – HTML – Radio Button – Checkbox00:00:00
34 – HTML – Create Data list in Forms00:00:00
35 – HTML – Output Elements in Forms00:00:00
36 – HTML – Field set and Legend00:00:00
37 – HTML – Extra Elements00:00:00
38 – HTML – SEO Elements00:00:00
39 – HTML – Add Favicon00:00:00
40 – HTML – Use of VS Code Editor in Detail00:00:00
Excel Power Query Beginner to Advance
1- Introduction and Installation00:6:42
2- Create Connections With Excel Table00:00:00
3- Create Connections with Text File And Access Database00:00:00
4- Reconnect Data in Power Query00:00:00
5- Create Pivot Table on Multiple Sheets00:00:00
6- Merge Multiple Sheets Using M Language00:00:00
7- Create Pivot Table on Multiple Sheets00:00:00
8- Close and Load to Explain – Home Tab – Query Group00:00:00
9- Home Tab – Manage Column and Rows Group00:00:00
10- Home Tab – Split Column into Rows and Columns00:00:00
11- Home Tab – Group By Using Basic and Advance Option00:00:00
12- Home Tab – Data Type & Replace Values00:00:00
13- Transform Data Dynamically00:00:00
14- Combine 1000+ Tables With 1 Function00:00:00
15- Alternate Options of Vlookup inside Power Query00:00:00
16- Multiple Columns Lookup00:00:00
17- Remove Weekends and Holidays00:00:00
18- Calculate Age With Simple Method00:00:00
19- Calculate Task Timings00:00:00
20- Add Column Date Options in Detail00:00:00
21- Time And Duration Options in Details00:00:00
22- Transform Raw Data – Real Job Query00:00:00
23- Few Clicks to get Trim, Propercase and Merge Data00:00:00
24- Merge Workbooks and Create Pivot00:00:00
25- Merge Workbooks with File Name as Column00:00:00
26- Raw Data to Pivot00:00:00
27- Merge Vs Append00:00:00
Excel MIS Beginner to Advance
1- Pivot Table Introduction00:00:00
2- Pivot Table and Pivot Chart00:00:00
3- Design Tab of Pivot Chart00:00:00
4- Slicer in Pivot Table & Slicer Settings00:00:00
5- Time Line in Pivot Table00:00:00
6- Get Pivot Data in Excel00:00:00
7- Pareto Chart in Excel00:00:00
8- INFOGRAPHIC CHART IN EXCEL00:00:00
9- Trend Chart Using SumIFS Formula00:00:00
10- Map Chart Using XY Scatter Chart00:00:00
11- Key Performance Indicator in Excel00:00:00
12- Chart With Hyperlink00:00:00
13- Chart With Conditional Formatting00:00:00
14- Create Bar Charts With Pictures MIS Series00:00:00
15- Speedometer Chart in Excel00:00:00
16- See Saw Comparison Chart00:00:00
17- Hyperlink With Column and Pie-Chart00:00:00
18- Male, Female Comparison Chart00:00:00
19- Create Dynamic Month Dashboard Using Offset Formula00:00:00
20- Create Dashboard on Day Wise Report00:00:00
21- Sales Ranking Dashboard00:00:00
22- Create Weekly Sales Dashboard Using Listbox00:00:00
23- Daily Task Reminder Dashboard00:00:00
24- Create Year Wise Report Using Vlookup, Match, Index00:00:00
25- Create Dashboard Using VLOOKUP, INDEX, COUNTIF00:00:00
26- Amazing Dashboard00:00:00
27- Time Dashboard Project00:23:37
28- Gantt Chart With Conditional Formatting00:10:46
Filmora Video Editing Tutorial
1- Filmora Introduction00:6:27
2- Record Computer Screen00:6:09
3- How to Edit Video00:00:00
4- How to merge Two Video Clip00:00:00
5- How to Adjust Light And Brightness00:00:00
6- Enhance Audio Quality00:00:00
7- Save and Edit Project00:00:00
8- How to Add Title And Lower Third00:00:00
9- Add Scrolling Line in Video00:00:00
10- Add Layer on Video00:00:00
11- Add Background Sound Effect00:00:00
12- Add Transition in Video00:00:00
13- How to Use Effect Feature00:00:00
14- How to Use Element Feature00:8:54
15- How to Use Split Screen Feature00:00:00
16- How to Use Green Screen and Chroma Key Feature00:00:00
17- How to Export Video And Setting00:00:00
18- How to Stabilize a Video00:00:00
19- How to Use Crop & Pan and Zoom00:00:00
20- How to Add Popup Effect00:00:00
Computer Hardware Tutorial
1- Introduction00:11:38
2- Input Devices00:4:15
3- Output Devices00:3:16
4- CPU Back Panel00:7:54
5- Open Cabinate00:7:07
6- Remove Hard Disk Drive00:3:18
7- Hard Disk Internal Parts00:5:47
8- Remove SMPS00:3:16
9- Remove Motherboard00:4:27
10- Parts of Motherboard00:5:13
11- Remove CPU Fan00:2:08
12- Remove CPU00:3:09
13- Assemble CPU00:00:00
14- Assemble CPU Fan00:00:00
15- Motherboard North Bridge & South Bridge00:5:18
16- Hardware Assemble00:00:00
17- Front Panel Connection00:00:00
18- Assemble Completer PC00:00:00
19- Make Bootable Pendrive00:13:58
20- What is Booting on Computer00:5:25
21- BIOS Setting00:5:20
22- How to install Window 700:10:50
23- How to install Window 1100:6:52
24- How to Install Driver on Computer00:9:53
25- Display Resolution Setting00:5:01
26- Software Install or Install Process00:13:28
27- Hard Disk Partition Process00:14:12
28- Install Windows 11 By Virtual PC00:13:25
29- Setting To Speed of Windows00:10:11
30- Create Password Reset Disk00:00:00
31- All Keyboard Shortcuts for Windows00:29:05
Excel VBA Mastery Course
1- Introduction00:24:27
2- What is Variable and Data Type00:00:00
3- Sheets And Cell Selection00:00:00
4- Dynamic Copy Code of VBA00:00:00
5- Offset Command00:00:00
6- Project on Copy Paste00:00:00
7- Input Box and Message Box00:00:00
8- Variable Types00:00:00
9- Option Exclicit00:00:00
10- IF condition00:00:00
11- IF Condition With And00:00:00
12- IF Condition With OR00:00:00
13- Nested IF Condition00:00:00
14- VBA Project on IF00:00:00
15- For Next Loop00:00:00
16- For Loop Decrement Method00:00:00
17- Do While Loop00:00:00
18- Do Untill Loop00:00:00
19- For Loop Project Add Alternate Blank Rows00:00:00
20- For Loop Project Remove Blank Rows00:00:00
21- For Loop Project Insert Number of Rows and Columns00:00:00
22- Error Handler00:00:00
23- Do While Loop With Nested IF Project00:00:00
24- For Loop With Nested IF Project00:00:00
25- Merge Sheets Using For Loops00:00:00
26- Create Index Using for Loop00:00:00
27- Type of Msg Box00:00:00
28- Use of Yes, No Type Msg Box00:00:00
29- Select Range Using Input Box00:00:00
30- For Each Loop00:00:00
31- Method of Adding Worksheets00:00:00
32- Insert N Number of Sheets00:00:00
33- Method of Deleting Sheets00:00:00
34- VBA Using For Loop Delete Multiple Sheets00:00:00
35- What is Object and Class00:00:00
36- Collection of Loop00:00:00
37- Delete Blank Sheets For Each Loop00:00:00
38- Collection Loop For Each Cell00:00:00
39- Collection Loop Interview Question00:00:00
40- Workbook Commands00:00:00
41- Workbook protection Command00:00:00
42- List of Worksheets for Workbook00:00:00
43- Open All Workbook From Specific Folder00:00:00
44- Find Workbook00:00:00
45- Deleting Unwanted Workbook00:00:00
46- Protect All Sheets Using Loop00:00:00
47- Protect Unprotect Set Custom Password00:00:00
48- Collection Loop From Workbook00:00:00
49- Nested Loop00:00:00
50- Nested Loop Assignment00:00:00
51- Array Introduction00:00:00
52- Array in Loop00:00:00
53- List of Arrays00:00:00
54- List of Arrays00:00:00
55- Comparing 3 LIst Using Arrays00:00:00
56- Start Point of Arrays00:00:00
57- Dynamic Array00:00:00
58- Array Project Rename Sheet00:00:00
59- Project find and Delete Using Array00:00:00
60- Lbound and Ubound in Array00:00:00
61- Array From Range00:00:00
62- Two Dimensional Array00:00:00
63- Dynamic Two Dimensional Array00:00:00
64- VBA Project on Array With VLOOKUP Function00:00:00
65- Text Function in VBA00:00:00
66- Find and Left Practical Use00:00:00
67- Find With Right and Mid Practical Use00:00:00
68- INSTR and Replace Function00:00:00
69- String Comparison00:00:00
70- Change Case Function00:00:00
71- IsNumeric Function Practical Use00:00:00
72- SUMIF Function00:00:00
73- SUMIFS Function00:00:00
74- Countif and Countifs Function00:00:00
75- Vlookup Function00:00:00
76- Match Function00:00:00
77- Autorun Vlookup Event00:00:00
78- Date Functions00:00:00
79- DateDiff and Datepart Function00:00:00
80- Project on DataDiff Function00:00:00
81- All Date and Time Functions00:00:00
82- CASE Function00:00:00
83- Introduction of UDF00:00:00
84- Create Get Text Function00:00:00
85- Create Get Numbers Function00:00:00
86- Project on Separate Names00:00:00
87- M Vlookup for Multiple Values00:00:00
88- Combine Function Extract Text and Numbers00:00:00
89- Reverse Lookup00:00:00
90- Reverse Lookup Using Index Code00:00:00
91- Userform Introduction00:00:00
92- Userform Label and Text Box Properties00:00:00
93- Userform Use of Command Button00:00:00
94- Submit Data to Excel Using Userform00:00:00
95- Userform Events and Text Box Events00:00:00
96- Userform Use of Combobox00:00:00
97- Userform Listbox00:00:00
98- Userform Checkque box00:00:00
99- Userform Use of Option Button00:00:00
100- Adding Image in Userform – 100:00:00
101- Adding Image in Userform – 200:00:00
102- Adding Image in Userform – 300:00:00
103- VBA Outlook Configure With Gmail00:00:00
104- Sending Email through Outlook00:00:00
105- Outlook Email With Attachment00:00:00
106- Outlook Send Bulk Email00:00:00
107- Outlook Send Bulk Email With Attachments00:00:00
108- VBA – Web Scarping Introduction00:00:00
109- Web Scraping Loop until Ready State00:00:00
110- Web Scraping Get Data from Website00:00:00
111- Web Scraping Get Data From Website – 200:00:00
112- Web Scraping Get all Links00:00:00
113- Web Scraping Get Exact Data from Website00:00:00
114- Change Event00:00:00
115- Events Auto Filter Using Macro00:00:00
116- Basic Events00:00:00
117- Create Ads-ins-Add Picture in Comment Box00:00:00
118- Get Grace Marks Amazing Project00:00:00
119- VBA Assignment-For Loop and if Assignment00:00:00
120- OMR Sheets Assignment00:00:00
121- Interview Question UDF of Reserve Text00:00:00
122- VBA – Interview Questions00:00:00
WordPress Blogging Course
1- Introduction00:2:10
2- Blog क्या है ?00:5:04
3- सबसे ज्यादा पैसा कमाने वाले Topics/Niche00:10:53
4- अपना ब्लॉग टॉपिक ऐसे चुनें00:00:00
5- एक टॉपिक और अनेक टॉपिक वाले ब्लॉग00:6:44
6- Hosting Kya Hai00:00:00
7- Domain Name00:00:00
8- Purchasing Hosting Domain and Installing WordPress00:00:00
9- Installing WordPress With Mobile Phone00:00:00
10- How to Install SSL Certificate00:00:00
11- WordPress Dashboard00:00:00
12- How to Install theme in WordPress00:00:00
13- How to Install Plugin00:00:00
14- Most Important Plugin00:00:00
15- Best Comments Plugin for WordPress00:00:00
16- WordPress Widgets00:00:00
17- User Registration WordPress00:00:00
18- Google Search Console00:00:00
19- How to Create Menu in WordPress00:00:00
20- Installing Push Notification00:00:00
21-How to Make Logo for Website00:00:00
22- WordPress Website Customize Kaise kare00:00:00
23- Voice Typing in WordPress00:00:00
24- What is Google AMP00:00:00
25- How to Block any IP in WordPress00:00:00
26- How to Change PHP Version on WordPress00:00:00
27- How to Upload External Media Directly on WordPress00:00:00
28- How to Increase Speed in WordPress Website00:00:00
29- How to Delete Unused Tables From WordPress Database00:00:00
30- How to Embed Facebook Video on WordPress Site00:00:00
31- How to Disable Auto ADS on Specific Pages00:00:00
32- WRITING A POST00:00:00
33- Trick For Blog Writing Blog Likhna Sikhen00:00:00
34- Featured Image कैैसे बनाऍं ?00:00:00
35- Unique Content कैैसें बनाऍं ?00:00:00
36- Blog Post के लिए अच्छा Title कैसें लिखें ?00:00:00
37- Best Post Ideas ( जब पोस्ट बनाने का Idea न आ रहा हो )00:00:00
38- Blog Post का Intro कैसें लिखें ?00:00:00
39- Fast Ranking Post on Google00:00:00
40- How to Format Your Blog00:00:00
41- Faq Post Kaise Banaye00:00:00
42- Apna Content Copy Hone Se Kaise Bachayen00:00:00
43- Google से ट्रेफिक लाने के लिए सबसे जरूरी चीज00:00:00
44- SEO का Basic ( Intent Search )00:00:00
45- सबसे आसान SEO करने का तरीका00:00:00
46- SEO Friendly URL Research00:00:00
47- How to Optimize for Voice Search00:00:00
48- Blog Pr Traffic Kaise Badaye00:00:00
49- Hindi Keyboard Search and Placement00:00:00
50- SEO Misconception and SEO Myth00:00:00
51- Pinterest Traffic to Blog00:00:00
52- Google Question Hub Se Traffic Kaise Layen00:00:00
53- Google Ko Sitemap कैसेंं Submit करें ?00:00:00
54- ब्लॉगिंग से पैसे कमाने हैं ?00:00:00
55- बिना ADS के ब्लॉग से पैसे कैसे कमाते हैं ?00:00:00
56-Adsense Approval एक बार में ही कैसे लें00:00:00
57- How Much You Can Earn With a Blog00:00:00
58- How to Re-Engage Your Visitor00:00:00
59- Future For Hindi Blogging00:00:00
60- Top 15 Useful Website For Bloggers00:00:00
61- ये गलतियाँँ नहींं करनी हैं00:00:00
62- How to Become Professional Blogger00:00:00
63- Kya Aap Blogging Ke Liye Late Ho Gaye Hai00:00:00
64- Blogger Vs WordPress00:00:00
65- Creative Commons क्या होता हैं ?00:00:00
66- Blogging के 9 सबसे जबर्दस्त राज00:00:00
67- EU Copyright Law00:00:00
68- News Website कैसे बनाऍं00:00:00
69- WordPress Website को Android App में कैसें Convert करें00:00:00
70- How to Make Best Educational Blog00:00:00
Data Entry Course
1- Microsoft Excel Introduction00:10:56
2- How to Work in Excel And Use Basic Formulas00:11:10
3- Use Clipboard Like Pro Full Explain00:11:57
4- Organize Row Column And Worksheet00:8:48
5- Data Entry Like Pro00:5:45
6- Create Your Own Custom List00:6:31
7- How Make Password Your Excel File00:00:00
8- How To Create a Backup File00:00:00
9- How to Use Sum Formula00:00:00
10- How to Use Skip Blanks00:00:00
11- Subtract, Multiple, Divide And Percentage00:7:58
12- Use of Number Format in Excel00:00:00
13- Use Conditional Formatting00:00:00
14- How to Sort & Filter Data00:00:00
15- Using Find and Replace and Using GoTo00:00:00
16- How to Use Status Bar00:00:00
17- Freeze Panes Option00:00:00
18- Split Window00:00:00
19- Fill Option00:00:00
20- Header and Footer00:00:00
21- Most Important Keyboard Shortcut00:00:00
22- Complete Page Setup & Print00:00:00
23- Power Point Intro00:00:00
24- Make New Slideshow in powerpoint00:00:00
25- Add Transition to powerpoint00:00:00
26- Text Animation in Powerpoint00:00:00
27- Add Animations to powerpoint00:00:00
28- Create Custom Animation00:00:00
29- Record Slide Show as a Video00:00:00
30- Introduction to MS Word00:00:00
31- Use Clipboard Group of Home Tab00:00:00
32- Text Formatting in MS Word00:00:00
33- Using Mail Merge in MS Word00:00:00
34- Creating and Formatting Tables00:00:00
35- Check Spelling and Grammar00:00:00
36- Insert Pictures in Word00:00:00
37- Sort, Paragraph, Bullet and Number List00:9:55
38- Hindi Typing 100:7:22
39- Hindi Typing 200:5:13
40- Hindi Typing 300:00:00
41- Hindi Typing 400:00:00
Student Ratings & Reviews
5.0
Total 4 Ratings
5
4 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating
Sunil Tripathi
2 months ago
कंप्यूटर कोर्स करने के लिए pcskill एप बहुत अच्छा है
सर बहुत अच्छी तरह समझाते है
🙏🙏🙏🙏🙏
Ashutosh Pandey
3 months ago
App thik chal rha hai
Ishwar Kumar
3 months ago
Abhi full video chal rhe hai