ACIP - Advance Computer Course Combo
Learn an all-in-one computer course, including MS-CIT, Advanced Excel, Advanced Tally, CorelDraw, Photoshop, Social Media, Typing, and more at Anubhav. Enroll now in the ACIP course to boost your career
Learn All Computer Skills in One Course
ACIP Computer Course
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 / Types of Slides
- Title Slides
- Title and Content
- Section Header
- Two Content
- Comparison
- Title Only
- Blank Slide
- Content with Caption
- Picture with Caption
- Text type and formatting
- Creating Digital Photo Album
- Transition and Animation Effect
- 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
- 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
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
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
- 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 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 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
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
- Linkedin Dashboard Reading
- Building your Profile
- Search your Dream Job
- Setup Business on Linkedin
- Setting of Business on Linkedin
Twitter
- Twitter Dashboard Reading
- Setup Business on Twitter
- Creating Tweets
- Analytics of our Tweets
- Trending Hashtag Research

"Limited-Time Offer"
Originally
71,000/-
Now Priced at Just
20,000/-
Act Now Before Our Exclusive Offer Expires
Anubhav Advance Computer Class Near Chembur Naka
Anubhav Advance Computer Class Near Chembur Station
Anubhav Advance Computer Class Near Govandi Station
Anubhav Advance Computer Class Near Nerul Station
Now, Learn ACIP Course (MS-Office)(MS-CIT)(Internet Skills)(Advanced Excel)(Advanced Tally)(Good & Service Tax)(CorelDraw)(Photoshop)(Social Media) of 71,000/- at just 20,000/-
Get All 7 courses at best prices
Boost your career by enrolling in the ACIP course right away.
Boost your career by enrolling
in the ACIP courses
Our Alumnis Work Here





