Diploma in Financial Accounting & Master Excel In Bangalore, India.

1144

Master Diploma in Financial Accounting

5

5/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

 Microsoft Word is a Spreadsheet, word processing program. For calculations, making charts and copy data about all sorts of firms uses MS Excel. And also used for writing letters, notes, news and paper presentations. Furthermore, it is used to make it easy to create a new variety of official papers that will look similar among various computers and the same on the monitor to how they seem on paper.

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.

Master Diploma In Accounting Training In Bangalore, Kammanhali, India.
Master Diploma In Accounting Training In Bangalore, Kammanhali, India.

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. 

Tally course in Bangalore, Kammanahalli, India.
Tally course in Bangalore, Kammanahalli, India.

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

What people are saying

Are You Ready To Start?

More Courses

You might also be interested in these courses

Course 2

Aws Training In Kalyan Nagar Bangalore

Cambridge InfoTech offers the AWS Training course in Bangalore Kammanahalli. AWS console Certification, Cloud computing

Aws Training in bangalore

BEST SELLER 3225 Ratings (5.0) Stars
View Course

Course 3

Python Training in Kalyan Nagar Bangalore

python is one of the popular programming languages created by Guido Van Rossum Released in 1991 Cambridge InfoTech corporate training offers job oriented

Python Training in Bangalore

BEST SELLER 4256 Ratings (5.0) Stars
View Course