• Windows
• File & Folder Management

Ms Office 2021

1. Microsoft Word
2. Microsoft Excel
3. Excel MIS Beginner to Advance

• Windows
• File & Folder Management

Ms Office 2021

1. Microsoft Word
2. Microsoft Excel
3. Excel MIS Beginner to Advance

1. Microsoft Word
2. Introduction to Microsoft Word
3. Use Clipboard Group Of Home Tab
4. Text Formatting In Microsoft Word
5. Line and Paragraph Spacing
6. Sort Paragraph, Bullet and Number Lists
7. Page Setup And printing
8. How to Create Custom Cover pages
9. Hyperlink, Bookmark and Cross Reference
10. Creating And Formatting Tables 
11. Insert Pictures in Word
12. Insert Clip Art & Online Image
13. Using Word Text Boxes
14. Create or Run a Macro
15.  Create Or Run a Macro
16. Create Filllable Form
17. Use Autocorrect in Word
18. How to Insert Watermaks
19. Set default Hindi Font And Font Size
20. Check Spelling and Grammar
21. Perfect Text Alignment using Tabs
22. Add Footnote And Endnote
23. Insert Caption In Word
24. Insert Table of Contents
25. Create a Bibliography,  Citation, and Referencess son
26. Microsoft Word Best Keyboard Shortcuts
27. Letter Format Example and writing Tips
28. How to create a Resume in word
29. Using Mail Merge In Ms Word
30. Create Certificate In Ms Word
31. How To Make Visiting Card

1. Microsoft Excel Introduction
2. How to Work in Excel and Use Basic Formulas
3. Use Clipboard Like pro Full Explain
4. Organize Row Column And Worksheet
5. Date Entry Like Pro
6. Create Your Own Custom List
7. How Make password Your Excel File
8. How To Use Sum Sum Formula
9. How to Use Skip Blanks
10. Subtract, Multiple, Divide And Percentage
11. Use Conditional Formatting 
12. How to sort & Filter Data
13. Using Find and Replace And Using Go to
14. How to use Status Bar
15. Freeze Panes Option
16. Split Window 
17. Fill Option 
18. Flesh Fill
19. Pivot Table
20. All Table Option
21. Pictures Option
22. Use shape
23. Use 3D Modal
24. Smart Art
25. Advanced Charts & Graph
26. People Graph 
27. Create Hyperlinks
28. Header And Footer
29. Write, Insert or Change an Equation
30. Using the Draw Tab
31. How to Use Themes
32. Complete Page Setup
33. Scale to Fit Setup
34. If Formula
35.  If Formula With Multiple Conditions
36. Change Case And Round Figure Formula
37. Vlookup Formula
38. Vlookup Formula Examples
39. Hlookup Formula 
40. And Formula
41. Convert Number Into word formula
42. Use Macros With Example
43. Subtotal Formula
44. Link Date in Excel Spreadsheets Formula
45. Date Consolidate Formula
46. Calculate  Age With Date, Date if Formula
47. E- Date and Eo- Month Formula
48. Calculating Percent Formula
49. Superscript and Subscript Formula
50. Group Ungroup subtotal Formula
51. Goal Seek Formula
52. PMT Formula
53. Goal With PMT Formula
54. Concat Formula
55. INDIRECT Formula
56. Match Formula
57. Count, Counta, Countblank Formula
58. Exact Formula
59. Sumif Formula
60. Round, Roundup, RoundDown, MRound dormula
61. Array Formula
62. Left, Right, Mid, Len & Find Formula
63. Split Name using Left, Right Mid, Len Formula
64. Mod Formula 
65. Quotient Formula
66. Replace Formula
67. Substitute Formula
68. Excel Formula Error Type 
69. SUMPRODUCT Formula
70. Text Formula
71. Double Vlookup Formula
72. Simple Interest Formula
73. Compound Interest Formula
74. Celling And Floor Formula
75. Index Formula
76. INDEX + MATCH Formula
77. Forecast Fomula
78. Value Formula
79. Most Important keyboard shortcut
80. Employees Payroll and Salary Slip
81. Daily Stock Register 
82. Dynamic Unit Converter
83. Dynamic Dropdown List
84. School Marksheet with Grade
85. Make Checkilist & To Do List
86. Make Attendance Sheet 
87. Student Database With mail Merge

1. Pivot Table Introduction
2. Pivot Table and Pivot Chart
3. Design Tab of Pivot chart
4. Slicer in Pivot Table & Slicer settings
5. Time Line In Pivot Table 
6. Get Pivot Date in Excel
7. Pareto Chart in Excel
8. INFORGRAPHIC chart in Excel
9. Trend Chart using Sumifs Formula
10. Map Chart using xy Scatter chart 
11. Key performance Indicator in Excel
12. Chart with Hyperlink
13. Chart with Conditional Formatting 
14. Create Bar Charts with Pictures Mis Series
15. Speedometer chart In Excel
16. See Saw Comparison Chart
17. Mis – Hyperlink with Column and pie-  chart
18. Mis- Male, Female Comparison Chart
19. Excel MIS – Create Dynamic Month Dasboard using offset formula
20. Excel Mis – reate Dashboard on Day Wise Report
21. Excel MIS – sales Ranking Dashboard
22. Excel Mis- Create Weekly sales Dasboard using Listbok
23. Mis In Excel – Daily Task Reminder Dashboard
24. Mis In Excel – Create Year Wise report using Vlookup, Match, Index
25. Mis In Excel- Create Dasboard Using Vlookup,Match , Index, Conntif
26. Mis – Amazing Dasboard
27. Mis – Time Dashboard
28. Mis- Gantt chart With Conditional Formatting

1. Power Query- Introduction and Installation
2. Power Query- Create Connections with Excel Table
3. Power Query – Create Connection With Text fill and Access Database
4. Power Query – Reconnect Date in power Query
5. Power Query – Create pivot tbale on Text file data
6. Power Query- Merge Multiple Sheets using M Language
7. Power Query – Create Pivot table on Multiple Sheets
8. Power Query – Close and Load to Explain – Home Tab- Query group
9. Power Query – Home Tab – Manage Column and Rows Group
10. Power Query- Home Tab – Split Column into rows and columns 
11. Power Query – Home Tab – Group by suing Basic and Advance Option
12. Power Query – Home Tab Date type & Replace Values
13. Power Query – Transform data Dynamically
14. Power Query – Combine 1000+ Tables with 1 Function
15. Power Query – Alternate Options of Vlookup inside Power query
16. Power Query – Multiple Columns Lookup
17. Power Query – Remove weekends and Holidays
18. Power Query – Calculate Age with simple Method
19. Power Query –  Calculate Task Timings
20. Power Query – Add Column Date Options in Detail
21. Power Query – Time and Duration Options in Detail
22. Power Query – Transform Rew Date – Real Job Query 
23. Power Query – Few clicks to get Trim, Propercase and Merge Data
24. Power Query – Merge Workbooks and Create Pivot
25. Power Query – Merge Workbooks with File Name as Column
26. Power Query – Rew Data To Pivot
27. Power Query – Merge Vs Append
28.  

1. Power Point intro
2. Make New Slideshow in Power point
3. Add Transition to Power Point
4. Text Animation In power Point
5. Caeate Custom Animation 
6. Record Silde Show as a Video

1. Ms Access Part 1
2. MS Access Part 2
3. MS Access Part 3
4. MS Access Part 4