Course Curriculum
- Computer Fundamental
- Paint
- Notepad
- Wordpad
- MS-Word
- MS-Excel
- MS-Powerpoint
- Practical Knowledge
- Sum
- Count
- Count blank
- Average
- Max
- Large Min
- Round
- Abs
- Sumif
- Count if
- Lower
- Upper
- Proper
- Trim
- Len
- Left
- Right
- Mid
- Subtotal
- And
- Or
- Day
- Year
- month
- Net workdays
- Today
- Weekdays
- Find
- Search
- V-lookup
- H-lookup
- Day and Time
- Numeric Calculation
- If Logical Condition
- Dynamic Pivot
- Dynamic Chart
- Conditional Formatting
- Dated if
- What If Analysis
- Match Index
- Offset Function
- User form Function in Excel
- Data Validation
- Advance Filter
- Sorting
- Group & Ungroup
- Data split
- Text Function (Data Separation)
- Substitute
- Goal seek
- Chart
- Table
- Pie Bar
- Accounts Basic Rules
- Trail Balance
- Ledger Creation
- Day Book
- Profit and Loss Account
- Balance Sheet
- Ratio Analysis
- Inventory & Stock
- Creation of stock item
- Godown
- Units
- Category
- Stock Group
- Inventory Vouchers
- Stock Summery
- Statement of Inventory
- Sale and Purchase Order
- Delivery and Receipt Note
- Return inward and Outward
- Sale and Purchase Invoices
- Credit and Debit Notes
- Manufacturing Vouchers
- Transfer of material
- Bill of material
- Cost of components
- Price level list
- Manufacturing additional Cost
- Payroll Salary
- Creation of Payroll
- Categories Salary Head
- Statement Report of payroll
- Single & Multiple payslip
- Taxation
- VAT & TDS
- GST functions
- HSN Code
- Create GST Ledger
- GST Voucher
- Sale and Purchase GST and IGST
- Calculation of GST and IGST
- Live practical knowledge.
- Corel Draw
- Photoshop with Professional Knowledge Logo
- Brochure
- Magazine
- Photo editing
- Photo Correction
- Book Design
- Cards
- Flex Banner
- all types design Experience sharing to students
- Live Experience to watch
- work with Advance Techniques
- Typing with Krutidev Font
- Hindi Typing with Mangal Font
- Government job Typing test practice
- Advance Technique of English Typing
.jpeg)
