Office & Productivity Popular

Advanced Excel

Advanced Excel course helps students develop professional spreadsheet and data-management skills required for office work, accounting, MIS and data analysis.

  • 2 month Month
  • Certificate included
  • Classroom training
Call us
Advanced Excel
1+Students enrolled
1+Students placed
29Industry courses

What you'll learn

Topics covered in this course

  • Excel Advanced Formatting
  • Advanced Formulas
  • IF Functions
  • SUMIF & SUMIFS
  • COUNTIF & COUNTIFS
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX & MATCH
  • Data Validation
  • Conditional Formatting
  • Sorting & Filtering
  • Advanced Filter
  • Pivot Tables
  • Pivot Charts
  • Charts & Graphs
  • Data Cleaning
  • Excel Dashboard
  • MIS Reports
  • Basic Data Analysis

Similar courses

Explore more programs you may be interested in

MIS — Management Information System
Office & Productivity

MIS — Management Information System

MIS course focuses on preparing, managing and presenting business data using Excel and ot…

2 month Month View details
MS Office
Office & Productivity

MS Office

MS Office is a complete office productivity course that teaches students how to create, e…

2 month Month View details
MS Word
Office & Productivity

MS Word

MS Word is a document-processing course that teaches students to create professional docu…

2 month Month View details

Life at our institute

Modern labs. Real projects. Real careers.

Book a free demo class