Glare IT Campus Pvt Ltd Valanchery

Bestseller

0 rating

Accounting In Advanced Excel 365(S-AAE3-5140)

Last updated Aug, 2026
Certified Course

Course Includes

Duration6 Months
Enrolled4
Lectures2
Videos0
Notes0
CertificateYes

What you'll learn

The Advanced Excel 365 Course is designed to help students and professionals master Microsoft Excel for data analysis, reporting, automation, and business productivity. The course covers advanced formulas, functions, PivotTables, dashboards, Power Query, data visualization, and Excel automation techniques. Through practical exercises and real-world business scenarios, learners will gain the skills required to work efficiently in accounting, administration, finance, HR, and business analytics roles.

Show More

Course Syllabus

Introduction to Microsoft Excel 365
Excel Interface & Productivity Tips
Cell Formatting & Conditional Formatting
Advanced Formulas & Functions
IF, IFS, AND, OR
VLOOKUP, HLOOKUP, XLOOKUP
INDEX & MATCH
SUMIF, SUMIFS, COUNTIF, COUNTIFS
TEXT, DATE & TIME Functions
FILTER, SORT & UNIQUE Functions
Data Validation & Drop-Down Lists
Named Ranges
PivotTables & Pivot Charts
Charts & Data Visualization
Interactive Dashboards
Data Cleaning & Text Functions
What-If Analysis (Goal Seek & Scenario Manager)
Power Query Basics
Data Import & Transformation
Excel Tables & Structured References
Protecting Worksheets & Workbooks
Business Reports & MIS Reporting
Basic Excel Automation (Macros Introduction)
Practical Business Case Studies
Resume Preparation & Interview Skills
Certification & Placement Assistance

Review

0.0

Course Rating (0 reviews)

0%

0%

0%

0%

0%

Featured review

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

Copyright © 2026 DITRP INDIA. All Rights Reserved

Review