Cómo hacer una tabla en Excel y aplicar formatos en celdas
Summary
TLDREn este video tutorial, Miguel Vela de El Tío Tech channel enseña a crear una tabla en Excel, aplicar formatos en filas y columnas, y dar estilo a las celdas. Aprende a ajustar el texto para que se adapte a las celdas, centrar y poner negrita los encabezados, y agregar bordes. Descubre cómo agregar colores y filtros, y cómo nombrar una tabla para facilitar el uso de fórmulas. También se muestra cómo crear listas en una sola celda usando Alt + Enter. Este resumen práctico es ideal para quienes comienzan con cálculos básicos en Excel.
Takeaways
- 😀 Miguel Vela da la bienvenida a los espectadores al canal El Tío Tech.
- 📊 El video enseña conceptos básicos y sencillos para principiantes en hojas de cálculo de Excel.
- 🧑💻 Se explica cómo crear una tabla y aplicar formato en columnas, filas y celdas.
- 🔍 Muestra cómo ajustar el texto en celdas cuando las palabras no caben.
- ⚖️ Enseña a centrar horizontal y verticalmente el texto dentro de las celdas.
- 🖍️ Explica cómo poner negrita y bordes a las celdas para resaltar los encabezados.
- 🎨 Demuestra cómo aplicar colores de fondo y efectos de relleno a las celdas.
- 🔄 Explica cómo poner filtros en las tablas para ordenar y seleccionar datos.
- 🧩 Enseña cómo nombrar una tabla y las ventajas de usar nombres de tabla en funciones y fórmulas.
- 📈 Muestra cómo las fórmulas se aplican automáticamente a toda la tabla cuando se usa la función de tabla.
- 🎨 Los patrones de color se aplican automáticamente en las nuevas filas de la tabla.
- 🔤 Enseña a crear una lista de palabras en una sola celda usando la combinación de teclas Alt + Enter.
- 👍 Concluye con una invitación a los espectadores a comentar y suscribirse al canal.
Q & A
¿Qué nombre utiliza Miguel Vela para su canal de tecnología?
-El nombre del canal es El Tío Tech.
¿Qué tema trata Miguel Vela en este video?
-En este video, Miguel Vela enseña cómo crear una tabla y aplicar formato en Excel para personas que están comenzando.
¿Cuáles son los pasos para ajustar el texto en una celda de Excel cuando no cabe?
-Para ajustar el texto en una celda, selecciona la celda, ve al tab 'Inicio', haz clic en 'Ajustar texto' y Excel ajustará automáticamente la altura de la fila para que el texto quede visible.
¿Cómo se puede hacer para que el texto se ajuste automáticamente a la celda de Excel?
-Puedes hacer esto seleccionando la celda, yendo al tab 'Inicio' y haciendo clic en 'Ajustar texto'.
¿Cómo se puede hacer para centrar texto tanto horizontal como verticalmente en una tabla de Excel?
-Para centrar texto, selecciona las celdas, ve al tab 'Inicio', y haz clic en 'Centrar' tanto para el alineado horizontal como vertical.
¿Cómo se aplican los bordes a una tabla en Excel?
-Para aplicar bordes, selecciona las celdas de la tabla, ve al tab 'Inicio', y selecciona 'Bordes' para aplicar los estilos deseados.
¿Cómo se puede cambiar el color de fondo de una tabla en Excel?
-Para cambiar el color de fondo, selecciona las celdas, haz clic derecho y elige 'Formato de celda', luego ve a 'Relleno' y selecciona el color deseado.
¿Qué es una tabla en Excel y cómo se crea?
-Una tabla en Excel es una selección de celdas con encabezados que se pueden nombrar y formatear de manera sencilla. Para crear una, selecciona las celdas, ve al tab 'Insertar' y haz clic en 'Tabla'.
¿Cómo se pueden aplicar patrones de formato en una tabla de Excel?
-Después de crear una tabla, los patrones de formato se aplican automáticamente al escribir datos en las celdas nuevas, manteniendo el mismo estilo de las filas y columnas anteriores.
¿Cómo se pueden agregar filtros a una tabla en Excel?
-Para agregar filtros, selecciona el encabezado de la tabla, ve al tab 'Datos' y haz clic en 'Filtros'. Esto te permitirá ordenar y seleccionar datos según tus necesidades.
¿Cómo se pueden crear listas dentro de una sola celda en Excel?
-Para crear una lista en una sola celda, utiliza la combinación de teclas 'Alt' y 'Enter' para insertar un salto de línea dentro de la celda.
Outlines
😀 Creación y formateo básico de una tabla en Excel
En el primer párrafo, Miguel Vela, del canal El Tío Tech, enseña cómo crear una tabla en Excel para aquellos que comienzan a trabajar con cálculos. Aborda cómo insertar encabezados, manejar el ajuste de texto y filas, aplicar formato a columnas y filas, y agregar bordes y colores. También menciona cómo hacer que el texto se ajuste automáticamente al escribir en una celda y cómo hacer que el título de la tabla se centre y se destaque.
😀 Avanzando en la creación de tablas y uso de filtros en Excel
El segundo párrafo continúa la lección de Excel con la introducción de filtros y la creación de tablas con nombres para facilitar el uso de fórmulas. Se muestra cómo aplicar filtros para ordenar y seleccionar datos, cómo nombrar una tabla para que las fórmulas se apliquen de manera más eficiente y cómo crear patrones de colores para facilitar la entrada de datos. Además, se explica cómo escribir listas dentro de una celda utilizando la combinación de teclas Alt y Enter.
Mindmap
Keywords
💡Excel
💡Tabla
💡Formato
💡Ajuste de texto
💡Alineación
💡Bordes
💡Color de relleno
💡Filtros
💡Nombre de la tabla
💡Fórmulas
💡Patrones
💡Listas en una celda
Highlights
Miguel Vela introduces himself and the El Tío Tech channel.
Begins a tutorial on Excel for beginners focusing on creating and formatting tables.
Demonstrates how to create a new sheet and zoom in for better visibility.
Teach how to add headings to a table such as 'First Name', 'Last Name', 'Note 1', etc.
Explains how to adjust row height to fit text that doesn't fit in a cell.
Shows how to use 'Adjust Text' feature to automatically fit text in a cell.
Instructs on how to widen columns by dragging the column separator.
Details on aligning text both horizontally and vertically in cells.
Teaches how to apply bold formatting to make text stand out.
Demonstrates adding borders to a table for better delineation.
Guides on how to color the header and title of the table.
Miguel discusses how to combine cells to create a single cell for a title.
Explains how to adjust row height to a specific value for uniformity.
Shows how to change the fill color of cells for better visual distinction.
Instructs on how to apply filters to sort and select data within a table.
Miguel explains the process of naming a table for easier formula application.
Demonstrates the benefits of table patterns for consistent formatting.
Teach how to create a list within a single cell using the Alt + Enter keys.
Encourages viewers to leave comments and subscribe to the channel.
Transcripts
How are you friends, how are you? I hope my name is Miguel Vela and you are on the
El Tío Tech channel. Today I am going to teach you something basic and simple but very important for all
the people who are just starting out, starting with the leaves . of excel calculation, I am going to
teach you how to create a table and apply the format in both columns, the format in both rows and
apply formatting in the cells, I am also going to teach you some tips, we are going to start with
this, look, I am going to open one new sheet and I'm going to zoom in, I'm going to zoom in
a bit so that you can see better here, I'm going to put I'm going to create my table I
'm going to put the headings for example first name last name I'm going to put note 1 note 2 I'm going to put
for example grade point average and observation, what normally happens in excel look when
you start is when you write something like you can observe the words they eat or take away certain
words when it does not fit in a cell for example here I have grade point average it's practically cutting me
notes no we can't see it when that happens look we select the cell we
go to the start tab and here it says adjust text we click there and look how automatically the
height of this entire row has just increased and now it fits perfectly not here in
observations the same thing also happens if we can observe look here it's practically moving to
the other cell we can do it the same way not adjust text look we click there but the
word and makes cordano in that case we would have to pull it could say the column here they come with
a click we drag here in this line that is between column g and column h we drag
to the right and we get the following ok now we are going to select everything and we are going to
put in this case we are going to do the alignment everything it is in the home tab here we have look at
centering both this is the horizontal centering and the vertical centering we are going to give
the horizontal centering a click to the center and a click here for the vertical ok as we are observing we are going to
put bold so that it stands out a little more and here in borders we are going to select all the
borders we click there and look we already have the header we are going to put a color on it for example
I am going to put any color this could be and above in case we want to put a title we are going
to put for example notes notes of the students ok look if I wanted to center this title that
I am putting notes of students then I would have to select all these cells by dragging
and click here where it says look combine and we click there and automatically all these cells
become a single cell we can't put a color the color we want I'm going to put this green and
we're going to drag it down look at the row to make it wider ok could do there yes but a
little more and there it is ok we are going to select all this and again we go to edges and we put
all the edges assuming that we have just entered I don't know until here until at this point
we select all the data and we put all the borders ok there they are if we wanted for example that
this height of the cells be greater we simply select here on the left where
the rows are look we select all these and until the last one not until here for example right click we
give it here where it says row height and here we can put we are not going to put 20 enter and all the
rows selected already have a height of 20 no unlike the ones they had by default we
cannot see the difference is more gram jumps that's fine that would be practically the height
we could also change in this case the fill color we are going to select all right click
look at the header we select all right click we give it in cell format we are going to go
to fill since we are going to fill to give a click where it says fill effects a click and here it shows us,
for example, two colors no, for example, I am going to put here instead of this blue I am going to put
a yellow llo ok and this park I don't know very rough I'm going to put a softer yellow I'm going to
accept accept and look at the difference we don't have a fill with practically two colors to
put the filters to put the filters we have to select the header again go here
to the data tab look click here on data and here we have this option that says filter ok
we click on filter and in this way we will be able to order how we are observing here
poetically from a to z to z to al reverse no and also select the filters for example if
the names are repeated if the surnames are repeated in the highest note and order by color and a lot
of things with the filters this is one way to create a table however there is another ok another
where you practically give this whole table a name and when you use the functions these
functions or these formulas are shorter how do we do that we select the whole table from
headers not from the title we select the entire table we go to each tab erm in
insert tab and here it says table ok we click on table and look this little window will pop up
create table it says here we are going to give you the table it has headers ok why because if it has headers
or we simply accept and look and change not now I made the text white if you like select
all start and put here for example the color black or what could be there there is no problem
what is the benefit of creating a table in this way look yes we click on any part
of the table and we go to table design table design tab here you already appreciate the name of the
table here you can put for example notes or gei enter this word notes refers to
the entire table makes you or you It is very useful when you use the formulas, another of the benefits it has is
that you create a pattern if you put a formula, for example, here we are going to suppose parentheses note
1 by note 2 and all this divided by 2 not for the average and Enter and realize that the formula
is applied in all the cells, there is no problem if, for example, I write something here
, automatically look at the formula and it appears in the next cell, it is the benefit of creating a
table, the patterns are also by color all this row column sorry I'm going to select it and
I'm going to put a green color for example if I write something here and look people automatically
the pattern tells me that the next row is green ok the same look if I do the same here with another
color for example I put the yellow selected or I write something in the next row I press enter
automatically I already have the color yellow 1 this is how the tables work creating from the tab
insert and table ok another of the questions that they ask me is for example if I want to write a
list in a cell for example I am going to be here ok if I want to write in the following
way no I for example why I put louis I press on I put my guel I press between the point
when ap laugh I put marta as you can see pressed enter I have a list of words in a
cell this normally cannot be done by pressing between for example I put louis pressed enter and
go down or like miguel pressed sell and go down the following combination of keys to get a
list inside of a cell is the following look here I have a small keyboard simply press
the alt key and followed by is to press the enter key ok alt and enter and you will be able to write several
words in a single one in a single cell no for example miguel I press the inter and look I have to
write another word no and in this way we can create lists in fact there are a lot of tips
but these are the most basic ok I hope this video has helped you leave me your comment and of
course don't forget to subscribe to the channel uncle ted with me will be until here and see you until
تصفح المزيد من مقاطع الفيديو ذات الصلة
FORMATO de CELDAS en EXCEL Curso básico para principiantes
😃como hacer una tabla en excel paso a paso👀 2019!!
Crear Tablas en Microsoft Word
✅ Crear tablas dinámicas en Excel. Claro y sencillo. Tutorial en español HD
Curso Excel 2010 Básico. Video 3. Selecciones y datos I
Cómo hacer una tabla en Excel Fácil y rápido 👌
5.0 / 5 (0 votes)