ACIP Computer Course
MS-Office
Master the MS-Office with 100% Practical and Industry Expert Trainer and get Certification.
Fees - 5,000/-
MS-Office Syllabus
1. WINDOWS
- Introduction to Keyboard
- Creating Folders
- Giving Password to the Folder
- Changing Attributes ( Read only and Hide )
- Rename Folders and Files
- Delete / Restore Files and Folders
2. MS-WORD
- Overview of Word Processing
- Creating a Simple Document
- Formatting and Page Layouts
- Printing Concept
- Table of Content
- Creating Greeting Card, Letterhead, Creating Flyer, Resume
- Hyperlink and Bookmarks
- Mail Merge
3. MS-EXCEL
- Overview of Excel
- Formatting
- Sum, Average, Min, Max, Len, Count, Upper, Lower
- Pivot Table and Chart
- Page Layout
- Planning Event Expenses
- Creating Planner
- Planning of Monthly Budget
- Protect Sheet
4. MS-POWERPOINT
- Overview of Power Point
- Inserting Slides
- Text Typing and Formatting
- Creating Digital Photo Album
- Transition and Animation Effects
- Automatic Timings and Action Buttons
- Header and Footer
- Designs and Themes
MS-CIT
Learn MS-CIT with Government Certification and grow in this Fastest IT World.
Fees - 5,000/-
MS-CIT Syllabus
- Typing Skills
- 21st Century Job Skills
- 21st Century Daily Life Skills Websites and Apps
- 21st Century Citizenship Skills
- 21st Century Study Skills
- IT Concepts and General Awareness
- Go Green
- Ergonomics
- Scripting Skills
- Netiquettes
- Cybersecurity Skills
Internet Skills
Now, learn various skills of Internet and be ready to boost your career in this Digital World.
Fees - 2,500/-
Internet Syllabus
- E-mail ID Creation
- Google Drive
- Online Birth, Death Certificate
- Filing PAN, Aadhaar Card
- Online Passport
- Online Ticket Booking
- Linking Aadhaar Card with PAN Card
- Online Payment of Bills, Taxes
- Sharing Documents, Images
- Downloading or Uploading
- Creating Blogs, Own Pages
- Online Net Banking
- Using Debit or Credit Cards
- Ms-Access
- Ms-Outlook
Advanced
Excel
Now Learn advanced Excel formulas with the latest version tool with Industry Expert.
Fees - 6,000/-
Advanced Excel Syllabus
1. BASIC EXCEL
- Excel Introduction
- Addition
- Substraction
- Multiplication
- Minimum
- Maximum
- Average
- Sum
- Today Function
- Grade
- Percentage
- 2d Column Chart
- 3d Column Chart
- 2d Line Chart
- 3d Line Chart
- 2d Pie chart
- 3d Pie Chart
- 2d Bar Chart
- 3d Bar Chart
- 2d Area Chart
- 3d Area Chart
- Scatter Chart
- Combo Chart
- Sorting and Filtering
- Custom Sorting
- Nested If Function
2. FORMULAS & FUNCTIONS
- Shortcut Keys
- Data customization
- Data Formatting
- Functions(Sum, Average. Min, Max, Small, Large)
- Worksheet protection
- Page setup
- Hyper
3. LOOKUP FUNCTIONS
- If-Lookup
- H-Lookup
- V-Lookup
- Nested Lookup
- Range Lookup
- Match Function
- Index Function
- Double V-Lookup
- V-Lookup with Match Function
- V-Lookup with Choose Function
- V-Lookup with Column Function
4. ADVANCED FUNCTIONS
- If, And, OR, Not Functions
- Count
- Count A
- Count If
- Count Blank
- Datedif Funtion
- Advanced Filter
- Conditional Formatting
- Advance date and time Function
- Manipulation of text
- Text to Column
- Merge Workbooks
- Manage Workbooks
- Work with sparklines
- Surface, Radar & Combination Chart
- Macros
- Data Table
- Flash Fill
- Freeze Panes
- Subtotal
5. WHAT-IF TOOL
- Scenario Manager
- Goal Seek
- Data Table
6. DATABASE FUNCTIONS
- Dsum
- Dmax
- Dmin
- Daverage
- Dcount
- DcountA
7. TEXT FUNCTIONS
- Upper
- Lower
- Proper
- Left
- Right
- Mid
- Concatenate
- Len
- Exact
- Search
- Replace
- Power
- Date
- Now
- Day
- Month
- Year
8. DATA VALIDATION
- Validation Criteria
- Whole Number
- Drop Down List ( List )
- Text Length
- Decimal
- Circle Invalidation Data
9. FINANCIAL FUNCTIONS
- PMT
- PPMT
- IPMT
- FV and PV
10. BILLING / INVOICE CREATION
- GST Bill Calculation
- Preparing GST Bill
- Page Layout Margin Setting
11. MIS REPORT
- Insert List & custom list
- Sorting & Custom Sorting
- Filter & Advance Filter
- Pivot Table
- Pivot Chart
- Slicer and Report Connections
- Developer Tab (Advanced)
- Advance Stock charts
- Custom chart templates
- Consolidation
- Share Workbook
- Compare & Merge
- Remove Duplicate Data
Advanced
Tally
Learn Advanced Tally and Master yourself in handling complete accounting, job costing, payroll,etc
Fees - 10,000/-
Tally Prime Syllabus
1. BASIC OF ACCOUNTING
- Introduction of Accounting
- Accounting Methods
- Golden Rules
- Final Account (P & L Account / Balance Sheet)
- Recording of Transactions
- Creating and Maintaining a Company
2. BASIC OF TALLY ERP 9
- Introduction of Tally Software
- Accounting Features
- Configuration of Tally
- Advantages of Tally Software
- Company Creation
- Groups and Leadgers
- Recording Office Expenses
3. ADVANCED ACCOUNTING VOUCHER
- Purchase Voucher
- Sales Voucher
- Contra Voucher
- Payment Voucher
- Receipt Voucher
- Debit Note Voucher
- Credit Note Voucher
- Journal Voucher
- Reverse Voucher
- Reverse Journal Voucher
- Memorandum Voucher (MEMO)
4. ADVANCED INVERTORY VOUCHER
- Introduction of Inventory
- Stock Items
- Stock Groups
- Units of Measure (UOM)
- Godown/Location
- Purchase Order Voucher
- Sales Order Voucher
- Rejection Out Voucher
- Rejection In Voucher
- Stock Journal Voucher
- Delivery Note Voucher
- Receipt Note Voucher
5. BANK RECONCILATION
- Interest Calculation
- Electronic Payments
- Sources of Finanacing
- Collaterals ( Types of Loan )
- Data Required for Financing
- Use Contra Voucher
- Use Payment Voucher
- Use Receipt Voucher
- Verify Bank Book
- Verify Passbook
6. MULTI CURRENCY
- Foreign Exchange
- Use Foreign Currency
7. COST CENTER AND COST CATEGORY
- Use Cost Center
- Cost Category
- Cost Center Breakup
- Pre-defined Cost Center
8. GOOD & SERVICE TAX (GST)
- GST Concept and Acceplicability
- Tax Components of GST
- Creating GST Classifications (SGST/CGST/IGST)
- Recording GST Transactions of Trading Firms
- Recording GST Transactions of Service Providers
- Generating GST Reports
- Exporting Data For Returns Summary
- GST Reports – GSTR1, GSTR2, GSTR3 & GSTR 3B
- GST Challans, Payments and Due Dates
- Exporting Data for Returns form GSTR1, GSTR3, GSTR3B
9. TAX DEDUCTED AT SOURCES
- Exemption, Lower Rate
- Payment and Enable TDS
- TDS Features in Tally
- Enabling TDS
- Creating Ledgers ready for TDS entries
- TDS Reports
10. PAYROLL SYSTEM
- Payroll and Statutory Details
- Pension Scheme and Insurance
- Payroll Units
- PF and ESI ( Provident Fund and Employee State Insurance )
- Income tax
- Monthly Leaves
- Gratuity
- Pay Heads
- Payroll Ledgers
- Payroll Voucher
- Attendance Voucher
- Payslip
11. MIS REPORT
- Interest Calculations
- Outstanding Entries
- Mutual Adjustments
- Export Data in Excel, PDF or HTML Formats
- Account Confirmation
- Depreciation
- Day Book Reports
- Trial Balance
- Account Books
- Statements of Accounting
- Statutory Reports
12. DATA SECURITY
- Bill by Bill Details &
- Settlement
- Data Management Backup
- Restore Data
- Split Data
- Import Data
- Export Data
- Security Control
Goods and Services Tax
Master the GST Course with Recognized Certification and be ready to boost your career.
Fees - 4,000/-
Good & Service Tax (GST)
- GST Concept and Acceplicability
- Tax Components of GST
- Creating GST Classifications (SGST/CGST/IGST)
- Recording GST Transactions of Trading Firms
- Recording GST Transactions of Service Providers
- Generating GST Reports
- Exporting Data For Returns Summary
- GST Reports – GSTR1, GSTR2, GSTR3 & GSTR 3B
- GST Challans, Payments and Due Dates
- Exporting Data for Returns form GSTR1, GSTR3, GSTR3B
Photoshop
Learn Photoshop and Master Yourself in Designing with Industry Expert Trainer & 100% Practical.
Fees - 6,000/-
Photoshop Syllabus
- Photoshop Introduction
- Rectangular Marquee Tool
- Elliptical Marquee Tool
- Lasso Tool
- Polygonal Lasso Tool
- Magnetic Lasso Tool
- Quick Selection Tool
- Magic Wand Tool
- Layers
- Text Tools
- How To Apply Blending Option
- Apply Drop Shadow
- Burse Tool
- Pem Tool /Gradient Tool
CorelDraw
Learn CorelDraw and Master Yourself in Designing with Industry Expert Trainer & 100% Practical.
Fees - 6,000/-
CorelDraw Syllabus
CorelDRAW Basics And Interface
- File Management
- Setting Up the Page
- Moving Around the Current Page
- Inserting and Deleting Pages
- Changing Page
- Customizing Options
- Using Multiple Workspaces
- Customizing the Toolbars
- Using Shortcuts
- Saving Defaults
- Setting File Backups
Drawing and Shaping Objects
- Drawing and Shaping Tools
- Using the Freehand Tool
- Drawing Lines and Polylines
- Drawing Freehand Polygons
- Drawing Perfect Shapes
- Reshaping Lines and Polylines
- Drawing Curves
- Reshaping Curves
- Drawing Rectangles
- Drawing Circles
Selecting & Manipulating Objects
- Selecting and Deselecting Objects
- Moving Objects
- Copying and Deleting Objects
- Deleting Objects
- Sizing Objects
Transforming Objects
- Mirroring Objects
- Rotating and Skewing Objects
- Using Transform Dockers
Social Media
Get Familiar with various Social Media and Bring your business or clients business online and start earning.
Fees - 4,000/-
Social Media Syllabus
Facebook and Instagram
- Creating Brand
- Facebook Dashboard Reading
- Setup Business on Facebook
- Settings of Business on Facebook
- Setup Business on Instagram
- Connecting Facebook and Instagram
- Inserting Business Details
- Linkedin Dashboard Reading
- Building your Profile
- Search your Dream Job
- Setup Business on Linkedin
- Setting of Business on Linkedin
- Twitter Dashboard Reading
- Setup Business on Twitter
- Creating Tweets
- Analytics of our Tweets
- Trending Hashtag Research