• 8929450961
  • infomdnie@gmail.com

MDNIE COMPUTER COURSES

COMPUTER COURSES

CERTIFICATE IN ADVANCE EXCEL (3 MONTHS)

(ADVANCE EXCEL) -- (3 Month)
Duration: 3 Months
Eligibility: 10th , 12th Pass

Modules

Excel Basics & Data Handling
  • Excel interface & workbook structure
  • Cells, rows, columns & ranges
  • Data types & formatting
  • Sorting & filtering data
  • Data validation basics
Formulas & Functions (Core Excel)
  • Formula concepts & operators
  • Mathematical functions (SUM, AVERAGE, COUNT)
  • Logical functions (IF, AND, OR)
  • Text functions (LEFT, RIGHT, MID, LEN)
  • Date & time functions
Lookup, Reference & Conditional Functions
  • VLOOKUP & HLOOKUP
  • INDEX & MATCH
  • Conditional formatting
  • Nested formulas
Data Analysis & Reporting Tools
  • Pivot tables & pivot charts
  • Advanced filtering
  • Data consolidation
  • Charts & dashboards (basic)
  • What-if analysis (Goal Seek)
Automation & Advanced Features
  • Macros (recording & basics)
  • Introduction to VBA
  • Protecting sheets & workbooks
  • Import/export data
  • Error handling
Practical Projects & Career Skills
  • Real-life Excel projects
  • MIS & financial reports
  • Sales & attendance sheets
  • Resume-based Excel tasks
  • Interview-oriented Excel practice
  • Final assessment
HELP DESK OF
Toll Free Number +91-8929450961
Email Address infomdnie@gmail.com
Contact us in case of any help or problem.
FRANCHISE
+91-8929450961