Introduction to MS Excel – Work books – Work sheets/Spreadsheets (Adding sheets, deleting & Renaming sheets) – Datatypes in Excel – Spreadsheet Analysis – Calculations using MS Excel – Accounting related analysis – Comparison tests – generating reports using MS Excel.
Formatting the sheet – Explaining groups in Home Tab – Font – Clipboard – Alignment – Number – Wrap Text – Merge & Center.
Using formulas in MS Excel.
Excel Functions – Basic functions in Excel.
Assignment 1- Preparing Mark list of 5 students.
Filling series – sorting the list (Using Filter & Sort Button and using Data-sort).
Conditional formatting.
Inserting Headers and Footers, Text boxes, Word Art and Comments.
Assignment 3 – Preparation of Data table (What if Analysis).
Preparing charts using the Data table prepared.
Page Layout tab – Margins, size, Orientation and Print Area.
Formulas tab – Logical functions.
Mathematical and Lookup functions
Data Validation
Practical’s
ELIGIBILITY
+2/B.Com/ Any Equivalent Degree
DURATION
Approx. 6- 7 months (240 hours)
COURSE COVERS
Professional Accounting
Preparation of Trial Balance, Profit & Loss and Balance Sheet
Accounts Management – Bank Management & Cash Management
Professional Corporate Accounting
Management Information Systems (MIS)
Income Tax – Accountants’ Perspective
Goods and Services Tax (GST) – Accountants’ Perspective
Training plays a very important role in understanding the concept better. However, the students must be able to put into practice what they have learned during the training so as to get placed in a good organization.
You must practice all the topics discussed in the class and obtain clarifications from the faculty wherever required. The faculty can guide you on the preparation that needs to be taken before attending interviews.
We have a very good track record when it comes to placement. Since its inception, we had made it a point to deliver the best to all our students thus helping the students have a bright future ahead. All our students have received the best placement.