SATYA EDUTECH

₹5,000

Course Includes

Duration3 Months
Enrolled0
Lectures50
Videos0
Notes0
CertificateYes

What you'll learn

The OCOC Advanced Excel course (120 hours) focuses on empowering professionals to manage, analyze, and visualize data, covering advanced formulas, Pivot tables, dashboards, Power Query, Macros, and Data Management. Key areas include data cleaning, modeling, and automated reporting to support decision-making in accounting, finance, and general business roles.

Course Syllabus

OCOC Advanced Excel Syllabus Key Topics

Data Management & Formatting: Advanced data entry, formatting, validation, sorting, filtering, and using data tools.
Functions & Formulas: Advanced text, lookup, logical, mathematical, and financial functions (e.g., IF, VLOOKUP, INDEX MATCH).
Data Analysis & Visualization: Creating Pivot tables, pivot charts, and interactive dashboards.
Advanced Features: Using Power Query, Scenarios, Goal Seek, and Sparklines.
Macros & Automation: Recording, editing, and running Macros to automate tasks.
Security & Collaboration: Protecting, sharing, and reviewing workbooks.

This course is designed to improve efficiency, accuracy, and reporting capabilities for professionals working with large datasets.

Course Fees

₹5000/-

Discounted Fees

₹ 5000/-

Course Duration

3 Months

Review

0.0

Course Rating (0 reviews)

Featured review

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

ADVANCED EXCEL (OCOC)(S-E(-4838)

Course Includes

What you'll learn

Course Syllabus

Course Fees

Review

Featured review

More Popular Courses

OS-CIT COURSES - CERTIFICATE COURSE IN OS-CIT(S-C-2886)

OS-CIT COURSES - CERTIFICATE COURSE IN OSCIT 'A'(S-C'-6776)

Related Courses

ARTIFICIAL INTELLIGENCE(S-E-6175)

WEB DESIGNING(S-D-2148)

PYTHON PROGRAMMING(S-P-1259)