enquiry
Enquiry
 Accounting course in chennai|Excel and Advanced Accounting Course-Synmac
Description
Basic
Advanced

Excel and Advanced Accounting Course


Microsoft Excel is the premier software application for creating, editing and sharing spreadsheets, with countless practical applications, from financial reporting and general record keeping to operations management and decision support. As a part of this Microsoft Excel training, you will create an Excel spreadsheet, use it to track several types of data, use Excel to perform calculations on spreadsheet data, and optimize an Excel document for printing. This Excel class emphasizes practical exercises and real-world examples, so that you will leave training ready to apply your new knowledge right away.


Working with Basic Functions


  • Predefine formulas to perform calculations and learn about the anatomy of a functions.
  • Use the SUM function to add a list of values
  • Apply commonly used functions such as AVERAGE, MIN, MAX, COUNT and COUNTA.
  • Using Insert Function Option from Formulas Tab
  • Simple insertion: Typing a formula inside the cell
  • Selecting a Formula from One of the Groups in Formula Tab
  • Using AutoSum Option
  • Quick Insert: Use Recently Used Tabs

Advanced Excel Functions


  • V look up
  • H look up
  • Pivotable
  • IF function
  • Formula Auditing
  • Advanced Macros and VBA
  • Graphs and Charts
  • Logical Functions
  • LEN function
  • Right function
  • Left function
  • Mid function
  • IF blank
  • IF Error
  • INDEX MATCH
  • IF combined with AND / OR
  • OFFSET combined with SUM or AVERAGE
  • CHOOSE
  • XNPV and XIRR
  • SUMIF and COUNTIF
  • PMT and IPMT
  • LEN and TRIM
  • CONCATENATE
  • CELL, LEFT, MID and RIGHT functions

Advanced Accounting Course


‘Accounting is the language of business efficiently communicated by well organised and honest professionals called accountants.’


ADVANCED ACCOUNTING SYLLABUS


Essential accounting terms and procedures

Accounting in a professional environment

Maths and numeracy skills for accounting

Producing professional business documents

Accruals concept

Conservatism concept

Economic entity concept

Going concern concept

Matching concept

Materiality concept

ADVANCED JOURNAL ENTRIES

ADVANCED LEDGER CONCEPTS

MATCHING UP OF JOURNAL WITH INCOME TAX

MATCHING UP OF JOURNAL WITH GST

UPDATED ACCOUNTING STANDARDS IN ACCORDANCE WITH (GAAP)

Enroll the course

Courses we offer

GST practical & advanced training

The current tax system gives businesses a tough time as it involves multiple taxes, complex compliance procedures, and intervention...

Income tax practical & advanced training

Income under head salary computation theoretically& by utility (Allowances, Perquisites, Retirement benefit)...

Employees Skill development

The current tax system gives businesses a tough time as it involves multiple taxes, complex compliance procedures...

Income Tax advanced

The Income Tax advanced Course offers a framework in the Tax Advice and Compliance Requirements that is faced by the companies on a daily basis.

GST advanced

SGST, CGST & IGST, Input Tax Credits, Monthly Returns, GSTR 1,1A,2,2A,3 and other Returns, Annual Returns. Due date of Returns, Penalties & Interest to be paid...

Income tax Update course

Income tax update - Updated amendments as per INCOME TAX ACT 1961 Provisions which are amended till date...

Gst Update course

The current tax system gives businesses a tough time as it involves multiple taxes, complex compliance procedures, and intervention...

Excel and Advanced Accounting

Microsoft Excel is the premier software application for creating, editing and sharing spreadsheets, with countless practical applications, from financial reporting

Enquire about the courses

Enquire now