Learn How Wiley is Aiding the Global Community in Response to COVID-19



Comdex Business Accounting with MS Excel and Tally ERP 9 Course kit

Vikas Gupta

ISBN: 9789350040751

776 pages

INR 499

Description

The book is a combination of two popular applications in their latest version, MS Excel 2010 and Tally.ERP 9. These two applications are widely used across small as well as large business houses and accounting firms. Vikas Gupta has devised the book for upcoming professionals looking for career opportunity in the field of finance and accounts management as well as for professionals who want to upgrade their skills by learning new versions of applications used in the field of business accounting.

The book covers MS Excel 2010 and Tally.ERP 9 applications in an easy to understand language supported by ample screenshots and real life scenarios. The book helps you to master business accounting with the help of MS Excel 2010 and Tally.ERP 9 applications.

MANUAL ACCOUNTING

· Accounting Basics

MS EXCEL 2010

· Introduction to Excel 2010

· Working with Worksheets

· Working with Cells and Ranges

· Formatting a Cell and Worksheet

· Working with Charts, SmartArt Graphics, and Sparklines

· Visualizing Data using Conditional Formatting and  Sorting and Filtering Data

· Working with Formulas and Functions

· Introducing Array Formulas

· Understanding PivotTable,

· Validating and Protecting Data

· Importing Data, Linking, and Consolidating a Worksheet

· Understanding VBA Macros

TALLY .ERP9

· Introduction to Tally.ERP 9

· Stock and Godown in Tally.ERP 9

· Groups, Ledgers, Vouchers and Orders

· Reports in Tally.ERP 9

· Payroll

· Taxation

· Important Features of Tally.ERP 9

· Tally.NET in Tally.ERP 9