Scribd
Upload
7 views11 pages

Work On Excel

The document provides an introduction to Microsoft Excel, detailing its functions and capabilities as a spreadsheet application used for various tasks including accounting and data management. It outlines the basic elements of Excel, common functions, and how to access the program. Additionally, it includes a list of mathematical, logical, text, search and reference, date, and other functions available in Excel.

Uploaded by

ScribdTranslations
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
7 views11 pages

Work On Excel

The document provides an introduction to Microsoft Excel, detailing its functions and capabilities as a spreadsheet application used for various tasks including accounting and data management. It outlines the basic elements of Excel, common functions, and how to access the program. Additionally, it includes a list of mathematical, logical, text, search and reference, date, and other functions available in Excel.

Uploaded by

ScribdTranslations
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/ 11

Bolivarian Republic of Venezuela

Ministry of Popular Power for Education


E.T.C. R. "Ademar Vásquez Chávez"
Acarigua - State - Portuguesa

INTRODUCTION TO
MICROSOFT OFFICE EXCEL

Professor: Member:
IRIS ARRAIZ ANGELA PIÑA

Subject: 5th Year


Information technology Accounting 'B'

Acarigua, July 2021


INDEX
INTRODUCTION

Excel is a spreadsheet program that allows for operations to be performed.


with numbers organized in a grid. It is useful for performing everything from simple
sums up to mortgage loan calculations.
We will see what the basic elements of Excel are, the screen, the bars, etc.
to learn to differentiate between each one of them. You will learn what they are called,

where they are and what they are for. Also how to get help, in case at any
At the moment, you don't know how to keep working.

Excel is possibly the most popular program in its field worldwide,


published in different versions and updates since its very first
appearance in 1985.

Among its range of capabilities is the management of tables, formats, and formulas.
mathematics, as well as pre-programmed functions, and their corresponding
conversion to graphs of various nature
MICROSOFT OFFICE EXCEL

1.- INTRODUCTION TO MICROSOFT OFFICE EXCEL

DEFINITION: Microsoft Excel, MS Excel, or simply Excel is software


of application published by the company Microsoft, which provides digital support to
the accounting, financial, organizational, and programming tasks, through
spreadsheets. It is part of the Microsoft Office suite, which contains
various office programs like Microsoft Word, Microsoft PowerPoint, etc.

As it has been said, Excel is a spreadsheet system, that is, of worksheets


management of information in an orderly and systematic manner, allowing for the
automation of logical operations (arithmetic, geometric, etc.) and
making life easier for accountants, financial professionals, information managers and
even those who work with lists.

It is a versatile application, especially useful for creating tables and graphs.


and other operations for representing information, based on a matrix
virtually infinite rows and columns in which data can be entered
customize the data. Additionally, Excel has a macro system or
automated formulas, which also allow their use for purposes of
algorithms and programming.
His name was subject to controversy when another company, which already owned a
software called Excel won a lawsuit against Microsoft forcing them to
use his name as part of the application, thus giving rise to MS Excel, to
a dish named using the letters XL, for its sound in English.
the time, however, Microsoft would buy the brand from its rival company and
I would conquer all forms of the product name.

This program belongs to Microsoft under a commercial use license and works
under the operating environments of Windows, Macintosh, and some others, in various
languages. However, there are parallel versions such as the code package
open OpenExcel or LibreExcel, belonging to OpenOffice or LibreOffice
respectively.

ENTRY INTO THE PROGRAM

- we click on HOME PROGRAMS MICROSOFT EXCEL or


- we can double click if the shortcut existed on the Desktop.
The most commonly used Excel FUNCTIONS
Here you have a collection of Excel functions with examples that we have gathered.
explaining on this website. These Excel functions are the ones we have considered most
important for day-to-day work. You may find the list a bit
reduced but for 90% of users they are more than enough.
You might also be interested in the article fromExcel formulasand if you need to buy
Office at a very low priceyou can do it here.
If you don't have time to read all the features today, you might be able to take a look at it.

a look at this summary with the 10 most important functions of Excel:

See the most important functions of Excel

MATHEMATICAL FUNCTIONS OF EXCEL


SUMsum of several elements.
SUMIFsum of several elements with a condition.
SUMIFSsum of several elements with various conditions.
MMULTmultiply two matrices. Of matrix type.
TO COUNTcount the elements that are in a range.
COUNTIFScount the elements of a list depending on
various conditions.
ENTERextract the integer number from a value.
AVERAGE:calculate the arithmetic mean of a range of cells.
AVERAGEIFScount values in a range that meet
certain characteristics.

LOGICAL FUNCTIONS OF EXCEL

This group of Excel functions allows us to use logic in our formulas.


from Excel.
YESallows us to evaluate a condition and return a result if it is met and
another fate is fulfilled

Yto nest two or more conditions exclusively.


Oto nest two or more conditions in a non-exclusive way.

TEXT FUNCTIONS IN EXCEL

RIGHTreturns a given number of characters starting from the


right.
LEFTreturns a given number of characters starting from the
left.
CONCATENATEa number of cells or text strings.
SPACESremove the leading or trailing spaces from a string of text.
LONGreturns the length of a string.

SEARCH AND REFERENCE FUNCTIONS

INDEXThis function returns a value from a cell given its position in a


range.
VLOOKUPThis function returns a value associated with the searched value.
DESREFThis function returns the value of a cell given a starting point,
a row and a column.
COINCIDEthis function allows us to find a match in a range and
obtain your position.
CHOOSEthis function returns the value of an argument given a number of
entry.
ADDRESSthis function returns a reference to a cell
INDIRECTthis function returns the value of a given cell

DATE FUNCTIONS

TODAYthis function returns today's date.


NOWthis function returns the date of the day and the time.
SIFECHAthis function allows you to create a conditional with a date.
DIAS.LABreturns the number of working days between two dates.
YEARget the year from a date.

OTHER FUNCTIONS OF EXCEL

FILAthis function returns the row of the cell.


COLUMNthis function returns the column of the cell.
IT IS AN ERROR
RANDOMthis function returns a random number between 0 and 1.
IMPORTDYNAMICDATAthis function returns a value from a
dynamic table given some arguments of it.
HIERARCHY.EQVthis function helps us to rank values from a list
and sort them from largest to smallest.

VANthis function is used to calculate the NPV and IRR of an investment.


BIBLIOGRAPHY
Source: https://concepto.de/excel/#ixzz71Eg7SBXW

Source: https://concepto.de/excel/#ixzz71EfqSeAB

Source: https://concepto.de/excel/#ixzz71EfDdQW1
CONCLUSION

You might also like