Certified Business Accounting Plus
Learn MS-CIT, Advanced Excel, Advanced Tally, All in One course at Anubhav. It is recognized as the Best Institute for CBA+ Course with 100% Practical and Industry Expert Trainer
Business Accounting Modules
Best Accounting Course
Our Features
Raees Shaikh2024-10-22 Anubhav computer institute is best institute Aniket Jaiswar2024-07-31 Course:mscit it is to easy to understand and very helpful to connect to digital world through Anubhav Aryan Gound2024-07-24 Very excellent teaching by Ravindra sir and all the staff Tabbussum Shaikh2024-07-24 Shaikh Tabbussum MSCIT I am doing MSCIT course in anubhav computer institute chembur, it was a great experience and have learnt many concepts and my understanding has also developed Rohan Kamble2024-07-24 Excellent class Khan Nashrah2024-07-23 I have done many courses in anubhav academy and I liked the faculties of this institute which makes the person more knowledgeable. Ritesh Rajbhar2024-07-23 Advance Tally Prime , Advance Excel , Digital GraphicGoogle rating score: 4.7 of 5, based on 1947 reviews
CBA Courses 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 / 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
Originally
32,500/-
Now Priced at Just
18,000/-
Hours
Minutes
Seconds
Only Few Spot Lefts
Act Now Before Our Exclusive Offer Expires
Anubhav Certified Business Accounting Plus Class Near Chembur Station (Head Office)
Raees Shaikh2024-10-22 Anubhav computer institute is best institute Aniket Jaiswar2024-07-31 Course:mscit it is to easy to understand and very helpful to connect to digital world through Anubhav Aryan Gound2024-07-24 Very excellent teaching by Ravindra sir and all the staff Tabbussum Shaikh2024-07-24 Shaikh Tabbussum MSCIT I am doing MSCIT course in anubhav computer institute chembur, it was a great experience and have learnt many concepts and my understanding has also developed Rohan Kamble2024-07-24 Excellent class Khan Nashrah2024-07-23 I have done many courses in anubhav academy and I liked the faculties of this institute which makes the person more knowledgeable. Ritesh Rajbhar2024-07-23 Advance Tally Prime , Advance Excel , Digital GraphicGoogle rating score: 4.7 of 5, based on 1947 reviews
Save 10%, Fill Form Now.
Hours
Minutes
Seconds
Only Few Spot Lefts