OCOC Advanced Excel
Master professional Excel skills including advanced formulas, dashboards, pivot tables, macros, and data analysis. Build powerful reports and become job-ready for MIS and office roles.
Bestseller4.8★★★★★(1240 ratings)1000+ students
Created by IBRAIN
Last updated Feb 2026
ENGLISH, HINDI, ODIA
ENGLISH, HINDI, ODIA
₹4,000₹6,00025% OFF
Enroll NowThis course includes:
- 144 hrs on-demand video & eLearning
- Access on mobile, tablet & desktop
- Illustrated OS-CIT book (3 languages)
- OSOU University Certificate
- Internal exam from home (ERA Live App)
- 50+ modern AI tools included
What you'll learn
Use advanced Excel formulas and functions
Create professional dashboards using Pivot Tables
Analyze large datasets using Power Query
Use advanced charts and data visualization tools
Automate work using Excel Macros
Apply What-If analysis and scenario tools
Manage and share workbooks professionally
Organize and structure business data efficiently
Requirements
- Basic knowledge of computers
- Laptop or desktop with Microsoft Excel
- Interest in data analysis and office work
- Basic understanding of spreadsheets (helpful but not mandatory)
- Internet connection for practice and assignments
Introduction
OCOC Advanced Excel is a career-oriented course designed to build professional spreadsheet and data analysis skills. The course helps learners work efficiently with large datasets, create dynamic dashboards, automate tasks using macros, and generate meaningful reports for business decision-making.
This program is ideal for students, office professionals, and job seekers who want to strengthen their Excel expertise and pursue roles in MIS reporting, back-office management, and business analytics.
Eligibility & Medium of Instruction
Eligibility
• Anyone who has passed Class 10 or above can enroll
• Basic computer knowledge is recommended
• Students, job seekers, office staff, and entrepreneurs can join
Medium of Instruction
• Odia
• English
Study materials and support are provided in both languages.
Course Duration
Duration: 3 Months (120 Hours)
The course includes practical training sessions, guided exercises, and project-based learning. Students practice real-world data analysis tasks and reporting techniques using Microsoft Excel.
About the Certificate
After successfully completing the course and assessment, learners receive an OCOC Advanced Excel Certificate.
The certificate is issued through OKCL and recognized by Odisha State Open University (OSOU). It validates professional Excel skills and can be used for employment in offices, business operations, MIS reporting, and data management roles.
Course content
9 sections · 300+ Lectures • 120 Hours · 3 Months (120 Hours) total length
▶Introduction to data management
▶Organizing professional data
▶Metadata and Big Data basics
▶Data entry practices
▶Freelance data entry opportunities
▶Custom data formats
▶Advanced fill options
▶Conditional formatting
▶Custom templates and styles
▶Workbook layouts
▶Area charts
▶Scatter charts
▶Radar charts
▶Stock charts
▶Custom chart templates
▶Sparklines
▶Pivot tables
▶Pivot charts
▶Dashboard creation
▶Power Query
▶Using macros
▶Data tables
▶Pivot-based dashboards
▶Power Query analysis
▶What-If analysis
▶Scenario creation
▶Scenario merging
▶Scenario summary reports
▶Version management
▶Track changes
▶Workbook sharing
▶External data connections
▶Mathematical functions
▶Financial functions
▶Text functions
▶Lookup functions
▶Date & time functions
▶Arrays
▶PDF to Word conversion
▶Data analysis practice
▶Excel reporting exercises
Examination Details
Internal Examination — 50 Marks
ModeOnline from Home
PlatformMKCL ERA Live App
TypesTyping + MCQ + Practical
Pass Mark20 / 50
Negative MarkingNone ✅
Final Examination — 50 Marks
ModeIn-Person at Centre
CentreIBRAIN, Kantabania / Chhatrapda
TypeMCQ Only (4 options)
Duration60 minutes
Re-exam Fee₹250 if absent/fail
💡 Practice Test Available: Before the Final Exam, a free Practice Test can be taken from home.
Who this course is for:
- Students wanting advanced Excel skills
- Job seekers preparing for MIS or office roles
- Accountants and office staff working with reports
- Entrepreneurs managing business data
- Anyone wanting professional spreadsheet and data analysis skills
Instructor
IBRAIN
Official OKCL Partner • Odisha's Leading IT Training Academy
⭐ 4.8 Rating💬 1240 Reviews👥 1000+ Students📚 5+ Courses
I
IBRAIN is an authorized OKCL training partner providing professional IT and career-oriented courses across Odisha. The institute focuses on practical digital skills including computer literacy, data analysis, office productivity, and software training. Thousands of students have successfully completed government-recognized certifications through IBRAIN.
Student feedback
4.8
★★★★★
Course Rating
78%★★★★★
14%★★★★☆
6%★★★☆☆
1%★★☆☆☆
1%★☆☆☆☆
S
Sanjay Behera
★★★★★
Excellent course for learning advanced Excel skills. The dashboard and pivot table training helped me a lot in my office work.
P
Priyanka Sahu
★★★★★
Very practical training. I learned formulas, charts, and data analysis which are useful for MIS reporting.