Sustainable Construction
Lorem ipsum dolor...
| Computer Fundamentals | |||
| Computer Fundamentals | |||
|---|---|---|---|
| Introduction to Computers | |||
| Components of a Computer (Hardware & Software) | |||
| OS Systems & File Management | |||
| Basic Troubleshooting & Maintenance | |||
| MS Word, Ms-PowerPoint | |||
| Ms-Word : Document Formatting (Fonts, Styles, Paragraphs, Tables) | |||
|---|---|---|---|
| Page Layout, Margins, and Sections | |||
| Inserting Images, Charts, and Tables | |||
| Headers, Footers, and Page Numbers | |||
| Mail Merge and Document Review | |||
| Ms-PowerPoint: Creating Slides & Formatting | |||
| Adding Transitions & Animations | |||
| Inserting Multimedia (Videos, Audio, Images) | |||
| Creating and Presenting a Slideshow | |||
| PowerPoint Templates & Best Practices | |||
| MS Outlook & Internet Basics | |||
| Email Management (Composing, Replying, Forwarding) | |||
|---|---|---|---|
| Creating and Managing Contacts | |||
| Calendar Scheduling and Appointments | |||
| Internet Basics: Search Engines, Browsing, Downloading Files | |||
| Cybersecurity Awareness & Safe Internet Practices | |||
| Advanced Excel with ChatGPT | |||
| Basics of Excel: Introduction to Excel Interface | |||
|---|---|---|---|
| Formatting Cells, Rows, and Columns | |||
| Basic Formulas and Functions | |||
| Data Validation and Sorting | |||
| Advanced Excel Concepts: Conditional Formatting | |||
| Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP) | |||
| Pivot Tables and Pivot Charts | |||
| Data Visualization with Charts | |||
| Automating Tasks with Excel & ChatGPT: Using AI for Data Analysis | |||
| Generating Reports using ChatGPT | |||
| Automating Tasks with Macros | |||
| What-If Analysis and Goal Seek | |||
| Data Management & Reporting: Power Query & Data Consolidation | |||
| Importing & Exporting Data | |||
| Dashboard Creation | |||
| Protecting & Securing Excel Files | |||
| Tally Prime Basics – Introduction to Accounting & Ledgers | |||
| Introduction to Tally Prime: Basics of Accounting | |||
|---|---|---|---|
| Overview of Tally Prime | |||
| Installing and Configuring Tally | |||
| Company Creation and Features Setup | |||
| Ledgers, Groups & Vouchers: Understanding Ledgers and Groups | |||
| Creating and Managing Ledgers | |||
| Types of Vouchers in Tally (Payment, Receipt, Contra, Journal) | |||
| Recording Transactions | |||
| Journal Entries & Financial Statements: Basics of Journal Entries | |||
| Adjustments & Closing Entries | |||
| Trial Balance & Trading Account | |||
| Profit & Loss Account & Balance Sheet | |||
| Inventory Management: Stock Items, Stock Groups & Units of Measurement | |||
| Stock Categories & Godown Management | |||
| Inventory Valuation Methods | |||
| Generating Inventory Reports | |||
| Tally Prime Advanced – Purchase, Sales & GST Compliance | |||
| Purchase & Sales Transactions: Purchase Orders & Sales Orders | |||
|---|---|---|---|
| Recording Purchase and Sales Transactions | |||
| Managing Credit Notes & Debit Notes | |||
| GST Introduction & Configuration: Understanding Goods and Service Tax (GST) | |||
| GST Acts & Compliance | |||
| Configuring GST in Tally Prime | |||
| Creating Ledgers & Stock for GST | |||
| GST Entries & Reports: Recording GST Purchase and Sales Entries | |||
| Generating GST Reports (GSTR-1, GSTR-2, GSTR-3B) | |||
| Data Management & Exporting Reports: Data Backup and Restore Process | |||
| Exporting Tally Reports to Excel & PDF | |||
| MIS Reports & Financial Analysis | |||
| Customizing Reports in Tally | |||
| Payroll, Employee Management & Final Assessment | |||
| Employee Masters & Payroll Configuration | |||
|---|---|---|---|
| Salary Calculation & Payslip Generation | |||
| Provident Fund (PF) & Employee State Insurance (ESI) | |||
| Payroll Reports & Compliance | |||
| Advanced Tally Prime Features: Budgeting & Cost Centers | |||
| Bank Reconciliation | |||
| Security Control & User Management | |||
| Business Reports & Data Analysis: Analyzing Financial Reports | |||
| Generating Cash Flow & Fund Flow Statements | |||
| Decision Making Based on Reports | |||
| Final Project & Assessment: Hands-on Practice on Real-Life Scenarios | |||
| Generating & Submitting Reports | |||
| Assessment Test & Certification | |||