ET AND T COMPUTER EDUCATION & TRAINING

Bestseller

0 rating

CERTIFICATE In ADVANCE EXCEL 365(S-PAE3-1958)

Last updated Sep, 2026
Certified Course

₹7,700 ₹10,000

Buy Now

Enquire Now

Course Includes

Duration2 Months
Enrolled0
Lectures20
Videos0
Notes0
CertificateYes

What you'll learn

ET&T COMPUTER EDUCATION & TRAINING

🚀 ADVANCED EXCEL 365 – PROFESSIONAL COURSE

🎯 Course Overview

Upgrade your Excel skills from basic spreadsheet work to professional-level data analysis, reporting and dashboard creation using Microsoft Excel 365.

⭐ ET&T Career Benefits

✅ Professional Training

✅ Practical Assignments

✅ Real-World Projects

✅ Experienced Faculty

✅ Interview Preparation

✅ Resume Guidance

✅ Career Guidance

✅ Placement Assistance / Job Support

✅ Course Completion Certificate

Course Syllabus

📚 Detailed Course Coverage

Module 1 – Excel 365 Advanced Fundamentals

Excel 365 interface & advanced options
Workbook & worksheet management
Advanced formatting
Named ranges
Tables & structured references
Data validation
Advanced printing & page setup

Module 2 – Advanced Excel Formulas & Functions

IF, IFS, AND, OR
SUMIFS, COUNTIFS, AVERAGEIFS
XLOOKUP
VLOOKUP & HLOOKUP
INDEX & MATCH
FILTER, SORT & UNIQUE
TEXT functions
DATE & TIME functions
Logical & Statistical functions
Dynamic Array formulas
Error handling
Formula auditing

Module 3 – Data Management & Cleaning

Sorting & advanced filtering
Remove duplicates
Text to Columns
Flash Fill
Data cleaning techniques
Handling missing & incorrect data
Data validation
Importing external data

Module 4 – Pivot Tables & Pivot Charts

Creating Pivot Tables
Grouping & filtering
Calculated fields
Slicers & Timelines
Pivot Charts
Interactive reports
Management reporting

Module 5 – Data Visualization & Dashboards

Professional charts
Combo charts
Conditional formatting
KPI indicators
Interactive dashboards
Slicers
Management dashboards
Sales & performance dashboards

Module 6 – What-If Analysis

Goal Seek
Scenario Manager
Data Tables
Forecasting
Basic business modelling

Module 7 – Excel Automation

Introduction to Macros
Recording macros
Automating repetitive tasks
Practical automation examples

💻 Practical Training

100% Practical & Job-Oriented Approach

Students work on real-world datasets and learn how to convert raw data → clean data → analysis → professional reports → interactive dashboards.

Eligibility

Who can apply for this course

🎓 Eligibility

Students & Graduates
B.Com / BBA / MBA
Working Professionals
MIS Executives
Accounts Professionals
HR & Administration Professionals
Sales & Marketing Professionals
Business/Data Analysts

Course Fees

₹10000/-

Discounted Fees

₹ 7700/-

Course Duration

2 Months

Review

0.0

Course Rating (0 reviews)

Featured review

No reviews yet. Be the first to review this course!

Please provide your details to continue with the purchase

First Name *

Last Name *

Mobile Number *

Email *

Password *

Date of Birth *

Pincode *

Address *

Total Amount:

Call

Text Message

Review

Brochure

CHAT

CERTIFICATE In ADVANCE EXCEL 365(S-PAE3-1958)

Course Includes

What you'll learn

ET&T COMPUTER EDUCATION & TRAINING

🚀 ADVANCED EXCEL 365 – PROFESSIONAL COURSE

🎯 Course Overview

⭐ ET&T Career Benefits

Course Syllabus

📚 Detailed Course Coverage

💻 Practical Training

Eligibility

🎓 Eligibility

Course Fees

Review

Featured review

More Popular Courses

CERTIFICATE In Industry-Oriented Internship(Mechanical)(S-CII-6296)

CERTIFICATE In Skill Development & Internship (civil)(S-CSD&I(-1452)

Related Courses

CERTIFICATE In SAP MM(S-PSM-1221)

CERTIFICATE In AUTOCAD 2026 PROFESSIONAL(S-CA2P-6492)

DIPLOMA In DATA ANALYTICS(M-DDA-8285)