Welcome to SARASWATI VOCATIONAL AND EDUCATIONAL COLLEGE

SARASWATI VOCATIONAL & EDUCATIONAL COLLEGE          "Here Skills Meet Success."       "Craft Your Future with Confidence."

 
CERTIFICATE IN ADVANCE EXCEL ( M-30 )

BASIC INFORMATION

  • Course Fees : 0.00 0.00/-
  • Course Duration : 6 MONTH
  • Minimum Amount To Pay : Rs.0.00

ADVANCED EXCEL COURSE

Eligibility Criteria:

  • Educational Qualification:
    Minimum: 12th pass


    Basic Knowledge Required:
    • Familiarity with Basic Excel Functions (SUM, AVERAGE, formatting, cell references)

    • Understanding of MS Office environment

    • Basic computer skills

  • Age Limit:
    Minimum: 18 years
    No upper age restriction


Syllabus 


Module 1: Review of Basic Excel Functions

  • Cell referencing (Relative, Absolute, Mixed)

  • Data formatting and conditional formatting

  • Basic formulas: SUM, AVERAGE, COUNT, IF, etc.

  • Sorting and Filtering data

  • Charts and Graphs (Bar, Pie, Line)


Module 2: Advanced Formulas and Functions

  • Logical Functions: IF, AND, OR, NOT, IFERROR

  • Lookup & Reference Functions:

    • VLOOKUP, HLOOKUP

    • INDEX, MATCH

    • XLOOKUP (Office 365)

  • Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCAT, TEXTJOIN

  • Date & Time Functions: TODAY, NOW, DATEDIF, NETWORKDAYS

  • Array Formulas and Dynamic Arrays (FILTER, SORT, UNIQUE)


Module 3: Data Analysis Tools

  • PivotTables and PivotCharts

  • Grouping, Slicers, and Timelines

  • Subtotals and Grouping

  • What-If Analysis: Data Tables, Goal Seek, Scenario Manager

  • Data Validation (Dropdowns, Custom Rules)

  • Flash Fill & Auto Fill


Module 4: Charts and Data Visualization

  • Advanced chart types: Combo charts, Waterfall, Sparklines

  • Customizing charts: Labels, Axes, Data Series

  • Using conditional formatting for visualization

  • Dashboard Elements and KPI representation


Module 5: Working with Large Datasets

  • Managing large data tables efficiently

  • Removing duplicates

  • Sorting & Filtering multi-level data

  • Using Excel Tables and Structured References

  • Advanced Find & Replace and Go To Special


Module 6: Excel Automation with Macros (Intro)

  • Introduction to Macros

  • Recording and running simple Macros

  • Assigning macros to buttons

  • Introduction to VBA (Visual Basic for Applications) – basic concepts


Module 7: Data Import, Export & Power Tools

  • Importing data from external sources (Text, CSV, Web, Database)

  • Cleaning imported data

  • Power Query (Get & Transform) basics

  • Introduction to Power Pivot and Data Modeling


Module 8: Security, Protection & Collaboration

  • Protecting worksheets and workbooks

  • Track changes and version control

  • Sharing and collaborating in Excel

  • Worksheet protection with passwords

  • Reviewing and commenting


Module 9: Final Project / Case Study

 

  • Real-world Excel case project

  • Building a business dashboard or automated report

  • Report presentation using charts, pivot tables, and functions