[go: up one dir, main page]
Scribd
Upload
76 views7 pages

Spreadsheet Basics for Finance Students

This document provides an introduction to spreadsheets. It defines a spreadsheet as a two-dimensional grid of rows and columns for entering data. It distinguishes between manual and electronic spreadsheets, noting that electronic spreadsheets allow for larger data entry, quicker calculations using formulas, accuracy, and graphical representations. The document focuses on introducing Microsoft Excel as the electronic spreadsheet that will be used in the course, and outlines the key components of a spreadsheet including the workbook, database, and graphs/charts.

Uploaded by

Satrajit ML
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
76 views7 pages

Spreadsheet Basics for Finance Students

This document provides an introduction to spreadsheets. It defines a spreadsheet as a two-dimensional grid of rows and columns for entering data. It distinguishes between manual and electronic spreadsheets, noting that electronic spreadsheets allow for larger data entry, quicker calculations using formulas, accuracy, and graphical representations. The document focuses on introducing Microsoft Excel as the electronic spreadsheet that will be used in the course, and outlines the key components of a spreadsheet including the workbook, database, and graphs/charts.

Uploaded by

Satrajit ML
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

Introduction to Spreadsheet

Lecture 1

Satrajit Mandal
Lecturer
Jindal School of Banking & Finance

February 1, 2023

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
What is a spreadsheet?

A spreadsheet is a two-dimensional grid of rows and columns


in which data entries can be made.
The data entries can be numbers, text, time, etc.
A spreadsheet is also known as worksheet.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
Types of spreadsheet

Manual spreadsheet - A ledger book with many sheets of


papers containing grids of rows and columns is a manual
spreadsheet. Here, data is entered manually using a pen or
pencil.
Electronic spreadsheet - It is a computer application which is
the electronic version of a manual spreadsheet. It can be
used to automatically perform numerical calculations using
in-built formulae called functions. Examples of electronic
spreadsheet are Microsoft Excel, Numbers, LibreOffice Calc.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
Advantages of electronic spreadsheet over manual
spreadsheet

Electronic spreadsheets are larger for data entry and editing


compared to manual worksheets.
Data entry and operations are quicker in electronic
spreadsheets.
Unlike manual spreadsheets, electronic spreadsheets contain
in-built formulae called functions which help in quickly
performing numerical calculations.
Storage space is higher for saving and retrieving electronic
spreadsheets.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
Advantages of electronic spreadsheet over manual
spreadsheet

Accuracy is higher for numerical computations in an electronic


spreadsheet since computer does the computations. A
computer is more capable and efficient than a calculator and
in working with manual spreadsheets, one has to do the
calculations either manually or by using a calculator.
Graphical representations of data can be generated in
electronic spreadsheet using in-built functions.
Neatness of work is guaranteed in electronic spreadsheet,
whereas in manual spreadsheet neatness depends on the
user’s handwriting skills and use of pen, pencil, eraser.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
Microsoft Excel

In this course, we will learn how to work in electronic spreadsheet -


Microsoft Excel.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet
Components of a spreadsheet

Workbook - A spreadsheet program file containing one or


more worksheets.
Database - It is used to manage data entered into the cells of
a spreadsheet. In Microsoft Excel, it is found in Data tab.
Example of some database features are Sorting, Filtering,
Data Analysis, Data from Picture.
Graphs/Charts - Graphical/pictorial representations of data in
a worksheet. Example Line Graph, Pie Chart, Bar Chart,
Histogram.

Satrajit Mandal Lecturer Jindal School of Banking & Finance Introduction to Spreadsheet

You might also like