The excel features Most common and outstanding are its presentation in grids called cells, its calculation automation functions with numerous formulas and the possibility of creating graphical presentations..
Developed by the Microsoft company in the mid-1980s, it is an electronic spreadsheet program for computers and other similar devices, used for storing, organizing and manipulating data..
The handling -at least basic- of Excel has become an almost mandatory requirement of the Curriculum Vitae of anyone who wishes to be hired for a conventional job; already more than an extra skill, knowing how Excel works is a must.
It is probably the most important software in any workplace that uses computers and is one of the most used programs by companies, companies and small businesses, especially in the accounting area..
Its functions as a spreadsheet allow many facilities to keep track of financial activities, as well as its options to organize the information both numerical and alphabetical data for later presentation in reports, balance sheets, tables and graphs.
Excel is part of the Microsoft Office software package, along with other programs such as Word and Power Point.
Whether for office work, small and medium business, school or academic work, or simply for casual use, the functionality of Microsoft Excel is reported worldwide as the easiest and most efficient to use..
It is a two-dimensional array of intersecting columns and rows that forms the famous and well-known Excel presentation grid. The information is entered in the cells, which is the small rectangle where each row and column meet.
The columns are arranged vertically and identified by letters-from left to right-in the guide row located at the top..
The rows are laid out horizontally and numbered cardinally - top to bottom - in the guide column on the left.
In this way, each cell is easily identifiable with the letter and number of the corresponding column and row..
With a simple click on the desired cell, Excel allows you to select to start entering both letters and numbers.
It is the name given to the complete grid sheet where all the cells are. The latest versions of the program handle 1,048,576 rows and 16,348 columns, from 'A' to the last one identified with the letters 'XFD'.
The worksheets are identified in the lower left with labels that can be renamed according to the user's needs..
It is the common name of Excel files which can contain several worksheets. To switch between worksheets, simply select the labels located at the bottom and to the left of the program screen..
Traditionally, workbooks were stored in files with the extension '.XLS', but since the 2007 version the extension changed to '.XLSX'.
New versions can still open files with an old extension, but if not, a compatibility pack must be installed.
Since the 2007 version, the Microsoft Office suite programs have replaced the traditional menu with ribbons with options arranged in icons. They are a kind of visual menu where the options are kept open.
Each ribbon contains a series of functions related to characteristic icons. For example, the "Start" ribbon has the most common options such as font type, color, and size; The "Insert" ribbon contains the functions of inserting tables, charts, images, among others..
In addition to numbers and text, cells can contain formulas and this is the peculiarity that makes Excel a spreadsheet par excellence.
With formulas, Excel presents the result of a mathematical operation in the selected cell. For example: when you write "= 3 + 5" in a cell, the program will display the number "8".
This function is mainly used to perform calculations with the numeric data inserted in the cells..
By entering into the formula the identification of the cells involved, the program performs the operation, and also keeps the results updated in case the figures in the cells involved change.
Example: when writing the formula "= A3 + B3" in cell C3, Excel will add the values in cells A3 and B3 and show the result in C3.
If the values were 3 and 5 respectively, the result would be 8. If 5 were changed to 9 in cell B3, the result in C3 would be updated to 12.
All basic arithmetic operations can be calculated with Excel formulas in your worksheets.
Excel offers a series of more complex and specialized default functions that can be added to formulas, such as mathematical and trigonometric operations such as subtraction, sine, and cosine; financial such as discounts and fees; and other statistical, referential and logical functions.
In each cell there can be only one formula, but each formula can contain multiple functions.
Excel allows you to visually present the data of a worksheet with different types of graphs.
Depending on the purpose, the program offers bar, pie or pie graphs, line graphs, area graphs and XY scatter graphs..
It is a structural storage tool for tabular data in a selection of columns and rows that the program maintains independent of the worksheet, for later management by the user..
Also called pivot tables, it allows the analysis of large amounts of data within worksheets and then presents them in complex reports or tables without the need to write formulas.
They are small programs that are written in the Visual Basic programming language or “VBA” (Visual Basic for Applications) that help to automate processes and operations in worksheets..
It is a feature for advanced users that allows programming connectivity in databases, doing analytics, forms, algorithms, filters, web searches, among others..
Excel allows up to three different types of visualization in each spreadsheet to favor the comfort of each user. To modify it, it is necessary to go to the bottom of Excel on the right. These can be divided into three possible views:
- Normal. It is the one that appears by default, showing an unlimited number of columns and cells.
- Page design. Divide the spreadsheet according to the number of pages you have.
- Page break. Allows a zoom out in order to show you the spreadsheet in summary mode.
In all views there is a zoom bar to zoom in and out to suit the user's needs.
They are processes with which the appearance of text boxes, shapes or images can be changed. Effects include shadows, edges, three-dimensional twists, lighting, color, texture, and pattern..
Excel has the ability to insert links or direct links from the internet. These open automatically when you click on the link.
The program has various templates for different purposes. This facilitates the creation or design of documents whose function is to serve as agendas, calendars, invoices, schedules, among others..
Yet No Comments