Course Syllabus
BASIC COMPUTER
- Introduction To Computers
- Notepad
- Wordpad
MS-OFFICE
- Create and Save Document
- Text Formatting (Font, Bold, Italic)
- Paragraph Alignment
- Page Setup (Margins, Orientation)
- Insert Table and Picture
- Add Page Numbers, Header & Footer
- Spell Check
- Print and Save as PDF
- Basic Keyboard Shortcuts
- Create, Open, Save Workbook
- Entering and Editing Data
- Cell Formatting (Font, Color, Border)
- Basic Formulas (SUM, AVERAGE, MAX, MIN)
- Use Of Autofill
- Inserting Rows,Columns, and sheets
- Sorting and Filtering Data
- Print and Save as PDF
- Create and Save Presentation
- Insert New Slides and Layouts
- Add and Format Text
- Insert Pictures and Shapes
- Apply Design Themes
- Use Transitions Between Slides
- Add Animations to Objects
- Slide Show (Start and Navigate)
- Save as PDF or Video
- Introduction To Outlook
- Composing and Sending Email
- Inbox Organization
- Email Attachments
- Email Signatures
- Calender Management
- Creating Appointments & Meetings
- Contacts Management
- Tasks and To-Do List
- Search and Filters
- INTRODUCTION TO INTERNET & EMAIL
TYPING (ENGLISH) 30/40 WPM
- Introduction To Typing
- Typing Fundamentals
- Typing Speed & Accuracy
- Basic Typing Techniques
- Speed Building
- Typing Lessons
- Progress Tracking
- Best Guidance
ADVANCED EXCEL
- Marksheet
- Salarysheet
- Attendance Sheet
- EMI Chart
- Conditional Formatting
- Charts
- Flash Fill
- Subtotal
- Filtering Data
- Name Manager
- Advance Filter
- Data Validation
- Vlookup
- Hlookup
- Xlookup
- Pivot Table
- Pivot Charts
- Field List
- Slicer
- Timeline
- Report Connection
- Freeze Panes
- Macro
- If Function
- SumIf Function
- CountIf Function
- CountIfs Function
- Invoice
- VBA Code
- ChatGPT In Excel
CHATGPT
- Introduction To AI & ChatGPT
- History Of Open AI & Generative AI
- How ChatGPT works (Language Models & Tokens)
- Version of ChatGPT (GPT-3.5,GPT-4,GPT-40)
- Use Cases In Daily Life, Business & Education
- Prompting Fundamentals
- How To ChatGPT Works (Prompt+Completion)
- Productivity & Creativity With ChatGPT
- ChatGPT For Technical Users
- Multimodal & Tool Use