MS EXCEL COMPLETE NOTES
xcel is a spreadsheet application initiated and published by Microsoft. It is a component of
E
the Microsoft Office suite of productivity software. MS Excel is the most commonly used
Microsoft Office application. Excel was formerly code-named Odyssey through
development. It was first published on September 30, 1985. Excel is the spreadsheet
program that is employed to save and analyze numerical data.
or example, one can create an Excel spreadsheet that determines a track associated
F
charges, monthly statements, and interactively classify the data by the required criteria.
ith this article, we will learn about essential features of MS Excel, accompanying a sketch
W
of how to use the program, its advantages or benefits, and other significant elements.
About MS Excel
What is MS Excel?
● U nlike a word processor, such as Microsoft Word, Excel builds data in columns and rows. An
Excel spreadsheet can be interpreted as a collection of columns and rows that create a
table. Rows and columns meet in a space termed a cell.
● Alphabetical letters are normally allocated to columns, and numbers are ordinarily allocated
to rows. Each cell can contain a single piece of data, such as a numerical value, text, or
formula.
● The address of a cell is furnished by the letter depicting the column and the number
symbolizing a row. Microsoft Excel is beneficial when we want to record, examine and save
numeric data.
● Microsoft Excel is a spreadsheet program applied to record and analyze numerical and
statistical data. Microsoft Excel provides several features to perform various operations like
mathematical calculations, graph tools, pivot tables, macro programming, etc. It fits with
multiple OS like Windows, macOS, Android, and iOS.
How to Start MS Excel?
icrosoft Excel is a component of the Microsoft Office suite of programs. Alternatively, one can even
M
download it from the Microsoft website but you will have to purchase the license key. Working on
Excel is not different from working with any other Windows program. If you are operating Windows
with a GUI like (Windows XP, Vista, and 7) then to begin MS Excel on your computer, follow these
steps:
lick on the Start Menu–>Go to All Programs–>Click on MS Office–> Lastly choose the MS-Excel
C
option.
, lternatively, one can also begin it from the start menu(by typing MS Excel in the search option
A
available)if it has been added there. You can open it from the desktop shortcut if you have created
one.
Features of MS Excel
S Excel is used for processing the data that is in tabular form and then performing mathematical
M
functions on it to analyze it. This is what the Excel window looks like (version 2007):
xcel is a tool for coordinating and performing calculations on data. It can examine data, compute
E
statistics, create pivot tables, and express data as a chart or graph. MS Excel performs the following
basic functions:
xcel is a spreadsheet application initiated and published by Microsoft. It is a component of
E
the Microsoft Office suite of productivity software. MS Excel is the most commonly used
Microsoft Office application. Excel was formerly code-named Odyssey through
development. It was first published on September 30, 1985. Excel is the spreadsheet
program that is employed to save and analyze numerical data.
or example, one can create an Excel spreadsheet that determines a track associated
F
charges, monthly statements, and interactively classify the data by the required criteria.
ith this article, we will learn about essential features of MS Excel, accompanying a sketch
W
of how to use the program, its advantages or benefits, and other significant elements.
About MS Excel
What is MS Excel?
● U nlike a word processor, such as Microsoft Word, Excel builds data in columns and rows. An
Excel spreadsheet can be interpreted as a collection of columns and rows that create a
table. Rows and columns meet in a space termed a cell.
● Alphabetical letters are normally allocated to columns, and numbers are ordinarily allocated
to rows. Each cell can contain a single piece of data, such as a numerical value, text, or
formula.
● The address of a cell is furnished by the letter depicting the column and the number
symbolizing a row. Microsoft Excel is beneficial when we want to record, examine and save
numeric data.
● Microsoft Excel is a spreadsheet program applied to record and analyze numerical and
statistical data. Microsoft Excel provides several features to perform various operations like
mathematical calculations, graph tools, pivot tables, macro programming, etc. It fits with
multiple OS like Windows, macOS, Android, and iOS.
How to Start MS Excel?
icrosoft Excel is a component of the Microsoft Office suite of programs. Alternatively, one can even
M
download it from the Microsoft website but you will have to purchase the license key. Working on
Excel is not different from working with any other Windows program. If you are operating Windows
with a GUI like (Windows XP, Vista, and 7) then to begin MS Excel on your computer, follow these
steps:
lick on the Start Menu–>Go to All Programs–>Click on MS Office–> Lastly choose the MS-Excel
C
option.
, lternatively, one can also begin it from the start menu(by typing MS Excel in the search option
A
available)if it has been added there. You can open it from the desktop shortcut if you have created
one.
Features of MS Excel
S Excel is used for processing the data that is in tabular form and then performing mathematical
M
functions on it to analyze it. This is what the Excel window looks like (version 2007):
xcel is a tool for coordinating and performing calculations on data. It can examine data, compute
E
statistics, create pivot tables, and express data as a chart or graph. MS Excel performs the following
basic functions: