Basic Computing + Advance Excel – Full Syllabus

PART 1: BASIC COMPUTING

1. Computer Fundamentals

• What is Computer
• Types of Computer
• Hardware & Software
• Input/Output Devices
• Storage Devices
• Booting & Shutdown process
• Parts of Desktop Screen

2. Operating System (Windows)

• Windows interface
• Taskbar, Start Menu
• File & Folder Management
• Copy, Paste, Rename, Delete
• Creating Shortcuts
• Using Notepad & WordPad
• Control Panel basics
• Display & Personalization settings

3. Typing Training

• English Typing Basics
• Home Row Keys
• Speed & Accuracy Practice
• Online Typing Tools

4. Internet & Email

• What is Internet
• Browser usage (Chrome)
• Downloading & Uploading files
• Email account creation
• Sending attachments
• Email etiquette
• Google Drive, Google Docs basics

5. MS Office Basics

MS Word

• Text typing & formatting
• Paragraph settings
• Bullets & Numbering
• Tables
• Page setup
• Resume creation

MS PowerPoint

• Slides creation
• Templates
• Text & images
• Transitions & Animations
• Presentations basics

PART 2: ADVANCE EXCEL

1. Excel Basics

• Excel Interface
• Workbook/Worksheet
• Rows, Columns, Cells
• Basic Formatting
• Number Formatting (Date, Currency, %, etc.)
• Basic Formulas:
• SUM, AVERAGE, MIN, MAX
• COUNT, COUNTA
• Percentage formulas

2. Data Handling Tools

• AutoFill & Flash Fill
• Sorting (Single & Multi-Level)
• Filtering (Auto, Custom)
• Remove Duplicates
• Text to Columns
• Data Cleaning Techniques
• TRIM, PROPER, UPPER, LOWER

3. Intermediate Formulas

• IF, AND, OR, NOT
• Text Functions: LEFT, RIGHT, MID, LEN, CONCAT
• Date Functions: TODAY, NOW, DATEDIF, MONTH, YEAR
• Lookup Functions:
• VLOOKUP
• HLOOKUP
• XLOOKUP (if needed)

4. Advanced Excel

• INDEX + MATCH
• Nested IF
• SUMIF, SUMIFS
• COUNTIF, COUNTIFS
• FILTER, UNIQUE, SORT
• INDIRECT
• Error Handling Functions:
• IFERROR, ISBLANK, ISNUMBER

5. Data Analysis Tools

• Pivot Table
• Pivot Chart
• Grouping
• Slicers
• Data Consolidation
• What-If Analysis
• Goal Seek
• Scenario Manager

6. Charts & Dashboards

• Column, Line, Pie Charts
• Combo Charts
• Trendlines
• Sparklines
• KPI Charts
• Creating Professional Dashboards

7. Data Validation & Protection

• Drop-down lists
• Restrict data entries
• Protect Sheet
• Protect Workbook
• Lock & unlock cells

8. Reporting & MIS

• Sales Report
• Purchase Report
• Attendance Sheet
• Stock & Inventory Sheet
• Expense & Profit Sheet
• Bank Reconciliation Format
• Automated Business Templates

9. Productivity & Automation (Non-Macro)

• Keyboard Shortcuts
• Dynamic Ranges
• Template Creation
• Time-saving techniques

10. Practical Projects

• Full MIS Project
• Dashboard Creation
• Lookup-based project
• Data cleaning & analysis project
• Monthly Report preparation project