Adv-Excel 2010 Hindi-Eng-Tamil

400+ fórmulas e funções4-5 hrs tutor vídeo grátis

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.