logo
Courses Gallery Brochure Student Login Certificate Verification School Login

Course Information

Level:                          Beginner
Starts on:                   Any time
Duration:                    6 Months
Time:                           8:00am to 9:00pm
Location:                    Sec - 45 / Sec-66 (Noida)
Prerequisite:               10th Pass
Mode of Course:        Offline
Amount:                       ₹ 9,000/-

Register Now

| Syllabus

Fundamental of Computer

 Computer Introduction

 WordPad 

 MS Paint, 3D Paint

 Folder Create/Update

 Snipping Tool

 RAM, HDD, ODD

 Short-Cut Keys

 Desktop Options

 Basic Mother-Board

 Notepad

 Etc.

Microsoft Word

 Why We Use MS Word

 Text Editing, Formatting

 Resume Making

 Table Creations

 Graphs & Layouts

 Shapes & Charts

 Pictures Formatting

 Screen-shorts & Other

 Header & Footer

 Format Making - 4

 Short-Cut Keys

 Print-Options

 Links/Cross References

 Maths Q/P Design

 Word to PDF Creation

 Password Protection

 Links/Cross References

 Design & Watermark

 Build in Themes

 Page Border & Color

 Layout & Page Setup

 References & Footnote

 Mail Merge Option

 Review & View

 Advanced Options

 Final Mini Project

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

Microsoft PowerPoint 

 Use of PowerPoint

 Text Editing, Formatting

 Slide Option & Tools

 SmartArt & Pictures

 Shapes & Charts

 Making Presentation

 Transition & It's Tools

 Timing & Sound

 Animations & It's Tools

 Poster Making

 Invitation Card Design

 Password Protection

 PPT to PDF Conversion

 PPT to Video Creation

 Slide Show Options

 Slide Size & It's Options

 Background Format

 Recording Slides

 Review & View

 Final Mini Projects

Microsoft Outlook

 Why We Use Outlook

 Account Creation

 Outlook v/s Gmail

 Email Management

 Office Apps Integration

 Calendar Management

 Tasks & To-Do List

 Contact Management

 Outlook Use in Office

Microsoft Publisher

 Why We Use Publisher

 Text Editing, Formatting

 Page design & It's Tools

 Custom Template

 Template Designing

 Flex Designing

 Certificate Designing

 Visiting Card Designing

 Page Setup & It's Tools

 Mail Merge in Publisher

 Party-Invitation Design

 Review & View

 Final Mini Projects

Internet with AI Tools

 Internet History

 PAN/LAN/MAN/WAN

 Remove Background

 PDF Editors & Tools

 Making QR Code of link

 Downloading Software

 ChatGPT AI Tool

 Gemini AI

 Server & Client

 Browsers & Websites

 Image Editing using AI

 Google Product & Services (Bonus)

 Google Docs

 Google Sheets

 Google Slides

 Google Sites

 Google Forms

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