| Course | Per Semester | Total Fees | One Time Fees |
|---|---|---|---|
| Spreadsheet Modelling Using Excel | N/A | ₹ 27,000.00/- | N/A |
| Skills | Description |
| Advanced Excel Formulas and Functions |
You will become proficient in critical Excel formulas like VLOOKUP, HLOOKUP, INDEX-MATCH, IF functions, and nested functions, which assist in proper organization and analysis of intricate data sets. |
| Data Visualisation and Analysis |
You will learn to convert raw data into useful insights using pivot tables, charts, and conditional formatting, which facilitate clear and concise data presentation for business reporting purposes. |
| Spreadsheet Modelling Techniques |
The course creates the skills to build financial, statistical, and operating models in Excel. You will learn by constructing scenarios, sensitivity analyses, and forecasting models. |
| Decision Support and Problem-Solving |
Students learn how to utilize Excel models as decision support tools, leveraging techniques such as goal seek, solver, and scenario manager to analyze various business strategies. |
| Automation Skills |
This course will help you to learn modern techniques of using macros, shortcuts, and error-checkers to use spreadsheet functions effectively. |
| Job Positions | Responsibilities | Average Salary per annum |
| Financial Analyst | Financial Analysts use Excel models to develop budgets, forecasts, financial reports, and analyze opportunities, offering data-driven insights for business development. | ₹5,00,000 – ₹12,00,000 |
| Data Analyst | Data Analysts clean and organize datasets, help in creating dashboards, reports and visualizations, helping shareholders to understand opportunities and discover loopholes in the business. | ₹5,50,000 – ₹14,00,000 |
| Business Intelligence Associate | They use Excel sheets and models to generate reports and monitor KPIs, helping the business evaluate performance and make strategies for the business’s growth and development. | ₹6,50,000 – ₹16,00,000 |
| Reporting Specialist | He/she creates reports with the use of pivot tables, macros, and formulas to increase the efficiency of data reports. | ₹4,50,000 – ₹10,00,000 |
| Operations Analyst | They use Excel models to store workflow details, track efficiency to discover issues, and make solutions for effective operations within the business. | ₹4,80,000 – ₹11,00,000 |
The Certificate in Spreadsheet Modelling using Excel at Amity Online is a certificate program of 24 hours that teaches advanced Excel skills for data analysis, business modelling, and decision-making.
You will gain professional skills that will prepare you for managing different job roles like:
Yes. Amity Online offers career assistance, such as resume aid, interview training, and access to a job portal. With this certification at Amity Online in collaboration with KPMG, you will get the opportunity of applying for a paid/unpaid internship to use the skills in real business.
Yes, Amity Online has gained many approvals and accreditations like UGC, NAAC A+, QS and WES, which makes the certification program credible and accepted in India and overseas.
Yes, the working professionals can pursue this Amity Certification program as it is delivered through an online mode and helps you manage your time, work, and study effectively.