top of page
Microsoft Excel seekhna chahte hai magar Angrezi ki wajah se problem aah rahi hai...? Seekhiye Excel ab Hindi main. Ab Excel seekhna saral aur seedha...
 
MS Excel is a dynamic tool which has lots of functionalities. We can express all that in just 4 Functions : PASS (Presenting, Analyzing, Summarizing and Sorting). The course has been meticulously designed  to provide candidates with a deep understanding of most widely used and important features and functions in MS Excel. More importantly, the lectures bridge a wide gap between the knowledge of MS Excel as a tool and its application in the real world scenarios. Get ready to stand out among your colleagues.
 
Who are we?
 
White Knight Ventures EDU is a leading global training company which has trained over 10000+ professionals and students. We conduct training for MS Excel, R Programming, SAS, VBA, SQL, Python, Analytics, Machine Learning, Finance, Risk Management, Actuarial Science, Sales & Marketing, Operations, Soft Skills and much more.
 
Such a broad and deep expertise has been distilled into this meticulously designed course. So when we say we know how to apply MS Excel to various real world scenarios, we know what we are talking about. 
 
Structure of Course:
 
The course is actually a combination of 5 courses:
 
  • MS Excel 101: Basics
  • MS Excel 102: Intermediate
  • MS Excel 103: Advance
  • MS Excel 104: Macros
  • Extra Resources To Get Ahead

 
What do you get out of this course?
 
  • Master Microsoft Excel from Beginner to Advance Level
  • Learn functions which are essential for work like Marketing, Finance, HR, Operations, and for Class Room and Research Work
  • Work efficiently with dynamic formulas like SUM, COUNT, IF, VLOOKUP, INDEX, MATCH, DATE TIME functions and many more
  • Sail faster by learning to create Nested Functions which save lot of time and pain
  • Master Formatting along with Tables, Charts & PivotTables to impress your boss, co-workers and clients 
  • Harness the power of automation with MS Excel in your day to day tasks through Macros
  • Learn to conduct What If Analysis & Goal Seek to boost your analysis prowess
  • Learn advance topics like Amortization Tables and Trendlines & Candlestick Charts
  • Access to Articles & Blogs
  • Specialized Cases Built -into the lectures
  • Hands-on learning on problem solving with Real-Life Exclusive Case Studies
 
So, what are you waiting for? Enroll now and take the next step in mastering Excel. Go from BEGINNER TO EXPERT! Always remember that EVERY EXPERT WAS ONCE A BEGINNER.

MS Excel in Hindi: Master Beginner to Advance

₹2,499.00 Regular Price
₹299.00Sale Price
    1. Introduction to MS Excel
    2. Naming
    3. Cut, Copy and Paste
    4. Basic Functions
    5. References
    6. And, Or Functions
    7. IF Function
    8. Nested If
    9. If, And, Or Functions
    10. SumIf, CountIf, AverageIf
    11. SumIfs, CountIfs, AverageIfs
    12. Text Functions Part 1
    13. Text Functions Part 2
    14. Differencs between Find, Search
    15. Date Functions Part 1
    16. Date Functions Part 2
    17. Date Functions Part 3
    18. Maths Function
    19. VLookup
    20. HLookup
    21. Index Match
    22. Array Formula
    23. VLookup with Array
    24. VLookup with Max, Min, Large Functions
    25. COnditional Formatting
    26. Sort Feature
    27. Filter
    28. Advance Filter
    29. Excel Tables
    30. What If Goal Seek
    31. What If Scenario Manager
    32. What If Data Table Part 1
    33. What If Data Table Part 2
    34. Offset
    35. Charts Part 1
    36. Charts Part 2
    37. Charts Part 3
    38. Pivot Table Part 1
    39. Pivot Table Part 2
    40. Protection Part 1
    41. Protection Part 2
    42. Formula Auditing
    43. Validation
    44. COnsolidation
    45. Text to Column Import
    46. Introduction to Developer Tab
    47. Macros
    48. Introduction to Power Point
bottom of page