ADVANCED EXCEL

ADVANCE MS EXCEL

  • Flash Fill, Advance Number Formatting
  • Dynamic Data Validation
  • Quick Analysis
  • V Look Up from Multiple Tables, Dynamic V Look Up
  • Sum Product Function
  • Solver Depreciation
  • Power Pivot¸Power View, Power Map , Power Query
  • Error Messages in Excel
  • Advance Macros, Array
  • Introduction to ASAP possibilities,creating index with links
  • Printing multiple sheets, Protect multiple sheets
  • Put together row and columns from several sheets, spell check
  • Google Drive, form Creating sending and receiving response mail merge through google drive. 

Popular Programs