Introduction to Excel, working with Excel interface, creating worksheets and file management. Applying calculation formulas and functions : SUM, MAX, MIN, AVERAGE, COUNT, COUNTA, PRODUCT. Formatting contents of worksheet (Font, Alignment, Numbering and & Styles). Commands related to rows, columns and worksheets. Editing contents of sheet (undo, redo, cut, copy, paste, clear, fill series, find and replace). Cell referencing and implementing range names. Date & Time functions: TODAY, NOW, DAY, MONTH, YEAR, DATE, DATEVALUE, WEEKDAY, NETWORKDAY, WORKDAY, EOMONTH, EDATE, DAYS360, TIME, HOUR, MINUTE, SECOND String functions: UPPER, LOWER, PROPER, LEN, LEFT, RIGHT, MID, FIND, SEARCH, REPLACE, SUBSTITUTE, REPT, TRIM, CONCATENATE Database functions: DAVERAGE, DSUM, DMAX, DMIN, DPRODUCT, DCOUNT, DGET Logical decision making with the help of IF STATEMENT Importing and matching data using VLOOKUP, HLOOKUP, MATCH, INDEX Special advanced functions: SUMIF, COUNTIF, SUMIFS, COUNTIFS, LARGE, SMALL, PMT, ROUND, INT, ABS etc. COMPUTER EDUCATION Special advanced commands: Sort, Filter, Advanced Filter, Subtotals, Consolidate, Goal Seek, Scenarios, Paste Special, Remove Duplicates. Working with Conditional Formatting, Data Validation, Creating drop down lists Working with Pivot Table, Pivot Chart, Dashboard, Insert-Table etc. Review & Protection commands: Comment, Protect sheet, Unprotect sheet, Protect workbook, Unprotect Workbook, Share Workbook, Track Changes, Accept and Reject the Changes etc. View menu commands: NORMAL, PAGE BREAK, PAGE LAYOUT, CUSTOM VIEW, RULER, GRIDLINE, FORMULA, HEADINGS, ZOOM, 100%, ZOOM TO SELECTION, FREEZE PANES Formula Auditing, Importing contents from other sheets and workbooks. Customizing the menu bar, creating templates and protecting formulas. Use of Macros, Creating macros relative and absolute macros for various purpose. Header & Footer, page setting and printing commands