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 |