logo
Courses Gallery Brochure Student Login Certificate Verification School Login

Course Information

Level:                          Beginner
Starts on:                   Any time
Duration:                    2-3 Months
Time:                           8:00am to 9:00pm
Location:                    Sec - 45 / Sec-66 (Noida)
Prerequisite:               BCC Course
Mode of Course:        Offline / Online
Amount:                       ₹ 5,000/-

Register Now

| Syllabus

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

Course Features


Individual Class

Every student is important for us so we teach individually to our students.


Revision Series

After completion of course we revise every topic again to our students.


Test Series

Every Saturday we take oral & written test to improve our students verbal skills


Certification

After completion of course we provide certification to our students.


Study Pattern

We teach our students by using notes which is organize by senior Instructors.


Job Opportunity

We provide job opportunity to our students after completion of course.

  +91- 9999 222 314, +91- 8383 890 706
  info.excellenteducationalhub@gmail.com

BRANCH

Branch 1: Sadarpur sec 45 Noida, 201301
Branch 2: Mamura sec 66 Noida, 201301


TIMING

Monday to Saturday - 08:00 AM to 09:00 PM

Sunday - 10:00 AM to 08:00 PM

OFFICE WORK COURSES

  ADCA
  PGDCA
  DCA & DFA
  Advanced Excel
  Tally Prime & See all Courses

OFFICE WORK COURSES

  C & C++ Programming
  Java Programming
  Web Development & See all Courses

FOLLOW US

WhatsApp us 

© Copyright 2023 Excellent Educational Hub Pvt. Ltd. All Rights Reserved

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
𝕏
Excellent Educational Hub 2025 Privacy policy Terms of use Contact us Refund policy