Tally & Advanced Excel

Excel

  • It is easy to learn and use. By learning this course, you save time in operating excel.
  • You create relevant tables for your data which further helps in making analysis easier.
  • You are able to create macros by doing this course. The macros allow you to create your own formulas which saves your time.
  • It helps in making trend analysis easier.
  • With the help of this course, you will make proper use of the conditional formatting option.
  • The probability of getting a job increases with the help of this course.

Advanced Excel Brief

  • Introduction to spreadsheets
  • Creating, editing, saving and printing spreadsheets
  • Office and Excel overview
  • Basic text and cell formatting
  • Basic arithmetic calculation
  • Special paste
  • Freeze pane
  • Auto completion of series
  • Sort and filter
  • Graphically representing data: Charts & Graphs
  • Data validation
  • Formatting worksheets, Securing & Protecting spreadsheets
  • Conditional formatting
  • Importing data and text to columns
  • Excel Shortcuts
  • Functions
  • AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT
  • IF, AND, OR
  • Dates
  • LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF
  • Consolidation of Data
  • Recording and editing Macros

Data Analysis

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/

Pivot Tables

  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze

Develop Worksheet

  • Plan a worksheet, Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars, Enhance worksheet Appearance

Special Operations

  • Use multiple windows: Copy/ paste between Worksheets
  • Link worksheets, Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat: Create, use and modify styles and templates
  • Print features: Create /edit an outline

Graphic Operations

Create charts, enhance charts, Drawing toolbar features

Tally

  • User friendly
  • Data reliability and security
  • Accounting and inventory management
  • Payroll management
  • Remote access of data
  • Synchronization of data
  • Maintenance records of statutory taxation i.e. vat, TDS, Excise and service tax.
  • Fast documents access
  • Customization for specific industry
  • Audit tool for statutory audit and compliance

Syllabus

  • Master- GL Master, Inventory Master Creation,
  • Accounting- Accounting Vouchers like Contra, Payment, Receipt, Journal, Purchase, etc.
  • Report- MIS Reports, Statutory and Taxation reports and Financial Reports
  • Purchase order process, Inventory Voucher, Sales Order Process
  • Basic Tally Technical- SMS & Emailing, Data Export, Data Split, Data Back Up
Apply Now