OneNote - Make better tables Tutorial

In this video, you will learn how to make better tables using Microsoft Excel.
The video covers the basics of table management, including formatting data, enhancing the appearance of worksheets, and automating data processing through functions and formulas.
By mastering these skills, you will be able to create organized and visually appealing tables, saving time and improving efficiency in your data processing.
This tutorial is perfect for beginners who want to familiarize themselves with the fundamentals of Microsoft Excel.

10 min
2295 views

Available in Microsoft365

00:00:00

Make better tables.

00:00:03

OneNote now supports new formatting

00:00:05

options for cell shading, header rows,

00:00:07

and data sorting within table cells,

00:00:09

so you can organize and display

00:00:12

information the way you want to.

00:00:14

Open the page containing the

00:00:16

table you want to format.

00:00:17

Click anywhere in the table to reveal the

00:00:21

hidden Table Tools tab on the ribbon.

00:00:23

You can now do any of the following

00:00:26

to precisely select any part

00:00:27

of the table before applying

00:00:29

formatting to the selection.

00:00:30

Use the commands in the Select ribbon group.

00:00:35

To delete any unneeded rows or

00:00:37

columns from your table,

00:00:38

use the commands in the Delete ribbon group.

00:00:43

To add any additional rows or columns,

00:00:45

use the commands in the Insert ribbon group.

00:00:49

To apply table borders and cell shading,

00:00:52

use the commands in the Format ribbon group.

00:00:57

To align the text within the cells, use the

00:00:59

commands and the alignment ribbon group.

00:01:03

To sort the information in the

00:01:05

cells or add a header row to it,

00:01:07

use the commands in the Data ribbon group.

00:01:12

You can also convert a table to an

00:01:14

Excel spreadsheet thanks to this button.

00:01:16

OneNote will convert it and

00:01:18

insert an icon with an embedded

00:01:20

dynamic preview of the file.

00:00:00

Faça mesas melhores.

00:00:03

O OneNote agora oferece suporte a nova formatação

00:00:05

opções para sombreamento de células, linhas de cabeçalho,

00:00:07

e classificação de dados dentro das células da tabela,

00:00:09

para que possa organizar e apresentar

00:00:12

informações da maneira que você quiser.

00:00:14

Abra a página que contém a seringa

00:00:16

tabela que pretende formatar.

00:00:17

Clique em qualquer parte da tabela para revelar o

00:00:21

guia Ferramentas de Tabela ocultas na faixa de opções.

00:00:23

Agora você pode fazer qualquer um dos seguintes procedimentos:

00:00:26

para selecionar com precisão qualquer peça

00:00:27

do quadro antes da apresentação do pedido

00:00:29

formatação para a seleção.

00:00:30

Use os comandos no grupo Selecionar faixa de opções.

00:00:35

Para eliminar quaisquer linhas desnecessárias ou

00:00:37

colunas da sua tabela,

00:00:38

use os comandos no grupo Excluir faixa de opções.

00:00:43

Para adicionar linhas ou colunas adicionais,

00:00:45

use os comandos no grupo Inserir faixa de opções.

00:00:49

Para aplicar bordas de tabela e sombreamento de célula,

00:00:52

use os comandos no grupo da faixa de opções Formatar.

00:00:57

Para alinhar o texto dentro das células, use o botão

00:00:59

e o grupo da faixa de opções Alinhamento.

00:01:03

Para classificar as informações no

00:01:05

ou adicionar uma linha de cabeçalho a ele,

00:01:07

use os comandos no grupo da faixa de opções Dados.

00:01:12

Você também pode converter uma tabela em uma

00:01:14

Planilha do Excel graças a este botão.

00:01:16

O OneNote irá convertê-lo e

00:01:18

inserir um ícone com um incorporado

00:01:20

visualização dinâmica do arquivo.

DiLeaP AI: THIS MIGHT BE HELPFUL

Excel - Use table references

In this video, you will learn how to create a table in Microsoft Excel using the "Format as Table" function.
The video covers the steps to convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also demonstrates how to name your table and change its design using the Table Tools contextual tab.
Additionally, it explains how to change the visual style of your table by selecting different color styles from the Table Styles group.
This tutorial will help you understand how to create and format tables in Excel, making your data more organized and visually appealing.

1:39
538 views

Excel - How to create a table

In this video, you will learn how to create a table in Microsoft Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.

2:11
3194 views

Excel - Start using Excel

In this video, you will learn how to start using Excel.
The video covers the basics of opening Excel, creating a blank workbook, navigating the worksheet, entering data, formatting cells, adding a header row, converting data to a table, and exploring the ribbon and contextual tabs.
This tutorial will help you get started with Excel and create a simple worksheet to track expenses or other data.

4:22
3801 views

Lists - Turn your Excel tables into real lists!

In this video, you will learn how to turn your Excel tables into real lists using Microsoft 365. The video covers the process of converting tables into lists and demonstrates the steps to follow.
This will help you optimize your Excel data and improve your productivity.

1:12
2701 views

Power BI - Conditional formatting

In this video, you will learn about conditional formatting and how to take it to the next level.
The video covers how to apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
It demonstrates how to use the quick analysis option in the ribbon for quick formatting, as well as how to have more control over the formatting by creating new rules.
You can format cells based on their values, such as using icon sets, and even format cells that are blank or contain errors.
This will help you make sense of your data and easily identify trends or important information.

3:35
3037 views

RELATED COURSES This tutorial is part of the following courses

Microsoft OneNote Video Training - Discover the Note-Taking Tool

Would you like to improve note-taking, document management and collaborative work? Learn how to do all that in OneNote!

2279 Views

ALL COURSES