MS Excel

MS Excel

MS Excel

Level : Basic

Price : 7999   1250

1 Month(s)

Designed by: MBA (K U Alumni)
Holds experience of SAP/BAAN & Other ERP Systems

Become a Microsoft Excel expert enrolling in this course of MS Excel. This course is for beginners and intermediate level students.

The course covers:

  1. Start your journey from Microsoft Excel interface to understanding functions, Macros and much more.   
  2. Create and manage Excel workbook
  3. Playing with rows and columns
  4. Pivot tables (need of the hour)
  5. You will learn maximum used functions in MS Excel
  6. Enrolling in this course you will have a deep access to an expert knowledge
  7. Learn calculations inside a data model

Key Features:

This course is an All-in-one package of learning the all new version of Microsoft Excel.

There are 122 lectures, thus giving you an idea of the vastness of this course.

It’s been an in depth research to make things easy to learn, practical usage and yet keeping the concepts precise.

After successfully completing this course, you will have an expertise in Microsoft Excel and you will be at the Advanced level.

Practise requirements:

Enrolling in this course requires no prior knowledge. Student must have Laptop/Computer with Microsoft Excel to practise

How to get maximum benefit from this course?

  • StudyKosh offers this course of MS Excel from the scratch, means beginners level taking you to intermediate level and after completion to advanced level.
  • School students who want to learn MS Excel, MBA/BBA/B.COM/Law students pursuing their streams.
  • If you are a freelancer who wants to learn Microsoft Excel and take your skills to a next level.

Then this course is for you all.

Good Luck all the enthusiasts!!!!


  1. Introduction to Excel
  2. How to open Excel?
  3. MS Excel interface
  4. Customize the quick access bar
  5. More on interface of Excel
  6. Workbook in Excel
  7. How to save the document in Excel?
  8. How to open the document in Excel?
  9. Build a spreadsheet
  10. Numeric data in Excel
  11. Cell References
  12. Basic Formulas
  13. Relative and Absolute Cell References
  14. What are functions in Excel?
  15. Sum () function
  16. Min () and () Max Function
  17. Average Function
  18. Count Function
  19. Auto Sum Command
  20. Shortcut to Auto Sum Command
  21. How to copy the formulas by using autofill?
  22. How to move and copy data?
  23. Adding and deleting rows and columns
  24. How to change the width and height of the column?
  25. How to hide rows and columns?
  26. How to rename the worksheet?
  27. How to delete the worksheet?
  28.  Reordering and copying an Excel Worksheet
  29. Font formatting commands
  30. Background color of a cell
  31. How to add borders to cells?
  32. How to add currency values to the data?
  33. How to format percentage values?
  34. Format painter in Excel
  35. How to create styles to format data?
  36. Merge and Center Option
  37. Conditional Formatting
  38. How to insert the images?
  39. Shapes in Excel
  40. How to format shapes?
  41. SmartArt in Excel
  42. Column Chart in Excel
  43. Chart ribbon in Excel
  44. Modification of data
  45. How to format chart?
  46. How to move chart from one worksheet to another?
  47. Pie Chart
  48. How to view your document in Print Preview?
  49. Orientations, margins, and Scaling
  50. Page layout view
  51. Header and Footer
  52. How to print specific range of cells?
  53. Templates in Excel
  54. How to custom a template?
  55. List Structure in Excel
  56. Single level sort
  57. Multi- level sort
  58. Custom sort
  59. Use of auto filter tool
  60. How to create subtotal in list?
  61. How to format a list as a table?
  62. Conditional formatting to find duplicates
  63. How to remove duplicates?
  64. Introduction to DSUM Function
  65. OR criteria in DSUM
  66. AND criteria in DSUM
  67. D Average () Function
  68. D Count Function
  69. Introduction to data validation
  70. Data validation criteria
  71. Adding data from a list in data validation
  72. How to add custom data validation error?
  73. Introduction to Pivot Table
  74. How to create Pivot Table?
  75. How to modify the calculations of Pivot Table?
  76. How to group data in Pivot Table?
  77. Data formatting in Pivot Table
  78. Pivot Chart
  79. More about Pivot Table
  80. Filtering data in Pivot Tables
  81. Use of slicer tool
  82. Power Pivot
  83. How to active Power Pivot?
  84. Working with Power Pivot
  85. How to create Pivot Table using Data Model?
  86. Calculations inside the data model
  87. Key performance indicator in data model
  88. Freeze Panes Tool
  89. How to print large set of data?
  90. How to group data?
  91. How to link worksheets?
  92. Name ranges in Excel
  93. Benefits of using name range
  94. If function ()
  95. Use of name range in if () function
  96. Nesting functions
  97. Using AND () Function within the if () function
  98. Countif () function
  99. SUM if () function
  100. Not and If error function
  101. VLOOKUP Function
  102. HLOOKUP Function
  103. Index Function
  104. Index and Match Function Together
  105. Left () Right () and Mid () function
  106. LEN () Function
  107. Search () Function
  108. Concatenate Function
  109. Use of Watch Window
  110. Match Function ()
  111. Use of trace precedents
  112. Use of trace dependents
  113. Show formula
  114. How to protect the structure of a worksheet?
  115. How to add password to protect the worksheet, workbook password?
  116. Solver Tool
  117. Goal Seek Function
  118. Scenario Manager in Excel
  119. Introduction to Marcos
  120. How to create Marcos?
  121. How to create button for Marcos?
  122. How to Edit Marcos?

Add Reviews

    Be the first to Review this Material

Related Courses