100% Job Business Support
Life Time Backup Support
LIVE Practical Training

Advance Excel

COURSE OUTLINE
  • Basic Excel Course
  • Creating Formula
  •  SUMIF, COUNTIF, COUNTA, IF, AND, OR
  • Convert Day Month Year to Date
  •  What If Analysis: Goal Seek, Data Table
  • Scenario Manager
  •  Advance Filter
  •  Conditional Formatting
  •  Date &Text Function
  •  Group, Subtotal
  • Charts &Pivot Table
  • Cell Reference, Number Formatting
  •  PMT Function for Installment
  •  Data Validation &Consolidate
  •  Header / Footer, Page Numbering in Sheet
  • Freeze Pans &Macros
  •  Protect Cell &Sheet
  •  Page Setup
  • Vlookup&Hlookup
  •  Loan Amortization
  • ProjectWork:Sales &Purchase Sheet, Salary Sheet,Selection Sheet,TelephoneBill,Electricity Bill, Marks Sheet, Interest Calculation, Attendance Sheet, Balance Sheet, PL Account,LedgerTemplateDesign&Others………

Copyright 2016 Kantipur Technical Institute - All Rights Reserved Design by web creation nepal