WELCOME TO OMEGA COMPUTER EDUCATION AND SPOKEN ENGLISH

CERTIFICATE IN ADVANCE EXCEL ( S-ADE )

CERTIFICATE IN ADVANCE EXCEL ( S-ADE )

BASIC INFORMATION

Course Fees : 9500.00 10000.00/-
Course Duration : 2 MONTHS
Minimum Amount To Pay : Rs.500.00

Admission Now

1. Excel Basics (Review)

Overview of Excel interface
Workbook vs Worksheet
Basic formulas & functions
Cell referencing (Relative, Absolute, Mixed)

2. Advanced Formulas and Functions

Logical Functions: IF, IFS, AND, OR, NOT
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH
Text Functions: LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE, TEXTJOIN
Date & Time Functions: TODAY, NOW, DATEDIF, TEXT, EDATE
Math Functions: ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, MOD
Error Handling Functions: IFERROR, IFNA
Array Formulas and Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE

3. Data Tools

Data Validation (Dropdowns, Rules)
Text to Columns
Flash Fill
Remove Duplicates
What-If Analysis: Goal Seek, Scenario Manager, Data Tables

4. Charts and Graphs

Creating and formatting charts
Combo charts
Sparklines
Advanced chart types (Waterfall, Funnel, Histogram, Pareto)
Customizing axes, labels, and legends

5. Pivot Tables and Pivot Charts

Creating Pivot Tables
Filtering and Sorting
Grouping Data
Calculated Fields & Items
Slicers and Timelines
Creating Pivot Charts

6. Data Analysis and Business Intelligence

Power Query (Get & Transform)
Power Pivot: Data Model, Relationships, DAX basics
Dashboard creation (with interactive elements)

7. Excel Automation with Macros

Recording Macros
Assigning Macros to buttons
Introduction to VBA (Visual Basic for Applications)
- Modules, Procedures
- Basic VBA commands and MsgBox
- Loops and Conditions in VBA

8. Working with External Data

Importing from Text, CSV, Web, and Databases
Connecting and refreshing data sources
Using Queries to clean and transform data

9. Advanced Formatting and Customization

Conditional Formatting (with formulas)
Custom Number Formats
Using Themes and Templates
Protection: Sheet and Workbook Protection, Cell Locking

10. Collaboration and Review

Track Changes and Comments
Sharing and protecting workbooks
Co-authoring in Excel (Online)
Printing and Page Setup for Reports

Minimum: 10th or 12th pass (basic computer knowledge preferred)

Recommended: Graduate or currently pursuing graduation (especially in Commerce, Science, Business, Data, or IT fields)

OTHER COURSES

CERTIFICATE IN COMPUTER COURSE ( CCC )

Course Fees : 4500.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : CCC

CERTIFICATE IN TALLY + GST ( TALLY - 01 )

Course Fees : 6500.00/- 7000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TALLY - 01

CERTIFICATE IN COMPUTER COURSE ( CCC+ )

Course Fees : 5500.00/- 6000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : CCC+

ADVANCE DIPLOMA IN COMPUTER APPLICATION ( ADCA )

Course Fees : 25000.00/- 35000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : ADCA

DIPLOMA IN COMPUTER APPLICATION ( DCA )

Course Fees : 15000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : DCA

DIPLOMA IN INFORMATION TECHNOLOGY ( DCA - IT )

Course Fees : 16000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : DCA - IT

SPOKEN IN ENGLISH ( FOR KIDS )

Course Fees : 4000.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : FOR KIDS

SPOKEN IN ENGLISH ( FOR BEGINNERS )

Course Fees : 7000.00/- 10500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : FOR BEGINNERS

DIPLOMA IN FINANCIAL ACCOUNTING ( TALLY - 02 )

Course Fees : 8000.00/- 8500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TALLY - 02

ADVANCE DIPLOMA IN INFORMATION TECHNOLOGY ( ADCA - IT )

Course Fees : 30000.00/- 35000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : ADCA - IT

CERTIFICATE IN TALLY PRIME ( TP - 01 )

Course Fees : 7500.00/- 8000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TP - 01

DIPLOMA IN FINANCIAL ACCOUNTING - TALLY PRIME ( TP - 02 )

Course Fees : 8500.00/- 9000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TP - 02

CERTIFICATE IN BASIC COMPUTER COURSE ( S-BCC )

Course Fees : 3000.00/- 3500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-BCC

SPOKEN IN ENGLISH ( PERSONAL BATCH )

Course Fees : 16000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : PERSONAL BATCH

DIPLOMA IN OFFICE AUTOMATION ( S-DOA )

Course Fees : 13000.00/- 15000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-DOA

ADVANCE DIPLOMA IN OFFICE AUTOMATION ( S-AD-OA )

Course Fees : 15000.00/- 17000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-AD-OA

CERTIFICATE IN C LANGUAGE ( S-CL )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CL

CERTIFICATE IN C++ LANGUAGE ( S-CL ++ )

Course Fees : 4500.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CL ++

CERTIFICATE IN HTML FOR BEGINNERS ( S-HT )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-HT

CERTIFICATE IN HTML 5 ( S-HT-5 )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-HT-5

CERTIFICATE IN CSS ( S-CSS )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CSS

CERTIFICATE IN CSS3 ( S-CSS3 )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CSS3

CERTIFICATE IN PYTHON PROGRAMMING ( S-CPP )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CPP

CERTIFICATE IN ADVANCE EXCEL ( S-ADE )

Course Fees : 9500.00/- 10000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-ADE

DIPLOMA IN C & C++ PROGRAMMING ( M-DIPLOMA LANGUAGE )

Course Fees : 8000.00/- 8500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : M-DIPLOMA LANGUAGE

CERTIFICATE IN DIGITAL SEVA ( S-DS )

Course Fees : 5000.00/- 6000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-DS

MACROS IN ADVANCE EXCEL ( S-MADC )

Course Fees : 16500.00/- 20000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-MADC

CORPORATE IN ADVANCED EXCEL ( S-CAE )

Course Fees : 12500.00/- 15000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CAE

CERTIFICATE IN COMPUTER COURSE ( CCC )

Course Fees : 4500.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : CCC

CERTIFICATE IN TALLY + GST ( TALLY - 01 )

Course Fees : 6500.00/- 7000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TALLY - 01

CERTIFICATE IN COMPUTER COURSE ( CCC+ )

Course Fees : 5500.00/- 6000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : CCC+

SPOKEN IN ENGLISH ( FOR KIDS )

Course Fees : 4000.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : FOR KIDS

SPOKEN IN ENGLISH ( FOR BEGINNERS )

Course Fees : 7000.00/- 10500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : FOR BEGINNERS

DIPLOMA IN FINANCIAL ACCOUNTING ( TALLY - 02 )

Course Fees : 8000.00/- 8500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TALLY - 02

CERTIFICATE IN TALLY PRIME ( TP - 01 )

Course Fees : 7500.00/- 8000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TP - 01

DIPLOMA IN FINANCIAL ACCOUNTING - TALLY PRIME ( TP - 02 )

Course Fees : 8500.00/- 9000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : TP - 02

CERTIFICATE IN BASIC COMPUTER COURSE ( S-BCC )

Course Fees : 3000.00/- 3500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-BCC

SPOKEN IN ENGLISH ( PERSONAL BATCH )

Course Fees : 16000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : PERSONAL BATCH

DIPLOMA IN OFFICE AUTOMATION ( S-DOA )

Course Fees : 13000.00/- 15000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-DOA

ADVANCE DIPLOMA IN OFFICE AUTOMATION ( S-AD-OA )

Course Fees : 15000.00/- 17000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-AD-OA

CERTIFICATE IN C LANGUAGE ( S-CL )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CL

CERTIFICATE IN C++ LANGUAGE ( S-CL ++ )

Course Fees : 4500.00/- 5000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CL ++

CERTIFICATE IN HTML FOR BEGINNERS ( S-HT )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-HT

CERTIFICATE IN HTML 5 ( S-HT-5 )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-HT-5

CERTIFICATE IN CSS ( S-CSS )

Course Fees : 4000.00/- 4500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CSS

CERTIFICATE IN CSS3 ( S-CSS3 )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CSS3

CERTIFICATE IN PYTHON PROGRAMMING ( S-CPP )

Course Fees : 5000.00/- 5500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CPP

CERTIFICATE IN ADVANCE EXCEL ( S-ADE )

Course Fees : 9500.00/- 10000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-ADE

CERTIFICATE IN DIGITAL SEVA ( S-DS )

Course Fees : 5000.00/- 6000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-DS

MACROS IN ADVANCE EXCEL ( S-MADC )

Course Fees : 16500.00/- 20000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-MADC

CORPORATE IN ADVANCED EXCEL ( S-CAE )

Course Fees : 12500.00/- 15000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : S-CAE

ADVANCE DIPLOMA IN COMPUTER APPLICATION ( ADCA )

Course Fees : 25000.00/- 35000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : ADCA

DIPLOMA IN COMPUTER APPLICATION ( DCA )

Course Fees : 15000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : DCA

DIPLOMA IN INFORMATION TECHNOLOGY ( DCA - IT )

Course Fees : 16000.00/- 21000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : DCA - IT

ADVANCE DIPLOMA IN INFORMATION TECHNOLOGY ( ADCA - IT )

Course Fees : 30000.00/- 35000.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : ADCA - IT

DIPLOMA IN C & C++ PROGRAMMING ( M-DIPLOMA LANGUAGE )

Course Fees : 8000.00/- 8500.00/-
Minimum Amount To Pay : Rs.500.00

Course Code : M-DIPLOMA LANGUAGE