Advanced Excel 2013

  • Introduction of Excel
  • Creating Student Mark Sheet
  • Finding Result & Grade Using If Function
  • Sort & Filter & Advance Filter
  • Discount Sheet
  • Subtotal
  • Advance Salary Sheet
  • Pivot Table & Pivot Chart
  • V Lookup & H Lookup
  • Conditional Formatting
  • Scenario Manager
  • TDS (Tax Dedicated At Source) Concept
  • Dynamic Chart & Pareto Chart
  • Consolidate & Data Validation
  • Conditional Formatting Using Formula
  • Find Duplicate Values Using Formula
  • PTM Function & Data Table
  • Goal Seek & Solver
  • Dated If
  • Count If & Sum If
  • Match & Index Function
  • Basic Functions & Logical Functions
  • Macros Recording.

Apply for Advanced Excel 2013