Learn Microsoft Excel in Hindi
What you'll learn
- Learn from Basics to Advance Excel in Hindi Language.
- Basics of Excel - Screen Interface, Menu and Keyboard shortcuts, Cut, Copy and Paste.
- Entering Numerical Data - Add subtract, multiply, divide numbers.
- Entering Text - Typing text, Aligning text and changing Font attributes.
- Autofill and Data Validation
- Analytical Functions like - Goal Seek, Scenario Manager and Data table.
- Functions like PMT, Vlookup, Hlookup, Multiple vlookup, Identifying and deleting duplicates.
- Importing and exporting data, creating subtotal based reports.
- Pivot tables, Pivot Charts.
- Functions like count, countif, countifs, sum, sumif,sumifs.
- Introduction to basic Macros and Mail Merge.
- Unique tips, tools and case studies that you won't find in any other course.
Requirements
- Microsoft Excel should be installed on your system, this course is compatible with Excel 2007, Excel 2010, Excel 2013, or Excel 2016.
- No previous experience of Spreadsheet required.
Description
This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I would teach you on how to apply the formula and understand its business and analytical application as well.
Excel is a powerful and widely-used spreadsheet program developed by Microsoft that allows users to organize, analyze, and manipulate data in a structured format. It provides a range of tools and functions that enable users to perform a variety of tasks, from simple calculations and data entry to complex data analysis and modeling.
Excel is a highly versatile tool that is used in a variety of industries, including finance, accounting, marketing, and operations. Its advanced formulas and functions make it an indispensable tool for business analysts, financial analysts, data scientists, and other professionals who need to work with large sets of data.
Excel allows users to organize and analyze data in a variety of ways, including sorting and filtering data, creating pivot tables, and performing statistical analysis. It also provides a range of visualization tools, such as charts and graphs, that make it easy to communicate data insights to others.
One of the key advantages of Excel is its ease of use. With a user-friendly interface and a wide range of pre-built templates and functions, even novice users can quickly learn how to use the program to accomplish their tasks. At the same time, Excel also offers a high level of customization and flexibility, allowing experienced users to create highly customized spreadsheets and models to meet their specific needs.
Overall, Excel is a powerful and versatile tool that is essential for anyone who needs to work with data in a business or analytical context. With the right training and knowledge, Excel can transform from a basic spreadsheet program into a dynamic and powerful analytics tool that can help businesses make better decisions and achieve greater success.
Regenerate response
By the end of the course you'll be writing robust, elegant formulas and functions which would help you to analyze data by allowing you to:
Understanding basics:
AutoFill a Series
Creating a Custom List
Data Tools
Data Validation
Drop-Down Lists
Text to Columns
pmt
Goal Seek
Scenario Manager
Data Table
Vlookup
hlookup
Importing and Exporting Data
Identifying and deleting duplicates
Outline, Sort, Filter and Subtotal
Introduction
Group and Ungroup and subtotals
Subtotals
Consolidate
Pivot Tables
Introduction
Creating Pivot Tables
Choosing Fields
Pivot Table Layout
Filtering Pivot Tables
Modifying Pivot Tables Data
Pivot Charts
Special Functions
Count / Counta / Countif / Countifs
Sum /sumif / sumifs
Macros
Mail merge
Who this course is for:
- This course is suitable for any individual who wants to understand the basics of Excel and learn to master excel.
- Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level.
- Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training.
Instructor
- 4.3 Instructor Rating
- 554 Reviews
- 1,626 Students
- 35 Courses
Sam Parulekar, the visionary founder and CEO of I-MIND Training Solutions and Consultancy, is a distinguished graduate from Mumbai University. His journey into the realm of training commenced after receiving accolades for his exceptional training skills, revealing a calling that he couldn't ignore.
In 1992, Sam embarked on his entrepreneurial journey, establishing a successful training institute that thrived for an impressive 13 years, emerging as pioneers in Computer Training. This endeavor marked the beginning of a trajectory defined by innovation and excellence.
Taking a brief sabbatical, Sam enriched his experience as a Training Manager at Wipro. However, his passion for building his own dreams led him to resign in 2012, embodying the belief that "If you are not busy building your own dream, you would be busy building others' dreams."
With over two decades of expertise, Sam has conducted impactful training sessions for both corporate entities and individuals, specializing in Computer and Behavioral programs. His influence extends to assisting small-scale companies in setting up and establishing their brands, a testament to his commitment to fostering growth.
A certified Yoga Teacher, Sam integrates yoga principles into his training programs, fostering receptivity and promoting the holistic well-being of participants. Beyond training, Sam is a prolific author, having written over 20 books on management and behavioral topics, available on various online platforms.
An avid lover of music and an enthusiastic reader, Sam channels his creative energy during his spare time. Whether writing books or composing music on his piano, guitar, and flute, he finds joy in these artistic pursuits. Sam resides in Mumbai with his wife Harshada and his mother, embodying a life dedicated to continuous learning, creativity, and the pursuit of dreams.