Module 1: MS Office – Fundamentals

• Introduction to MS Office
• Office productivity and file management
• Creating, saving, editing and printing documents
• Keyboard shortcuts
• Professional document management

MS Word

• Document creation and formatting
• Page setup and layout
• Tables, images, shapes and SmartArt
• Headers, footers and page numbering
• Styles and templates
• Mail Merge
• Track Changes and comments
• PDF creation and conversion

MS PowerPoint

• Creating presentations
• Slide layouts and themes
• Text, images, shapes and SmartArt
• Tables and charts
• Transitions and animations
• Audio and video
• Slide Master
• Professional presentation design

Module 2: MS Excel – Basic to Intermediate

• Workbook and worksheet management
• Data entry and formatting
• Cell references
• Basic formulas and functions
• SUM, AVERAGE, COUNT, MAX and MIN
• IF, COUNTIF and SUMIF
• Text and date functions
• Sorting and filtering
• Conditional formatting
• Data validation
• Charts and graphs
• Page setup and printing
• Practical: Marksheet, salary sheet and invoice

Module 3: Advanced Excel

• Advanced formulas and functions
• IF, AND, OR and nested IF
• VLOOKUP and HLOOKUP
• XLOOKUP
• INDEX and MATCH
• SUMIFS and COUNTIFS
• Text functions
• Date and time functions
• Logical and statistical functions
• Named ranges
• Advanced sorting and filtering
• Advanced Conditional Formatting
• Pivot Tables
• Pivot Charts
• Slicers and Timelines
• What-If Analysis
• Goal Seek
• Data Tables
• Consolidation
• Remove Duplicates
• Flash Fill
• Excel Tables
• Dashboard creation
• Basic Excel automation and macros
• Practical: Sales Dashboard, MIS Report and Business Analysis

Module 4: MySQL – Database Management

Database Fundamentals

• Introduction to databases
• DBMS and RDBMS concepts
• Introduction to MySQL
• MySQL installation and setup
• Database and table concepts
• Primary Key and Foreign Key

SQL Commands

• Creating databases
• Creating and modifying tables
• INSERT
• SELECT
• UPDATE
• DELETE
• WHERE clause
• ORDER BY
• GROUP BY
• HAVING
• DISTINCT
• LIMIT

SQL Functions & Operations

• Aggregate functions
• String functions
• Date and time functions
• Mathematical functions
• Operators
• Aliases
• Constraints

Advanced MySQL

• Joins
• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• Subqueries
• Views
• Indexes
• Relationships between tables
• Basic database security
• Backup and restore
• Practical: Student Database / Employee Database / Sales Database

Module 5: HTML – Web Development

• Introduction to Web Development
• Internet, websites and web browsers
• HTML document structure
• HTML tags and attributes
• Headings and paragraphs
• Text formatting
• Links and navigation
• Images
• Ordered and unordered lists
• Tables
• Forms and input controls
• Audio and video
• iframe
• HTML5 semantic elements
• Header, navigation, section, article and footer
• Practical: Personal Profile and Registration Webpage

Module 6: CSS – Web Page Designing

• Introduction to CSS
• Inline, Internal and External CSS
• CSS syntax
• Selectors
• Class and ID selectors
• Colors and backgrounds
• Fonts and text formatting
• Borders and shadows
• Margin and padding
• CSS Box Model
• Display and positioning
• Flexbox
• CSS Grid
• Navigation menus
• Buttons and cards
• Form styling
• Responsive web design
• Media queries
• Mobile-friendly website design

Module 7: Integrated Practical Projects

Project 1 – Advanced Excel

Sales & Business Dashboard

• Data entry
• Formulas
• Lookup functions
• Pivot Tables
• Charts
• Dashboard

Project 2 – MySQL

Student Management Database

• Database creation
• Student table
• Course table
• Marks table
• Relationships
• SQL queries and reports

Project 3 – HTML & CSS

Responsive Institute Website

• Home page
• About Us
• Courses
• Faculty/Services
• Contact page
• Registration form
• Responsive design

Final Project

Create a complete business/institute project combining Advanced Excel reporting, MySQL database management, and HTML & CSS website development.