Adv-Excel 2010 Hindi-Eng-Tamil

Advance Excel 2010 (free course)
400+ Formulas & Functions
4-5 hrs Video Tutors in Hindi-English-Tamil
---------------------------------------------------------------------------------
This having -16 chapters ----

Chapter 1
• Introduction to Excel 2010 Advanced
• Formulas and Functions •
• Using the entire row or column references
• Copying column formulas instantly
• Converting formulas to values with a simple drag.
Chapter 2
• Creating 3D formulas to gather data from multiple sheets
• Displaying & highlighting formulas •
• Enhancing readability with range names.

Chapter 3
• Reviewing function basics •
• Using & ExtendingAutoSum •
• Using mixed references.
Chapter 4
• Exploring IF logical tests and using relational operators •
• Creating &expanding the use of nested IF statements •
• Using the AND & OR functions with IF to create compound logical tests.

Chapter 5
• Looking up information with VLOOKUP and HLOOKUP
• Finding approximate matches with VLOOKUP •
• Finding exact matches with VLOOKUP.
Chapter 6
• Finding table-like information within a function with CHOOSE •
• Retrieving information by location with INDEX.
• Using MATCH and INDEX together.

Chapter 7
• Tabulating information on a single criterion with COUNTIF,
• SUMIF,and AVERAGEIF.

Chapter 8
• Finding the middle value with MEDIAN •
• Ranking data without sorting with RANK •
• Finding the magnitude data with LARGE &SMALL.

Chapter 9
• Understanding Excel date/time capabilities in formulas •
• Identify in the day of the week with WEEKDAY.
• Determining a completion date with WORKDAY.

Chapter 10
• Working with rounding functions.
• Finding the remainder with MOD and using MOD with conditional formatting.
• •Converting a value between measurement systems with CONVERT.

Chapter11
• Extending formula capabilities with arrays •
• Determining frequency distributions with FREQUENCY.
• •Building analysis via regression techniques with TREND and GROWTH •
• Combining multiple functions in arrays.

Chapter 12
• Locating and extracting data with FIND and MID •
• Extracting specific data with LEFT and RIGHT.

Chapter 13
• Using CONCATENATE with functions •
• Adjusting case within cells with PROPER, UPPER, and LOWER.
• •Adjusting character content with REPLACE and SUBSTITUTE.

Chapter 14
• Calculatingpayments with PMT.
• Finding future values with FV.

Chapter 15
• Working with the IS information functions •
• Using error-checking functions.

Chapter 16
• Getting data from remote cells with OFFSET •
• Returning references with INDIRECT.