Admission Enquiry

Skip to main content
search

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
Close Menu
    Powered by  GDPR Cookie Compliance
    Privacy Overview

    The ST PAULS COLLEGE Website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

    Read more about our Privacy Policy here