INTRODUCTION TO Dr Debarpita Santra
SPREADSHEET
WHAT IS EXCEL?
It is a spreadsheet program developed by Microsoft.
Excel organizes data in columns and rows and allows us to do mathematical
functions.
It runs on Windows, macOS, Android and iOS.
FUNCTIONS OF EXCEL
Analysis
Data entry
Data management
Accounting
Budgeting
Data analysis
Visuals and graphs
Programming
Financial modeling
And much, much more!
EXCEL STRUCTURE
Excel's structure is made of two pieces, the Ribbon and the Sheet.
Have a look at the picture below. The Ribbon is marked with a red rectangle and
the Sheet is marked with a yellow rectangle:
SHEET
The Sheet is a set of rows and columns. It forms the same pattern as we have in math
exercise books, the rectangle boxes formed by the pattern are called cells.
CELL
CREATING MULTIPLE SHEETS
You start with one Sheet by default when you create a new workbook. You can have many
sheets in a workbook. New sheets can be added and removed. Sheets can be named to
making it easier to work with data sets.
First, click the plus icon, shown in the picture below, create two new sheets:
Second, right click with your mouse on the relevant sheet and click rename:
Third, enter useful names for the three sheets:
EXCEL SYNTAX
A formula in Excel is used to do mathematical calculations. Formulas always start with the
equal sign = typed in the cell, followed by your calculation.
Creating formulas, step by step
• Select a cell
• Type the equal sign (=)
• Select a cell or type value
• Enter an arithmetic operator
• Select another cell or type value
• Press enter
For example =1+1 is the formula to calculate 1+1=2
