This course provides complete training in Advanced Excel, covering everything from basic to expert-level skills. You will learn cell and table formatting, formulas, functions, and automation techniques. Key topics include HLOOKUP, VLOOKUP, XLOOKUP, INDEX/MATCH, Pivot Tables, Advanced Filters, Conditional Formatting, What-If Analysis, and Macros. You’ll also master salary calculation, loan amortization, attendance sheets, and more.
✅ Hands-on Training
✅ Expert Faculty
✅ Certification on Completion
Perfect for students, professionals, and business owners looking to enhance their Excel skills for better productivity and data management!
COURSE DURATION
Course Duration ▶ 3 Months
COURSE CONTENT
-
Basic Excel
-
Advanced Excel
-
Cell Formatting
-
Table Formatting
-
Advanced Conditional Formatting
-
Salary Calculation
-
Simple Interest Calculation
-
Compound Interest Calculation
-
Sort & Subtotals
-
Advanced Filter
-
Pivot Table
-
Pivot Chart
-
-
Advanced Excel
-
HLOOKUP / VLOOKUP / XLOOKUP
-
INDEX / MATCH
-
What-If Analysis
-
Attendance Sheet
-
Shortcut Keys
-
Salary Slip
-
Loan Amortization Schedule
-
Formula Series
-
Print
-
Macros
-
Enjoy 30% Off on All Courses!
– Limited Time Offer!
