Course Information

Level: Advanced
Starts on: Any time
Duration: 1 Month
Time: 8:00am to 9:00pm
Location: Sec - 45 / Sec-66 (Noida)
Prerequisite: Basic Excel
Mode of Course: Offline / Online
Amount: ₹ 3,000/-

Register Now

| Syllabus

Microsoft Advanced 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

You may also be interested in

Course Information

| Syllabus

Microsoft Advanced 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.

BRANCH

TIMING

OFFICE WORK COURSES

OFFICE WORK COURSES

FOLLOW US