ADVANCE EXCEL

• Workbook, Worksheet, Workspaces
• Row & Column Settings
• Calculation Basics
• References (Relative, Absolute, Mixed)
• Find & Replacing Data
• Header & Footer setting
• Working with Chart
• Functions (Arithmetic, Financial, Statistical etc.)
• Formulas
• If And Analysis, What if Analysis
• Goal Seek, Scenarios
• Naming Cell Range
• Protecting sheet & workbook
• Autofill, Autocorrect, Autoformat
• Importing and Exporting Data
• Auditing, Freeze Panes
• Grouping and Subtotal
• Macro (recording tool)/EDITING
• Customizing Sheet/Cells /Rows/Columns
• Customizing Excel Window
• Sorting and Filtering Data
• Data Validation
• Pivot Table, Pivot Chart
• Consolidation of Sheets
• H Lookup, V Lookup
• Creating Reports, Marks sheet etc.
• Printing Worksheet, Custom List
• #(PROJECT BASED ON BULK DATA)