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.
VERSION HISTORY
- Version 1.0 posted on 2016-06-28
Program Details
- Category: Education > Teaching & Training Tools
- Publisher: eduocean softwares
- License: Free
- Price: N/A
- Version: 1.0
- Platform: android