Verify Your CERTIFICATE




https://belgie-pillen.be/generiek-viagra/

Amity Computer Academy

Call Now : 09007850161

ADVANCE EXCEL COURSE

(Online & Classroom Training Facility available)

At Amity Computer Academy, we offer comprehensive Advanced Excel training to help you master essential data and analytical skills. Our practical, hands-on courses are carefully designed for everyone—from college students building their resumes to working professionals looking to upgrade their careers. Join us to boost your productivity, learn industry-ready techniques, and become an Excel expert

  • Introduction
  • User interface in Excel
  • Adding Process
  • Average
  • Max
  • Min
  • Remove error by absolute reference
  • If statement
  • Name Box
  • Formatting of Data
  • Alignment
  • Rotate Text
  • Wrap Text
  • Insert Picture
  • Chart
  • Find and Replace
  • Sorting
  • Auto Filter
  • Advance Filter
  • Calculation
  • Between worksheet
  • Pivot Table
  • Subtotal
  • Data Validation
  • Conditional Formatting
  • Grid Lines
  • Vlookup
  • Hlookup
  • Hyperlink
  • Goal seek
  • Scenario
  • Introduction to function
  • Sum if
  • Average If
  • Sum Ifs
  • Average Ifs
  • Update Value without Formula
  • Range Name
  • Left and right function
  • And function
  • OR Function
  • Trim Function
  • Concatenate
  • Proper
  • Upper
  • Lower function
  • Exact Function
  • Len Function
  • Rept. Function
  • If Error Function
  • IFNA Function
  • Advance Vlookup Function
  • Choice Function
  • MatchFunction
  • Index Function
  • Transpose
  • Odd and Even function
  • Loan calculation
  • PV Function
  • FV Function
  • PMT Function
  • IPMT Function
  • IRR Function
  • NPER Function
  • NPV Function
  • Rate Function
  • Macro

 

Open chat