Advance Excel Training In Pitampura Delhi

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)

Quick Contact

Are You Looking For Advance Excel Training ?
Open chat