BFSI IT Professional Program in Lucknow

# Module 1: Computer & Digital Productivity (8 Hours)

* Windows Productivity
* Internet & Cloud Storage
* Professional Email (Outlook/Gmail)
* MS Office Overview
* Keyboard Shortcuts
* PDF Tools
* ZIP/RAR
* Google Drive & OneDrive

### Practical

* Professional email creation
* Digital document management
* File sharing

---

# Module 2: Advanced Excel (30 Hours)

### Excel Basics

* Formatting
* Tables
* Named Ranges
* Data Validation

### Formulas

* IF
* Nested IF
* SUMIF
* COUNTIF
* XLOOKUP
* INDEX & MATCH
* TEXT Functions
* Date & Time Functions

### Advanced Excel

* Pivot Tables
* Pivot Charts
* Conditional Formatting
* Dashboard Design
* Power Query
* Data Cleaning

### Projects

* Banking MIS Dashboard
* Loan EMI Calculator
* Sales Dashboard
* Attendance System

---

# Module 3: SQL Database (24 Hours)

* Database Concepts
* MySQL Installation
* CREATE
* INSERT
* UPDATE
* DELETE
* SELECT
* WHERE
* ORDER BY
* GROUP BY
* HAVING
* JOIN
* Views
* Stored Procedures (Introduction)

### Practical

* Customer Database
* Employee Database
* Banking Transactions
* Loan Database

---

# Module 4: Python Programming (32 Hours)

### Core Python

* Variables
* Operators
* Conditions
* Loops
* Functions
* File Handling

### Data Analysis

* Pandas
* NumPy

### Automation

* Excel Automation
* CSV Processing
* Report Generation
* Data Cleaning

### Projects

* Salary Report Generator
* Excel Automation Tool
* Customer Data Analysis

---

# Module 5: Power BI (24 Hours)

* Installation
* Import Data
* Data Cleaning
* Relationships
* DAX Basics
* Charts
* KPI Cards
* Drill Down
* Interactive Dashboards
* Publishing Reports

### Project

* Banking Analytics Dashboard

---

# Module 6: AI Tools for Office Productivity (16 Hours)

* ChatGPT
* Microsoft Copilot
* Prompt Engineering
* AI for Excel
* AI for SQL
* AI for Python
* AI Report Writing
* AI Presentation Creation

### Practical

* Generate Reports
* Data Analysis with AI
* Email Drafting
* Dashboard Insights

---

# Module 7: Git & GitHub (8 Hours)

* Version Control
* Git Installation
* Repository Creation
* Clone
* Commit
* Push
* Pull
* Branches
* Portfolio Management

---

# Module 8: PowerPoint & Business Presentation (10 Hours)

* Professional Slides
* SmartArt
* Icons
* Charts
* Animation
* Presentation Skills

### Project

* Financial Performance Presentation

---

# Module 9: Business Analytics (16 Hours)

* Data Cleaning
* KPIs
* Trend Analysis
* Financial Reporting
* Data Visualization
* Dashboard Design

---

# Module 10: Capstone Project (24 Hours)

Students will build a complete analytics solution using:

* Excel
* SQL
* Python
* Power BI
* AI Tools

### Sample Projects

* Banking Dashboard
* Loan Analytics Dashboard
* Customer Analytics System
* Sales Analytics Dashboard
* Financial MIS Dashboard

---

# Industry Software Covered

* Microsoft Excel
* MySQL
* Python
* Visual Studio Code
* Power BI Desktop
* Git & GitHub
* ChatGPT
* Microsoft Copilot
* Google Workspace
* Microsoft 365