- 8929450961
- infomdnie@gmail.com
COMPUTER COURSES
Basic Computer And Advance Excel (6 Months)
(Advance Excel) -- (6 Month)
Duration: 6 Months
Eligibility: 10th , 12th Pass
Modules
Computer Fundamentals
- Introduction to computers
- Hardware & software
- Operating system (Windows)
- File & folder management
- Keyboard shortcuts
- Basic computer maintenance
MS Word & Office Basics
- Creating & editing documents
- Formatting text & pages
- Tables, letters & reports
- Resume & office document creation
- Printing & file management
MS Excel Basics
- Excel interface & worksheets
- Data entry in rows & columns
- Basic formulas (SUM, AVERAGE, COUNT)
- Formatting cells
- Sorting & filtering data
Advanced Excel (Formulas & Functions)
- Logical functions (IF, AND, OR)
- Lookup functions (VLOOKUP, HLOOKUP)
- Text & date functions
- Conditional formatting
- Data validation
Advanced Excel (Analysis Tools)
- Pivot Tables & Pivot Charts
- Charts & graphs
- Dashboard basics
- Data cleaning techniques
- What-If Analysis
Internet, Practical & Job Skills
- Internet & email usage
- Online forms & data handling
- Real-life Excel projects
- Speed & accuracy practice
- Resume preparation & interview tips