Course Code: SE-CCC-08
COURSE CONTENT
Month 1: Excel Fundamentals & Data Management
- Introduction to MS Excel & Workbook Managemen
- Rows, Columns, Cells, Worksheets અને Cell Reference
- Data Entry, Editing, Formatting & Number Format
- Font, Alignment, Borders, Styles & Conditional Formattin
- Sort, Filter, Find & Replace
- Data Validation & Drop-down List
- Freeze Panes, Hide/Unhide Rows & Columns
- Page Setup, Print Area & Page Breaks
- Basic Formulas: SUM, AVERAGE, MIN, MAX, COUN
- Practical: Student Marksheet & Monthly Expense Sheet
Month 2: Advanced Formulas & Functions
- Relative, Absolute & Mixed Cell References
- IF, Nested IF, AND, OR, IFS
- SUMIF, SUMIFS, COUNTIF, COUNTIFS
- IFERROR & Logical Functions
- VLOOKUP, HLOOKUP & XLOOKUP
- INDEX & MATCH
- LEFT, RIGHT, MID, LEN, TRIM, CONCAT & TEXTJOIN
- TODAY, NOW, DATE, DAY, MONTH, YEAR, DATEDIF
- ROUND, ROUNDUP, ROUNDDOWN, SUBTOTAL
- Remove Duplicates & Text to Columns
- Practical: Salary Sheet, Payroll & Sales Report
Month 3: Data Analysis, Dashboard & Projects
- Excel Tables & Structured References
- Pivot Table & Pivot Chart
- Slicers & Timelines
- Charts: Column, Bar, Line, Pie & Combo Chart
- Interactive Dashboard Design
- What-If Analysis & Goal Seek
- Consolidate Data & Subtotal
- Basic Macro Recording & Introduction to VBA
- Sheet Protection, Workbook Protection & File Security
- Professional Report Design & Printing
- Final Practical Project & Assessment
Duration : 3 Months
Eligibility : 10th Pass
Course Fees : Rs.3500/-