Welcome to Success Education

Success Education is Run Under: JRJ Success Education Foundation Reg. by Ministry of Corporate Affairs (Govt. of India) CIN. No : U88900GJ2024NPL154404 - An ISO 9001:2015 & 21001:2025 Certified Organization. Reg. No. 305024092531Q & Reg. No : 2026092627. - Ministry of Micro Small & Medium Enterprises (MSME) Govt. of India. Reg. No : UDYAM-GJ-12-0008124 - NITI Aayog Unique ID: GJ/2025/0734985.

Course Code: SE-CCC-08

 

COURSE CONTENT

Month 1: Excel Fundamentals & Data Management

  1. Introduction to MS Excel & Workbook Managemen
  2. Rows, Columns, Cells, Worksheets અને Cell Reference
  3. Data Entry, Editing, Formatting & Number Format
  4. Font, Alignment, Borders, Styles & Conditional Formattin
  5. Sort, Filter, Find & Replace
  6. Data Validation & Drop-down List
  7. Freeze Panes, Hide/Unhide Rows & Columns
  8. Page Setup, Print Area & Page Breaks
  9. Basic Formulas: SUM, AVERAGE, MIN, MAX, COUN
  10. Practical: Student Marksheet & Monthly Expense Sheet

Month 2: Advanced Formulas & Functions

  1. Relative, Absolute & Mixed Cell References
  2. IF, Nested IF, AND, OR, IFS
  3. SUMIF, SUMIFS, COUNTIF, COUNTIFS
  4. IFERROR & Logical Functions
  5. VLOOKUP, HLOOKUP & XLOOKUP
  6. INDEX & MATCH
  7. LEFT, RIGHT, MID, LEN, TRIM, CONCAT & TEXTJOIN
  8. TODAY, NOW, DATE, DAY, MONTH, YEAR, DATEDIF
  9. ROUND, ROUNDUP, ROUNDDOWN, SUBTOTAL
  10. Remove Duplicates & Text to Columns
  11. Practical: Salary Sheet, Payroll & Sales Report

Month 3: Data Analysis, Dashboard & Projects

  1. Excel Tables & Structured References
  2. Pivot Table & Pivot Chart
  3. Slicers & Timelines
  4. Charts: Column, Bar, Line, Pie & Combo Chart
  5. Interactive Dashboard Design
  6. What-If Analysis & Goal Seek
  7. Consolidate Data & Subtotal
  8. Basic Macro Recording & Introduction to VBA
  9. Sheet Protection, Workbook Protection & File Security
  10. Professional Report Design & Printing
  11. Final Practical Project & Assessment

Duration          : 3 Months
Eligibility        : 10th Pass
Course Fees   : Rs.3500/-