Rating 0 out of 5 (0 ratings in Udemy)
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 …
Rating 0 out of 5 (0 ratings in Udemy)
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.
DescriptionThis 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.
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
Outline, Sort, Filter and Subtotal
Pivot Tables
Special Functions
Macros
Mail merge
