ODISHA INSTITUTE OF COMPUTER APPLICATION

₹3,500 ₹5,000

Course Includes

Duration3 Months
Enrolled0
Lectures1
Videos0
Notes0
CertificateYes

What you'll learn

The Advance Excel Course is a practical, career-focused program designed to develop advanced skills in data analysis, reporting, and automation using Microsoft Excel. This course is ideal for students, professionals, accountants, analysts, and business owners who want to work efficiently with large datasets and create dynamic reports.

Course Syllabus

Module 1: Excel Basics Revision

Excel Interface & Ribbon
Workbook & Worksheet Management
Cells, Rows, Columns
Formatting Techniques

Module 2: Advanced Formulas & Functions

Logical Functions: IF, AND, OR
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
INDEX & MATCH
Text Functions
Date & Time Functions
Mathematical & Statistical Functions

Module 3: Data Tools

Data Validation
Text to Columns
Remove Duplicates
Flash Fill
Sorting & Filtering (Advanced Filter)

Module 4: Conditional Formatting

Highlight Rules
Formula-Based Formatting
Data Bars, Color Scales & Icon Sets

Module 5: Pivot Tables & Pivot Charts

Creating Pivot Tables
Grouping & Calculated Fields
Pivot Charts
Slicers & Timelines

Module 6: Charts & Data Visualization

Advanced Charts
Dynamic Charts
Combo Charts
Formatting Charts Professionally

Module 7: Power Query & Data Cleaning

Importing Data from Multiple Sources
Data Transformation
Cleaning & Shaping Data
Merging & Appending Queries

Module 8: Dashboard & MIS Reports

Dashboard Planning
Interactive Dashboards
KPI & MIS Reports
Linking Pivot Tables to Dashboards

Module 9: Macros & VBA (Basics)

Introduction to Macros
Recording & Running Macros
VBA Editor Basics
Automating Simple Tasks

Module 10: Practical & Project Work

Real-Time Business Case Studies
Dashboard Project
Final Practical Assessment

Course Fees

₹5000/-

Discounted Fees

₹ 3500/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

ADVANCE EXCEL(S-E-5990)