Tuesday, January 31, 2023

Microsoft Excel full course (MS Excel)

 Starting Microsoft Excel Program(courses)

Microsoft Excel is a spreadsheet software developed by Microsoft that is widely used for data analysis, organization, and management. It allows users to perform calculations, create charts and graphs, and perform various other tasks with data. It is available as part of Microsoft Office suite and as a standalone application.

In this tutorial you can click & read all courses in 90 chapters of MS Excel...
  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. Data Entry Like Pro 
  6. Create Your Own Custom List 
  7. How Make Password Your Excel File 
  8. How To Create A Backup File 
  9. How To Use Sum Formula 
  10. How To Use Skip Blanks
  11. Subtract, Multiple, Divide And Percentage 
  12. Use Of Number Format In Excel 
  13. Use Conditional Formatting 
  14. How To Sort & Filter Data 
  15. Using Find And Replace And Using GoTo 
  16. How To Use Status Bar
  17. Freeze Panes Option 
  18. Split Window 
  19. Fill Option 
  20. Flesh Fill 
  21. Pivot Table 
  22. All Table Option 
  23. Picture Option
  24. Use Shape
  25. Use 3D Modal 
  26. Smart Art
  27. Advance Charts & Graph Charts 
  28. People Graph 
  29. Create Hyperlinks 
  30. Header And Footer
  31. Write, Insert, Or Change An Equation
  32. Using The Draw Tab 
  33. How To Use Themes 
  34. Complete Page Setup 
  35. Scale To Fit Setup 
  36. IF Formula 
  37. IF Formula With Multiple Conditions 
  38. Change Case And Round Figure Formula
  39. VLOOKUP Formula 
  40. VLOOKUP Formula Examples 
  41. HLOOKUP Formula 
  42. And Formula 
  43. Convert Number Into Word Formula 
  44. Use Macros With Examples 
  45. Subtotal Formula 
  46. Link Data In Excel Spreadsheets Formula 
  47. Data Consolidate Formula 
  48. Calculate Age With Date, Date IF Formula 
  49. E-Date And Eo-Month Formula 
  50. Calculating Percent Formula 
  51. Superscript And Subscript Formula 
  52. Group Ungroup Subtotal Formula 
  53. Goal Seek Formula 
  54. PMT Formula 
  55. Goal With PMT Formula 
  56. Concat Formula 
  57. INDIRECT Formula 
  58. Match Formula 
  59. Count, Counta, Countblank, Formula 
  60. EXACT Formula 
  61. Sumif Formula 
  62. Sumifs Formula 
  63. Round, Roundup, RoundDown, MRound Formula 
  64. Array Formula 
  65. LEFT, RIGHT, MID, LEN Formula 
  66. Split Name Using LEFT, RIGHT, MID, LEN, Formula 
  67. Mod Formula 
  68. Quotient Formula 
  69. Replace Formula
  70. SUBSTITUTE Formula 
  71. Excel Formula Error Types 
  72. SUMPRODUCT Formula 
  73. Text Formula 
  74. Double VLOOKUP Formula 
  75. Simple Interest Formula 
  76. Compound Interest Formula
  77. Ceiling And Floor Formula 
  78. Index Formula 
  79. INDEX + MATCH Formula 
  80. Forecast Formula 
  81. Value Formula 
  82. Most Important Keyboard Shortcut 
  83. Employee’s Payroll And Salary Slip 
  84. Daily Stock Register 
  85. Dynamic Unit Converter 
  86. Dynamic Dropdown List 
  87. School Marksheet With Grade 
  88. Make Checklist & To Do List 
  89. Make Attendance Sheet 
  90. Student Database With Mail Merge 

No comments:

Post a Comment

यह तन विष की बेलरी, गुरु अमृत की खान। शीश दियो जो गुरु मिले, तो भी सस्ता जान।। इसका अर्थ?

 यह दोहा संत कबीरदास जी का है और इसका अर्थ बहुत ही गहरा और प्रेरणादायक है: दोहा: "यह तन विष की बेलरी, गुरु अमृत की खान। शीश दियो जो...