Buscar
Mostrando ítems 1-10 de 15
Referencias en Excel
(Universidad Santo Tomás, 2020-02-25)
When operations are carried out in Excel, sometimes it is required that the cells remain fixed, that is, that the operation is done with data contained by a cell, without this value changing when dragging the formula. This ...
Funciones lógicas en Excel
(Universidad Santo Tomás, 2020-02-25)
Among the benefits that Microsoft Excel provides, is the creation of formulas and functions, which allow you to perform various operations. For this, it is necessary to follow the syntax that Excel specifies and write the ...
Tipos de datos en Excel
(Universidad Santo Tomás, 2020-02-25)
In order to give the user the opportunity to perform various operations, Microsoft Excel created 3 types of data: number, text, and formulas. However, if the results are required to be represented as a date, a time, a ...
Pegado especial en Excel
(Universidad Santo Tomás, 2020-02-25)
Sometimes it is necessary to copy and paste information within an Excel sheet. However, it is not always required to paste it exactly the same as the original, as it may be the case of requiring the results instead of the ...
Funciones de fecha en Excel
(Universidad Santo Tomás, 2020-02-25)
Among the benefits that Microsoft Excel provides, is the creation of formulas and functions, which allow you to perform various operations. For this, it is necessary to follow the syntax that Excel specifies and write the ...
Portapapeles en Excel
(Universidad Santo Tomás, 2020-02-25)
Clipboard is a tool of the operating system, which temporarily stores information that has been copied or cut, to make it available to the user.
This video tutorial explains how to make use of the information contained ...
Funciones matemáticas en Excel
(Universidad Santo Tomás, 2020-02-25)
Among the benefits that Microsoft Excel provides, is the creation of formulas and functions, which allow you to perform various operations. For this, it is necessary to follow the syntax that Excel specifies and write the ...
Ordenar, filtrar y graficar en Excel
(Universidad Santo Tomás, 2020-02-25)
The Microsoft Office spreadsheet allows you to enter information in different formats such as number, currency, accounting, text, date, time, among others, allowing it to be classified, sorted and filtered according to the ...
Validación de datos en Excel
(Universidad Santo Tomás, 2020-02-25)
Any data can be entered in a Microsoft Excel sheet, however, sometimes the information provided is required to meet certain characteristics depending on the use to be given to it.
Within the data tools group of the Data ...
Nombres de rangos en Excel
(Universidad Santo Tomás, 2020-02-25)
A cell is the intersection of a row and a column. They are named by the union of the letter of the column with the number of the intersecting row. For example, if the cursor is located in the column B and in row 4, the ...