Skip to main content
Programs

Spreadsheet Modelling

Online
Study Mode
Jul 03, 2022
Batch Start Date
3 Months
Program Duration

About this Certification

Spreadsheets are indispensable in every organization that you will come across. This course deals with modelling business managers and helps them to make better informed decisions.

The course will introduce you to MS Excel which can perform data storage, visualize and analyze the data and then help you to automate the data. Spreadsheet modelling covers a wide of topics such as creating formats without using formulas, formula which caters to the business problems, slice and dice data using pivot table, creating a model, and developing a dashboard. By creating models, you can use descriptive techniques and predictive techniques. This course will help industry professionals and entrepreneurs to solve real life problems with little effort.

Read More

Highlights

  • Describe basic knowledge of commonly used analytic tools in processing quantitative information and making quantitative business decisions.
  • Recognize and formulate business problems in Excel spreadsheets.
  • Select the use of techniques from other courses – accounting, statistics, management science, and economics – to effectively evaluate and solve excel spreadsheet models.
  • Identify Excel's business analytics and modeling capabilities.
  • Demonstrate the principles of a good spreadsheet design and effectively present the analysis and results.

Modules

  • Basics of Excel and Sensitivity Analysis
  • From Spreadsheet to Model
  • Investment Analysis
  • Lookup Functions
  • Database Operations
  • Handling String Functions, Date and Time
  • Arrays and Matrix Functions
  • Statistical Functions
  • Addressing Uncertainty and Probability in Models
  • Simulation and Optimization
  • Spreadsheet Uses and Limitations
  • Charts and Dash Board
  • Workbook Editing, Sharing & Merging
  • Database Manipulation
  • Auditing Tools
2000+
Hiring Companies
16000+
Courses on Linkedin Learning

Fee Plan

Compare and choose a plan that is comfortable for you

Contact
for any query related to the program
Email us at
  • National
  • International

Total Program Fee*

Total Fees
₹12,000/-

Total Program Fee*

Total Fees
$250/-

How to Enroll into this Cerification?

What our learners say

Kusuma N
Master of Computer Applications

This online learning course has made my life easier as it allows me to focus on my career while also pursuing my master's degree. The support team and faculty are extremely helpful and kind. I am really glad to be a part of JAIN Online. Thanks!

Jaspreet Kaur
Master of Business Administration

As a working professional, I was able to study without having to worry about time constraints. It's fantastic how interactive and knowledgeable the faculty are. I am happy to be a part of JAIN Online.

Sankeerth S
Master of Business Administration

The best part is that we can learn from anywhere in the world, and the recorded sessions give us confidence that we can continue to learn even if we miss a live session. So the money we spend on this Online MBA Program is well spent. I am very happy that we will receive the same degree that a student pursuing an on-campus program receives.

Kumar S V
Master of Business Administration

It is a great opportunity for me to be a part of the JAIN Online family. The well-qualified and experienced professors teach with live examples, which helps us to understand better and faster. I'm having a great time learning. Thank you to JAIN Online.

Frequently Asked Questions

What is the duration of the certification courses?
12 weeks
What is the mode of delivery?
The mode of delivery is online. Live sessions will be held on the weekend.
What is the eligibility criteria to enroll in a certification course?
A graduate in any stream from a recognized university can enroll in a certification program.
What is the medium of instruction?
English
Who will award the Certificate?
The certificate will be awarded by JAIN (Deemed-to-be University).
How are the exams conducted?
Online, proctored examinations will be conducted.
What is the examination pattern?
Continuous assessments and end-of-the-course examination will be conducted.
Is there a minimum attendance required?
A learner is required to have a minimum participation of 75% in all activities.