Module 1 : Excel Basics Cell, Column, Row, Worksheet and Workbook. Sum & Sumif Average Max and Min Basic Operator (+ - / *^) Greater than, equal to or less than (< = >) Round , Roundup and Round down Sorting and filtering data If and Else Conditional Formatting Vlookup True & False Module 2 : Data Handling - I Data Validation Grouping, Ungrouping and Subtotals Filters, Custom Filters, Advanced Filters & List Type Pivot Tables & Merge pivots from multiple locations Goal Seek Consolidate data From multiple files Split Data using Text to Columns Remove Duplicates Watch Window Data Recovery Module 3 : Data Handling - II Importing Data from another location or file. Sort Data on single & multiple criteria. Protect Excel Files, Workbook, Protect Worksheet and Cells Find Replace Blank Cells Format Painter Hyperlinks Naming a Range , Cell etc. | Module 4 : Advance Excel a) Text Functions LEFT,RIGHT,MID & TRIM PROPER, UPPER, LOWER, Clean…..etc. FIND & REPLACE Exact b. Date and Time Functions Day Days360 Now Today Time…etc. c. Mathematical Functions SumIFS Even Combine ODD Product RAND RANDBETWEEN d. Statistical Functions Len Count Count A CountIF, CountIFS Count Blank Rank Average, Average IF & Average IFS Subtotal Sign | c. Mathematical Functions SumIFS Even Combine ODD Product RAND RANDBETWEEN d. Statistical Functions Subtotal SignLen Count Count A CountIF, CountIFS Count Blank Rank Average, Average IF & Average IFS e) Logical Informatics Functions Cell ISERROR ISNA INFO...etc. Formula editing mode. Show Formula Error Checking Calculations Options And & OR IF & Nested IF IF Error , Is Error & ISNA Multiple IF Conditions IF….Vlookup….Match IF…Hlookup….Match CONCATENATE & “&”. f) Look Up & Reference Functions Lookup & H-lookup Address Choose INDEX MATCH Rows Transpose…etc. |