₹1,999 ₹2,500

Duration30 Days
Enrolled0
Lectures50
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Excel – Course Description

The Advanced Excel course at Computech is a practical, job-oriented program designed to make students proficient in data analysis, reporting, and automation using Microsoft Excel. Learn advanced formulas, functions, charts, PivotTables, macros, and dashboards to manage and interpret data effectively for business and office use.

Ideal for students, professionals, and anyone aiming for careers in accounts, finance, data analysis, or office administration.

Course Syllabus

Syllabus Overview

Module 1: Excel Basics Recap

Excel Interface & Ribbon Overview
Workbook & Worksheet Management
Data Entry, Formatting & Validation

Module 2: Advanced Formulas & Functions

Mathematical & Statistical Functions
Logical Functions (IF, AND, OR, Nested IF)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Text Functions & Date/Time Functions
Error Handling Functions (IFERROR, ISERROR)

Module 3: Data Analysis Tools

Sorting & Filtering Data
Conditional Formatting
Data Validation & Drop-down Lists
What-If Analysis (Goal Seek, Scenario Manager)

Module 4: Pivot Tables & Pivot Charts

Creating Pivot Tables & Pivot Charts
Grouping, Filtering & Slicing Data
Summarizing Data for Reports
Dashboard Preparation

Module 5: Charts & Visualization

Column, Line, Pie, Bar, Area Charts
Combo Charts & Sparklines
Chart Formatting & Customization

Module 6: Macros & Automation

Introduction to Macros & VBA Basics
Recording Macros
Running & Managing Macros
Automating Repetitive Tasks

Module 7: Advanced Reporting

Dashboards & Interactive Reports
Data Consolidation & Linking
Scenario Analysis & Forecasting

Module 8: Practical Projects

Business Reports
Sales / Inventory Dashboard
Financial Analysis & Forecasting
Real-time Mini Projects

Course Duration & Lectures

Total Lectures: 40–50
Lecture Duration: 1.5–2 hours each
Mode: Practical + Theory
Outcome: Students will become proficient in Advanced Excel for professional reporting, analysis, and office automation.

Course Fees

₹2500/-

Discounted Fees

₹ 1999/-

Course Duration

30 Days

Review

0.0

Course Rating (0 reviews)

Featured review

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

Microsoft Advance Excel(S-E-5214)

What you'll learn

Advanced Excel – Course Description

Course Syllabus

Syllabus Overview

Module 1: Excel Basics Recap

Module 2: Advanced Formulas & Functions

Module 3: Data Analysis Tools

Module 4: Pivot Tables & Pivot Charts

Module 5: Charts & Visualization

Module 6: Macros & Automation

Module 7: Advanced Reporting

Module 8: Practical Projects

Course Duration & Lectures

Course Fees

Review

Featured review

More Popular Courses

Certification In Microsoft Office(S-MO-6474)

Certification In Tally Prime 6.2(S-TP6-1448)

Related Courses

Advance Diploma In Computer Application(S-CA-2790)

Certification In Python(S-P-2095)

Certification In Advance Python + AI(S-AP+A-1595)