Computer Basics (Windows 10)
1 What is Computer – An Introduction08:33
2. Computer Input and OutPut Devices01:59
3 Icons Settings – Enabling and Disabling Icons on Desktops05:53
4 Auto-Hide Task Bar – Task bar controlling02:18
5. Notification Area Settings03:54
6. How to Change Desktop Background, Set Picture, Solid Color and Slideshow08:43
7. How to Create Files and Folders03:49
8. Delete Functions – Temporary and Permanent Delete03:49
9. How to Check System Configuration, CPU, Ram, HDD, Background Application and More07:32
10. Device Manager – Learn How to Enable and Disable Devices of a Computer03:37
11. Account Login Settings – Enable and Disable Security04:35
12. System Cleanup – Temp, Recent, Recycle bin cleaning06:02
13. How to Calculator – Different type of calculations.mp402:53
14. How to Launch Paint and Painting Tools02:18
15. How to Make Partitions in Disk Drives04:37
Microsoft Word
0. MS Word-Intro-English.mp405:44
1. MS Word – Learn How to Launch MS Word04:43
2. MS Word – User Interface.mp406:45
3. MS Word English – Save and Save As.mp403:42
4 Home Tab -Font Group Commands12:33
5 MS Word-Bullets and Numbering03:48
6. Microsoft Word – Multi List Level06:16
7. Microsoft Word Text Alignments – Line and Paragraph Spacing.mp403:19
8. Microsoft Word – SORT Command Functionality02:02
9. Microsoft Word – Color Shading and Text Borders02:44
10. MS Word – Text Styles and Table of Contents I known as Index11:08
11. MS Word – Find and Replace03:25
12. MS Word – Copy Paste Functions.mp405:25
13. MS Word – Insert Table – Pages Group – Page Cover and Blank Page and Page Break04:44
14. MS Word – Table – All Table Tools Explained.mp422:39
15. MS Word – Insert Pictures and Edit Pictures.mp408:21
16. MS Word – Shapes, Icons, 3D Models Explained.mp405:24
17. MS Word – Smart Art, Charts and Screenshot utilities.mp406:14
18. MS Word – Links to WebPages.mp403:49
19. MS Word – Links to Existing Files.mp404:36
20. MS Word-Book Marks and HyperLinks.mp404:40
21. MS Word-Comments.mp404:53
22. MS Word-Headers Footers and Page Numbers.mp406:08
23. MS Word-How to Insert Objects05:32
24. MS Word-Symbols.mp403:00
25. MS Word-Insert Text from File.mp401:38
26. MS Word-WaterMarks.mp404:01
27. MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation and more.mp406:00
28. MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward.mp403:11
29. MS Word-Page Borders, Page Colors.mp405:47
30. MS Word- Mail Merge – Complete Process with Real Time Mails and Documents.mp409:18
31. MS Word-Review-Spelling and Grammar-Set Proofing Language.mp404:56
32. MS Word-Review-Thesaurus and Word Count.mp403:16
33. MS Word-Review-Auto Correct and Short Forms.mp403:24
34. MS Word-Review-Check Accessibility.mp402:56
35. MS Word-Review-Translate.mp402:13
36. MS Word-Review- Disable Auto-Hyper Links.mp401:28
37. MS Word-Review-Track Changes.mp404:49
38. MS Word-View Tab Commands.mp406:32
39. MS Word-Protection-Document Protection and Data Protection.mp403:54
Microsoft Excel
1. MS Excel – Launching – Basics of Excel Main Dashboard, Interface06:47
2 MS Excel – Cells, Rows, Columns and Sheets Basics05:51
3 MS EXCEL – Home Tab Basics – Editing and Formatting19:36
4 Copy Paste Functions – All Types05:53
5 Home Tab- Customization of Tabs04:52
6 MS Excel – Speak Cells03:44
7 Text to Columns – MS Excel Split Tool04:20
8 Characteristics of a Cell and Cell References08:35
9. Comments in MS Excel – Insert, Edit, Paste and Customize Comment Background.mp407:16
10. Fill Series – Basics – Fill Data only, Fill Format, Fill Weekdays and more02:53
11. Fill Series-Advanced – Fill Interval, Custom Lists and Fill side04:59
12. Fill Series – Flash Fill05:56
13. MS Excel-How to Hide and Unhide Rows Columns Sheets05:53
14. Freeze_Panes-Top Row Columns & Multiple Rows & Columns06:09
15. MS Excel-Filters-Learn How to Use Filter to analysis a Big Data07:31
16. MS Excel- Split Sheet Window03:12
17. MS Excel-How to Insert & Delete Cells Rows and Columns07:25
18. MS Excel-Working with Sheets06:53
19. MS Excel-View Sheets Side by Side from One Excel File04:12
20. MS Excel- Workbook Protection- Learn how to setup a Password to open Excel File03:51
21. MS Excel- sheet & cells protection05:14
22. MS Excel – Concatenate-Join Multiple Text Strings into ONE01:12
23. MS Excel-Trim_Functions- Remove unnecessary Elements from strings01:23
24. MS Excel- Print Formulas – Left Right Middle03:32
25. MS Excel – Date Related Formulas03:13
26. MS Excel-Print Page Setup Margins Size Excel to PDF08:41
27. MS Excel-Page Header & Footer Add Page Numbers Logo Report Name Date Time & more06:39
28. MS Excel – Conditional Formatting05:18
29. MS excel -import data from web05:13
30. MS Excel-import data from text document with auto refresh03:14
31. MS Excel-import-text word ppt jpeg video- pdf & more objects09:14
32. MS Excel-format multiple sheets at a time04:59
33. MS Excel – HyperLinks – Links to Sheet-File-WebPages and more.mp408:51
34. MS Excel Logical Functions Test Functions03:28
35. MS Excel IF formulas – IF – IFand – IFor – nestedIF – IFerror19:49
36. MS Excel – Student Marksheet Calculation using Sum, Nested IF, Rank, Status avg and more17:00
37. V Lookup – Exact Match and Approximate Match12:10
38. MS Excel – H Lookup03:53
39. MS Excel – X Lookup – Download and Add to your Excel03:24
40. X Look up – Basics01:06
41. MS Excel – Xlookup Formula06:22
42. MS Excel – EMI and Loan Statement Preparation – PMT PPMT IPMT14:38
43. MS Excel – DropDownList Creation – Dependent List – Independent List – Data Validation11:51
44. Data Validation – Date-List-Whole Number – Text Length-Nested If-Ifs and more24:23
45. Macro part- Designing a form05:10
46. Macro Part2 – Recording and Running a Macro14:25
47._VBA_&_Macro_Introduction01:05
48. 3D SUM – Calculate Multiple Sheet and analyze04:14
49. CONSOLIDATE – 3D SUM EXTENSION04:04
50. Age Calculator – Exclusive and Inclusive04:07
51. BAR CODE GENERATOR in MS Excel04:10
52. Charts – Pie Charts07:07
53. Charts – Bar Charts and Column Charts08:40
54. Auditing Tools – Trace Precedents-Dependent-Show Formula and more05:47
55. Statistical Formulas – Sum-Sumif-sumifs-avg-avgif-avgifs-count-countif-countifs15:33
56. INDEX03:40
57. MATCH01:44
58. PIVOT tables basics00:47
59. Create_a_PivotChart_from_Table_&_Pivot_Table01:01
60. Pivot_Table_-_Use_slicers_to_filter_data01:07
61. Sales Register Maintenance24:11
62. commission calculation06:29
63. Attendance Sheet Preparation09:36
64. Salary Calculation06:02
65. Creating Professional Invoice in Excel13:21
66. 2D Geographic Charts – Map Chart Basics03:05
67. 2D MAPS – ADVANCED08:03
68. 3D Maps – Make scenes – Export Video – Time Lapse15:25
69. 3D MAPS – State wise Product Sale03:30
Microsoft PowerPoint
1. How to Launch Microsoft PowerPoint05:05
2. An introduction to user Interface06:51
3. MS Power Point – Design Slide Background04:38
4. MS PPT – Transition Basics04:38
5. MS PPT – Animations07:24
6. Text Gradient Effects04:22
8. PROJECT -1 – Department of Tourism19:25
Internet & Mailings
2. Learn How to Create G-Mail Account.mp404:31
4. Mail – Text Format, Editing, Signature Tools10:06
5. How to Delete G-Mail account and take backup of the data02:08
3. How send messages to To, CC, BCC
