Course Details

Following are the key features of our MIS Programme in MS Excel: Defining names and Its Importance, Magic of Auto Fill, Conditional Formatting & Hyperlink, Text Function like: EXACT, FIND, LEFT, RIGHT, MID, FIND, REPLACE, LEN, LOWER, UPPER, PROPER,REPT, TRIM, TEXT, SEARCH, CONCATENATE and more, Advance TEXT Function and nesting methodology, Logical Function like: IF, AND, OR, NOT, IFERROR and more Advance Logical Function and its nesting methodology, SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS & COUNTIFS, MAX, MIN, CHOOSE and other nested Function, Creation of EMI Calculator and Data Table, Lookup & Reference Function like: CHOOSE, COLUMN, COLUMNS, H LOOKUP, VLOOKUP, TRANSPOSE, ROW, ROWS etc.