Master Diploma in Financial Accounting
5
Best
Seller
3225
Rating (5 star)
3 Months
Duration
1.30hr
Per Day
MASTER DIPLOM in ACCOUNTING Training in Bangalore, Kammanahalli
Give a footing to your career with Cambridge InfoTech in Kammanahalli. Tally Course training in Bangalore Kammanahalli. Tally Erp9 Students will be a part of the categories for tally solutions, account certification, coaching course, tally education Cambridge InfoTech field placed at Bangalore tally education
EXCEL AND ADVANCED EXCEL TRAINING IN BANGALORE
MS Excel is used by firms and persons to write individual and also skilled letters, news for graft and to take records on talks and in sessions and coachings. Because MS is so usually castoff, many trades rise that to send papers created in Word to users, staff and other firm links without distressing.
What is the VBA Macros Course?
VBA (Visual Basic for Applications) is the artificial language of the standout and alternative workplace programs. reproduce a Macro: With stand out VBA you’ll automatise tasks in stand out by writing supposed macros
Benefits of the MACROS in VBA, excel VBA macro tutorial, to know for the educational and Professionals
during this introductory course to stand out, participants can explore stand out activities that transcend the fundamentals. when made completion of this session, participants will expect to own the abilities needed to figure expeditiously in Associate in Nursing existing worksheet and to conjointly produce new worksheets from an example and from scratch.
Why Tally Erp9 With GST In Cambridge InfoTech?
In tally education, Our Most qualified coaching company skilled at Cambridge InfoTech has designed nice modules of Tally Erp9 coaching, so you’ll be able to perceive all things properly and learn much. Accounting, inventory management, and payroll coaching are strategic and sensible based mostly on work. you wish to possess a transparent understanding of all aspects of tally certification, tally solutions, Tally ERP 9 price the categories to face call at the market.
Syllabus of Diploma in Financial Accounting & Master Course
- Sub Total Reports, Auto Filter
- Sorting Data
- Password Protecting Worksheets
- Linking Multiple Sheets
- Sheet Referencing
- Linking Between Word/Excel/Ppt
- COUNTIF, SUMIF.
- What-if-analysis
- Pivot Tables, Pivot Charts
- NESTED IF
- Reporting
- Character Functions
- Scenario Manager
- Date Functions
- Age Calculations
- Consolidation of Data
- Data Validation
- Logical Functions
- MACROS Definition & Concepts
- Record & Run a Macro
- Store a Macro
- Intro to VBA Prog (25 Projects)
- Performing complex calculations
- Using various Excel functions
- Executing in Dynamic projects
- Organizing & analyzing large volumes of data
- Creating MIS reports
- Designing and using templates
- Managing data from multiple workbooks
- Writing conditional expressions (using IF)
- Using logical functions (AND, OR, NOT)
- Using lookup and reference functions
- (VLOOKUP, HLOOKUP, MATCH, INDEX)
- VlookUP with Exact Match, Approximate Match
- Nested VlookUP with Exact Match
- VlookUP with Tables, Dynamic Ranges
- Advanced Formatting
- Formatting & customizing Pivot tables
- Advanced options & Pivot charts
- Consolidating data from multiple sheets
- Using external data sources
- Using data consolidation feature
- Show Value As ( % of Row, % of Column)
- Running Total, Compare with Specific Field
- Viewing Subtotal under Pivot
- Advanced Date & Time Functions
- Data Validation in financial functions
- Advanced Shortcut Keyboard Commands
- Create Forms
- Creating Slicers
- Creating Functions & Procedures
- Design & Create reports
- Understanding Security levels
- Security levels and its meaning
- What is Function & Subroutine
- Writing Functions using VBA Editor
- Calling Functions in other workbooks
- Relative & Absolute Macros
- Recording and running macros storing macro
- Creating buttons & assigning macros
- Creating My Menu
- Editing Macros using VBA Editor
- Understanding the Project explorer
- Exploring windows properties
- Modifying code & debugging code
- Variables, Data types & Constants
- Arrays, Object Variables
- Conditional Structures (If Then, Select Case)
- Logical Operators / looping Constructs
- Built-in Functions, Creating Subordinates
- Creating forms, Forms Events
- Creating custom menus & Toolbars
a. Inventory
- Features
- Stock Groups
- Stock Items
- Physical Stock Voucher
- Creating Units of Measure
- Rejections In & Out
- Purchase & Sales Order
- Multi Currency
- Invoicing, Bill or Stock Wise
- Debit / Credit Notes
- Budgets & Controls
- Multiple Godowns
- Rejection Notes
- Sales Plan / Purchase Plan
- Sales Order Processing
- Purchase Order Processing
- Maintaining Physical Stock
- Inventory Reports & Statements
- Interest Calculation
- Print Preview
- Creating A Company
- Company Configuration
- Setting up a New Company
- Ledger / Creating Groups
- Account Heads / Voucher Entry
- Payment / Receipt Voucher
- Contra Entry
- Purchase / Sales Register
- Creating Cost Centres
- Creating Trial Balance
- Viewing Statement of Accounts
- Profit & Loss Account
- Balance Sheet
- Bank Reconciliation
- Interest Calculation
- Printing of Accounts
- Bank & Cash Books
- PAYROLL
- Company Controlls
- TDS – Tax Deduction Source
- GST – Goods and Service Tax
- Accounting of GST in Tally
- CGST – Central GST Government
- SGST – State GST, Integrated GST
- Fundamentals of Accounting and Tally.ERP 9
- Creating Masters in Tally.ERP 9
- Voucher Entry and Generation of Reports
- Tally Vault and Security Controls
- Export, Import and Splitting of Data
- Job Costing and Job Order Processing
- Installing & Activating Tally.ERP 9
- Connectivity & Printing Reports
- Advanced Accounting in Tally.ERP 9
- Inventory in Tally.ERP 9
- GST in Tally.ERP 9
- Company level
- Stock Group Level
- Stock Item Level
- Inter State Sales
TALLY KIT INCLUDES
- 2 Volumes of Books + 1 GST Book
- Tally Training CD
- 2 Online Exam
- Original Tally Certification
- Student Name is Registered on Tally Website