021-36990045

Institute of Information Technology

0333-0204496

Course Details

ADVANCE EXCEL

What we learn in Advance Excel

  • If Conditions
  • Lookup Functions
  • Paste Special
  • Pivot Table & Charts
  • Hyperlink
  • Files Import & Export
  • Attendance Sheet
  • Property window
  • Student Report
  • Marksheet
  • Sum IF Function
  • Data Sorting
  • Basic & Advance Formulas
  • Nested Formula
  • Database Functions
  • Filter/ Advance Filter
  • If Analysis
  • Data Validation
  • Working with Scenario
  • Payroll Statementl
  • Sales Report
  • Data Validation
  • Macros
  • Advance Macros
  • Charts & Graphs