Welcome to Excellent Educational Hub
logo
Call Us +919999222314
Menu

Excellent Educational Hub provides quality Computer Classes. All Computer Courses are available - Basic Computer Course, D.C.A, D.F.A, C.F.A, A.D.C.A, Tally Erp 9 & Prime with GST, HTML & CSS, Web Developent, Digital Marketing , Advance excel, MIS ec.

CERTIFICATE IN BASIC TO ADVANCED EXCEL ( M-05 )

CERTIFICATE IN BASIC TO ADVANCED EXCEL ( M-05 )

BASIC INFORMATION

  • Course Fees : 5000.00 8000.00/-
  • Course Duration : 2-3 MONTHS
  • Minimum Amount To Pay : Rs.1000.00
Admission Now

Microsoft Basic Excel

 Why We Use MS Excel

 Text Editing, Formatting

 Basic Tools & Use

 Sheet Options

 Basic Operators

 Fill Options & Tools

 Basic Functions

 Format Cell Options

 Conditional Formatting

 Styles Options

 Insert/Delete/Format

 Short & Filter/Editing

 Pivot Tables Tools

 Tables & It's Tools

 Excel to PDF Creation

 Password Protection

 Shapes/Pictures/Icons

 Charts & It's Types

 Sparklines & It's Tools

 Links & Symbols

 Attendance Sheet

 Office Salary Sheet

 School Result Card

 Paste Special Tools

 Basic IF Function

 Nested IF Function

 AND/ OR Operators

 Page Layouts & Setup

 TEXT Functions

 Simple VLOOKUP

 Simple HLOOKUP

 Format Making - 4

 Macros & Review

 Final Mini Project

 Microsoft Advances Excel

Reality of Advanced Excel: 

Advanced Excel skills include the ability to turning your ideas into reality in the digital space or Excel Sheet. It is not about functions/formula only, we using excel to easy our work using functions/formula.

 Recap of Basic Excel Tools & Practicals

 Advanced Date Functions

 Stock Management System

 Financial Functions (PMT/PPMT/IPMT/Etc)

 Consolidate Function

 SUMIF & SUMIFS

 Advanced VLOOKUP

 LOOKUP + MATCH

 LOOKUP in Multiple Sheet

 Double LOOKUP in Multiple Wookbooks

 Advanced Attendance Sheet

 Automated Fee Management System

 Advanced Pivot Tables & Slicer

 Pivot Chart/ Timeline/Graphs

 Automated P& L Account

 Common Errors in Excel

 Automated Salary Sheet

 Data Validation & Restrictions

 Advanced Paste Special Tool

 Data Dashboard (MIS)

 Hotel Booking System

 Fee Record with Graphs

 Automated Certificated 

 Paste Special Tools

 Retail Management System (MIS)

 Automated Certificate Generation using Word

 MIS Dashboard (Format Making)

 2  Final Major Projects

 Multiple Employee ID Card Generate using Word

 Automated Multiple Report Card Generate for Students & Parents

OTHER COURSES

6 MONTHS

DIPLOMA IN COMPUTER APPLICATION ( M-01 )

  • Course Fees : 9000.00/- 11000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-01

ENQUIRY NOW
DETAILS
3 MONTHS

CERTIFICATE IN MS OFFICE ( S-02 )

  • Course Fees : 5000.00/- 7000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : S-02

ENQUIRY NOW
DETAILS
03 MONTHS

CERTIFICATE IN BASIC COMPUTER COURSE ( M-02 )

  • Course Fees : 4500.00/- 6000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-02

ENQUIRY NOW
DETAILS
9 MONTHS

DIPLOMA IN FINANCIAL ACCOUNTING (DFA) ( M-03 )

  • Course Fees : 12000.00/- 15000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-03

ENQUIRY NOW
DETAILS
12 MONTHS

ADVANCED DIPLOMA IN COMPUTER APPLICATION (ADCA) ( M-04 )

  • Course Fees : 15000.00/- 20000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-04

ENQUIRY NOW
DETAILS
1 MONTH

CERTIFICATE IN BASIC EXCEL COURSE ( S-01 )

  • Course Fees : 3000.00/- 5000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : S-01

ENQUIRY NOW
DETAILS
1 MONTH

CERTIFICATE IN ADVANCED EXCEL ( S-03 )

  • Course Fees : 3000.00/- 5000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : S-03

ENQUIRY NOW
DETAILS
2-3 MONTHS

CERTIFICATE IN BASIC TO ADVANCED EXCEL ( M-05 )

  • Course Fees : 5000.00/- 8000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-05

ENQUIRY NOW
DETAILS
3 MONTHS

CERTIFICATE IN FINANCIAL ACCOUNTING (CFA) ( M-06 )

  • Course Fees : 6000.00/- 9000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-06

ENQUIRY NOW
DETAILS
6 MONTHS

CERTIFICATE IN SCHOOL COMPUTER COURSE ( M-8 )

Course Code : M-8

ENQUIRY NOW
DETAILS
6 MONTHS

CERTIFICATE IN SCHOOL COMPUTER COURSE ( M-8 )

Course Code : M-8

ENQUIRY NOW
DETAILS
1 MONTH

CERTIFICATE IN BASIC EXCEL COURSE ( S-01 )

  • Course Fees : 3000.00/- 5000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : S-01

ENQUIRY NOW
DETAILS
1 MONTH

CERTIFICATE IN ADVANCED EXCEL ( S-03 )

  • Course Fees : 3000.00/- 5000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : S-03

ENQUIRY NOW
DETAILS
6 MONTHS

DIPLOMA IN COMPUTER APPLICATION ( M-01 )

  • Course Fees : 9000.00/- 11000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-01

ENQUIRY NOW
DETAILS
03 MONTHS

CERTIFICATE IN BASIC COMPUTER COURSE ( M-02 )

  • Course Fees : 4500.00/- 6000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-02

ENQUIRY NOW
DETAILS
9 MONTHS

DIPLOMA IN FINANCIAL ACCOUNTING (DFA) ( M-03 )

  • Course Fees : 12000.00/- 15000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-03

ENQUIRY NOW
DETAILS
12 MONTHS

ADVANCED DIPLOMA IN COMPUTER APPLICATION (ADCA) ( M-04 )

  • Course Fees : 15000.00/- 20000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-04

ENQUIRY NOW
DETAILS
2-3 MONTHS

CERTIFICATE IN BASIC TO ADVANCED EXCEL ( M-05 )

  • Course Fees : 5000.00/- 8000.00/-

  • Minimum Amount To Pay : Rs.1000.00

Course Code : M-05

ENQUIRY NOW
DETAILS
NSDC
SKILL INDIA
Niti Aayog
MSME
ISO 9001:2015
ISO
JustDial
Tally Prime