ABOUT US

WHO WE ARE

We are a Training Academy for Graduates, Post-Graduates and Professionals. Training programs:
- Advanced Excel (2007) for Finance, Audit & MIS reporting
[Applications: MIS reporting based on data extracted from various ERPs (e.g. SAP, Tally, Ramco), Business Plan formulation, CMA & Project Finance evaluation, Financial Modelling, CAAT (Audit)]

- Visual Basic for Applications (VBA) & Macros
[For existing users of Advanced Excel: Automate repetitive task | Prepare month-end reports with the click of a button | Automate PowerPoint preparation from Excel reports | User-define functions | Prepare Dashboards … and more]

-Financial Modelling in Excel 
[Applications: Equity Research, Private Equity, Investment Banking, Credit Research, Project Financing and Corporate Finance]

- Advanced PowerPoint (2007) for Corporate presentations
[Applications: Sales & Marketing presentations, Investment banking & VC Pitch books, Training Material, Seminar & Conferences, Response to RFPs]

- CA Final ISCA


WHAT MAKES US DIFFERENT

- 100% practical case studies (80%+ participants are working professionals)
- Projector-based training with one PC per participant (-no sharing-)
- Free CD of class case-studies & Charts Videos + Printed Handbook
- Program Director with extensive industry experience (Audit, Investment Banking & Training)
- Program participants include Professionals from Top Corporates
- 1,500+ Corporate participants in 10 cities (Kolkata, Haldia, Mumbai, Gurgaon / New Delhi, Bangalore, Hyderabad, Chennai, Pune, Bhopal, Thimphu) since 2010


WE DELIVER WHAT WE PROMISE

Learn-by-doing approach (Us) vs. See-and-Remember approach (Others)



Top 10 Excel techniques for Auditors

  • VLookup( ) with Match( )
  • Nested IF( ) statements
  • Sort & Filter

Using Excel as an Audit tool

Almost all ERPs (SAP, Oracle, Tally, Ramco etc.) that keep accounting records produce reports in Excel files. In today\\\'\\\'s scenario of risk-based auditing, auditors must review the validity of transactions and input data using CAAT (Computer Aided Audit Techniques). Amongst many other areas, Excel tools and techniques assist in the following:

Why Advanced Excel is a must-have skill set for every MBA?

Every business process needs Excel, whether it is sales or accounting. In fact, most companies use Excel. During summer internship, a large number of MBA students find it difficult to cope with the responsibilities unless they know how to use the tools, techniques, formulas and combination of the formulas present in the software. Watch this Excel problem: Sometimes what may seem like a time-consuming exercise (read: hourS) can be done in 2-3 minutes.

Top 10 Excel techniques for Auditors Using Excel as an Audit tool Why Advanced Excel is a must-have skill set for every MBA?