Advance Excel

Lookups, financial functions, pivot tables and charts.

What you will learn

Introduction of MS-Excel

Spread Sheet & Function

  • Lookup
  • Vlookup
  • Hlookup
  • Xlookup
  • Sum
  • Average
  • Match
  • Choose
  • Or
  • And
  • Index
  • Sumif
  • Sumifs
  • Round
  • Indirect
  • Datedif
  • Text
  • Max
  • Min
  • Subtotal
  • Count
  • Countif
  • etc.

Financial Functions

  • PMT, PPMT, IPMT Function
  • Simple Interest & Compound Interest Formula
  • PV, FV, Nper Function

Data Analysis

  • Pivot Table & Chart
  • Filtering Data & Sorting Data
  • Using Validation
  • Creating Charts
  • etc.

Why join PCC

  • Ten Year well Experienced in field of IT Management.
  • Provide Identification Card & LTM Card.
  • Job Oriented Courses.
  • 100% Job Placement Assistance.
  • Flexible Timing - (7:00 AM to 8:00 PM)
  • Weekend Classes - (Mon to Sat)
  • Life-Time Teaching Support.
  • 60 Minutes Batches.
  • Weekly Mock & Practical Test.
  • 100% Practical Oriented Classes.
  • 100% Knowledge is Guaranteed.

2 Days Demo Free Available

Other courses

Advance Basic Computer

Computer basics, MS Office 2021 and hands-on Windows know-how.

4 monthsDetails

Advance Tally

Accounting, inventory, payroll and GST on Tally ERP 9 & Prime.

5 monthsDetails

DTP – Desktop Publishing

CorelDRAW, Photoshop and PageMaker for print and design work.

4 monthsDetails

← All courses

Ready to start your computer career?

Book a free demo class and meet your instructors at PCC Educations.

Book a free demoCall +91 63965 13240