Module 1: Excel Refresher (Basics)

• Excel interface overview
• Workbook, worksheet, rows, columns, cells
• Data types (text, number, date)
• Basic formatting & shortcuts
• Basic formulas: SUM, AVERAGE, MIN, MAX

Module 2: Advanced Formulas & Functions

A. Logical Functions

• IF, IFERROR, AND, OR, NOT
• Nested IF statements
• SWITCH function (Excel 2016+)

B. Lookup & Reference Functions

• VLOOKUP, HLOOKUP
• INDEX & MATCH
• XLOOKUP (Excel 365 / 2021)
• ROW, COLUMN, ADDRESS

C. Text Functions

• CONCAT / CONCATENATE
• LEFT, RIGHT, MID
• LEN, TRIM, UPPER, LOWER, PROPER
• REPLACE, SUBSTITUTE
• TEXT & VALUE

D. Date & Time Functions

• TODAY(), NOW()
• DATE, DAY, MONTH, YEAR
• NETWORKDAYS, WORKDAY
• EOMONTH, DATEDIF

E. Mathematical & Statistical Functions

• ROUND, ROUNDUP, ROUNDDOWN
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• AVERAGEIF, AVERAGEIFS

Module 3: Data Tools & Analysis

• Data validation (drop-downs, rules)
• Conditional formatting (basic & formula-based)
• Remove duplicates & text to columns
• Goal Seek
• Scenario Manager
• Solver basics

Module 4: Pivot Tables & Pivot Charts

• Creating Pivot Tables
• Grouping & summarizing data
• Pivot Charts
• Calculated fields & items
• Filtering & slicers
• Drill-down & reporting

Module 5: Charts & Visualization

• Column, Bar, Line, Pie, Area charts
• Combo charts
• Sparklines
• Dynamic charts with named ranges
• Conditional formatting visualization

Module 6: Advanced Data Analysis

• Power Query basics
• Importing & transforming data
• Cleaning & merging datasets
• Power Pivot basics
• Relationships between tables
• DAX formulas introduction (SUMX, CALCULATE, RELATED)

Module 7: Macros & VBA Basics

• Introduction to macros
• Recording & running macros
• VBA editor overview
• Writing simple VBA scripts
• Creating user-defined functions
• Automating repetitive tasks

Module 8: Advanced Excel Techniques

• Named ranges & dynamic ranges
• Array formulas
• INDEX-MATCH for dynamic lookups
• OFFSET & INDIRECT for dynamic ranges
• Advanced filtering
• Using Tables (Excel Table feature)

Module 9: Dashboards & Reporting

• Interactive dashboards with slicers & pivot tables
• Charts & KPIs in dashboards
• Using form controls
• Dynamic reports
• Dashboard best practices

Module 10: Projects & Case Studies

• Sales analysis dashboard
• Inventory management tracker
• Employee performance tracker
• Financial statement analysis
• Dashboard for business metrics
• Real-time data reporting (Power Query)

Module 1: Introduction to Python

• What is Python?
• Features & applications
• Installation of Python & IDEs (IDLE / PyCharm / VS Code / Jupyter)
• Python interpreter & script mode
• Writing and executing Python programs
• Understanding indentation
• Comments & documentation strings

Module 2: Python Basics

• Variables and data types
• Keywords and identifiers
• Input & output functions
• Type conversion and type casting
• Operators (Arithmetic, Logical, Bitwise, Comparison)
• Expressions & statements

Module 3: Control Flow Statements

• If, if-else, nested if
• For loop, while loop
• break, continue, pass statements
• Loop else clause

Module 4: Data Structures in Python

A. List

• Creating lists
• Indexing & slicing
• List methods
• List comprehension

B. Tuple

• Tuple operations
• Tuple unpacking

C. Set

• Creating sets
• Set operations (union, intersection, etc.)

D. Dictionary

• Key-value pairs
• Dictionary methods
• Nested dictionaries

E. String Handling

• String functions
• String slicing
• String formatting

Module 5: Functions

• Defining & calling functions
• Function arguments (default, keyword, variable length)
• Recursion
• Lambda functions
• Modules & packages
• Using pip to install packages

Module 6: File Handling

• Opening/closing files
• Reading/writing files
• Working with text, CSV & JSON files
• Exception handling with files

Module 7: Object-Oriented Programming (OOP) in Python

• Classes & objects
• Constructors
• Inheritance (single, multiple, multilevel)
• Polymorphism
• Encapsulation
• Abstraction
• Method overriding
• Destructor

Module 8: Python Libraries (Essential)

• math module
• random module
• datetime module
• os module
• sys module

Module 9: Exception Handling

• Types of errors
• try, except, else, finally
• raising exceptions
• custom exceptions

Module 10: Regular Expressions

• regex patterns
• search, match, findall
• character classes & quantifiers

Module 11: Working with Databases

• SQL basics
• Connecting Python with MySQL / SQLite
• CRUD operations
• Using mysql.connector / sqlite3

Module 12: GUI Programming (Tkinter)

• Tkinter window basics
• Labels, buttons, textboxes
• Frames & layouts
• Events & functions
• Mini-projects (calculator, login page, etc.)