Skip to main content
Programs

Spreadsheet Modelling

Online
Study Mode
Oct 30, 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 Corporates
20000+
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
₹15,000/-

Total Program Fee*

Total Fees
$300/-

How to Enroll into this Certification?

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?
The candidate should have cleared their secondary school (class 10th) examination.
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.