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
  • 2638 views

Objectifs :

This document aims to provide a comprehensive guide on how to enhance tables in OneNote using the new formatting options available. It will cover the steps to format tables, including cell shading, header rows, data sorting, and converting tables to Excel spreadsheets.

Chapitres :

  1. Introduction to Table Formatting in OneNote
    OneNote has introduced new formatting options that allow users to create better-organized tables. These enhancements include cell shading, the ability to add header rows, and sorting data within table cells. This guide will walk you through the steps to utilize these features effectively.
  2. Accessing Table Tools
    To begin formatting your table, first, open the page that contains the table you wish to modify. Click anywhere within the table to reveal the hidden 'Table Tools' tab on the ribbon. This tab provides various options for customizing your table.
  3. Selecting Table Parts
    Before applying any formatting, you can precisely select any part of the table. Use the commands in the 'Select' ribbon group to highlight the specific rows, columns, or cells you want to format.
  4. Deleting Rows and Columns
    If you need to remove any unneeded rows or columns from your table, navigate to the 'Delete' ribbon group. Here, you can easily delete the selected parts of your table.
  5. Adding Rows and Columns
    To expand your table, you can add additional rows or columns. Use the commands found in the 'Insert' ribbon group to insert new elements into your table.
  6. Applying Borders and Cell Shading
    To enhance the visual appeal of your table, you can apply borders and cell shading. Access the 'Format' ribbon group to find the necessary commands for these formatting options.
  7. Aligning Text within Cells
    Proper text alignment within table cells is crucial for readability. Use the commands in the 'Alignment' ribbon group to adjust the text alignment as needed.
  8. Sorting Data and Adding Header Rows
    To organize the information in your table, you can sort the data or add a header row. Utilize the commands in the 'Data' ribbon group to perform these actions.
  9. Converting Tables to Excel Spreadsheets
    OneNote allows you to convert a table into an Excel spreadsheet. Simply click the designated button, and OneNote will convert the table, inserting an icon with an embedded dynamic preview of the file for easy access.
  10. Conclusion
    By following the steps outlined in this guide, you can effectively enhance your tables in OneNote. The new formatting options provide greater flexibility and organization, making it easier to display information in a clear and visually appealing manner.

FAQ :

How do I format a table in OneNote?

To format a table in OneNote, click anywhere in the table to reveal the Table Tools tab on the ribbon. From there, you can select parts of the table, delete unneeded rows or columns, add new rows or columns, apply borders and cell shading, align text, and sort data.

What are the new formatting options available for tables in OneNote?

OneNote now supports new formatting options for cell shading, header rows, and data sorting within table cells, allowing for better organization and display of information.

Can I convert a OneNote table to an Excel spreadsheet?

Yes, you can convert a table in OneNote to an Excel spreadsheet. There is a button that allows OneNote to convert the table and insert an icon with an embedded dynamic preview of the file.

How can I delete rows or columns in a OneNote table?

To delete rows or columns in a OneNote table, select the table, go to the Table Tools tab on the ribbon, and use the commands in the Delete ribbon group.

What is the purpose of a header row in a table?

The header row in a table serves to label the columns, making it easier to understand the data contained in each column.

Quelques cas d'usages :

Organizing Meeting Notes

Use OneNote tables to organize meeting notes by creating a table with a header row for topics discussed, and using cell shading to differentiate between action items and general notes. This helps in quickly identifying key points and responsibilities.

Project Tracking

Create a project tracking table in OneNote to monitor tasks, deadlines, and responsible team members. Utilize data sorting to prioritize tasks and cell shading to highlight overdue items, improving project management efficiency.

Data Collection

When collecting data during surveys or research, use OneNote tables to input responses. The ability to sort data and add header rows allows for easy analysis and comparison of results.

Budget Planning

Design a budget planning table in OneNote to track expenses and income. Use cell shading to categorize different types of expenses and apply data sorting to analyze spending patterns over time.

Lesson Planning for Educators

Teachers can use OneNote tables to create lesson plans, organizing topics, objectives, and materials needed. The formatting options allow for clear presentation and easy adjustments as needed.

Glossaire :

OneNote

A digital note-taking application that allows users to create, organize, and share notes, drawings, screen clippings, and audio files.

Table Tools

A set of commands in OneNote that become available when a table is selected, allowing users to format and manipulate the table.

Cell Shading

The background color applied to individual cells in a table to enhance visual organization and readability.

Header Row

The top row of a table that typically contains titles or labels for the columns, helping to identify the data contained in each column.

Data Sorting

The process of arranging data in a specific order, such as ascending or descending, based on the values in one or more columns.

Borders

Lines that define the edges of table cells, enhancing the visual structure of the table.

Alignment

The positioning of text within a cell, which can be adjusted to be left, center, or right aligned.

Excel Spreadsheet

A file format used by Microsoft Excel, which allows for complex data manipulation and analysis, including calculations and graphing tools.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Crea tavoli migliori.
00:00:03
OneNote ora supporta la nuova formattazione
00:00:05
opzioni per l'ombreggiatura delle celle, le righe di intestazione,
00:00:07
e ordinamento dei dati all'interno delle celle della tabella,
00:00:09
in modo da poter organizzare e visualizzare
00:00:12
informazioni nel modo desiderato.
00:00:14
Apri la pagina contenente
00:00:16
tabella che desideri formattare.
00:00:17
Fai clic in un punto qualsiasi della tabella per visualizzare
00:00:21
scheda Table Tools nascosta sulla barra multifunzione.
00:00:23
Ora puoi eseguire una delle seguenti operazioni
00:00:26
per selezionare con precisione qualsiasi parte
00:00:27
della tabella prima dell'applicazione
00:00:29
formattazione della selezione.
00:00:30
Utilizzate i comandi nel gruppo della barra multifunzione Seleziona.
00:00:35
Per eliminare le righe non necessarie o
00:00:37
colonne dalla tua tabella,
00:00:38
usa i comandi nel gruppo della barra multifunzione Elimina.
00:00:43
Per aggiungere righe o colonne aggiuntive,
00:00:45
usa i comandi nel gruppo della barra multifunzione Inserisci.
00:00:49
Per applicare i bordi delle tabelle e l'ombreggiatura delle celle,
00:00:52
utilizzate i comandi nel gruppo della barra multifunzione Formato.
00:00:57
Per allineare il testo all'interno delle celle, usate
00:00:59
comandi e il gruppo della barra multifunzione di allineamento.
00:01:03
Per ordinare le informazioni in
00:01:05
celle o aggiungervi una riga di intestazione,
00:01:07
usa i comandi nel gruppo della barra multifunzione Dati.
00:01:12
È inoltre possibile convertire una tabella in
00:01:14
Foglio di calcolo Excel grazie a questo pulsante.
00:01:16
OneNote lo convertirà e
00:01:18
inserire un'icona con un elemento incorporato
00:01:20
anteprima dinamica del file.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Создавайте лучшие столы.
00:00:03
Теперь OneNote поддерживает новое форматирование
00:00:05
опции затенения ячеек, строк заголовков,
00:00:07
и сортировка данных в ячейках таблицы,
00:00:09
чтобы вы могли упорядочивать и отображать
00:00:12
информацию так, как вы хотите.
00:00:14
Откройте страницу, содержащую
00:00:16
таблицу, которую вы хотите отформатировать.
00:00:17
Нажмите в любом месте таблицы, чтобы открыть
00:00:21
скрытая вкладка «Инструменты таблицы» на ленте.
00:00:23
Теперь вы можете выполнить любое из следующих действий
00:00:26
чтобы точно выбрать любую деталь
00:00:27
таблицы перед подачей заявки
00:00:29
форматирование выборки.
00:00:30
Используйте команды из группы лент «Выбрать».
00:00:35
Чтобы удалить ненужные строки или
00:00:37
столбцы из таблицы,
00:00:38
используйте команды в группе ленты «Удалить».
00:00:43
Чтобы добавить дополнительные строки или столбцы,
00:00:45
используйте команды в группе лент «Вставить».
00:00:49
Чтобы применить границы таблицы и затенение ячеек,
00:00:52
используйте команды в группе лент «Формат».
00:00:57
Чтобы выровнять текст в ячейках, используйте
00:00:59
команды и группу лент выравнивания.
00:01:03
Чтобы отсортировать информацию в поле
00:01:05
ячейки или добавить к ним строку заголовка,
00:01:07
используйте команды в группе ленты «Данные».
00:01:12
Можно также преобразовать таблицу в
00:01:14
Электронная таблица Excel благодаря этой кнопке.
00:01:16
OneNote преобразует ее и
00:01:18
вставьте значок со встроенным
00:01:20
динамический предварительный просмотр файла.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Haz mejores mesas.
00:00:03
OneNote ahora admite nuevos formatos
00:00:05
opciones de sombreado de celdas, filas de encabezados,
00:00:07
y clasificación de datos dentro de las celdas de la tabla,
00:00:09
para que puedas organizarlos y mostrarlos
00:00:12
información de la manera que desee.
00:00:14
Abra la página que contiene
00:00:16
tabla a la que desea formatear.
00:00:17
Haga clic en cualquier parte de la tabla para ver la
00:00:21
la pestaña Herramientas de tabla oculta en la cinta.
00:00:23
Ahora puede realizar cualquiera de las siguientes acciones
00:00:26
para seleccionar con precisión cualquier pieza
00:00:27
de la tabla antes de aplicar
00:00:29
dar formato a la selección.
00:00:30
Utilice los comandos del grupo de cintas Seleccionar.
00:00:35
Para eliminar cualquier fila innecesaria o
00:00:37
columnas de tu tabla,
00:00:38
utilice los comandos del grupo de cintas Eliminar.
00:00:43
Para añadir filas o columnas adicionales,
00:00:45
utilice los comandos del grupo de cintas Insertar.
00:00:49
Para aplicar los bordes de las tablas y el sombreado de las celdas,
00:00:52
utilice los comandos del grupo de cintas de opciones Formato.
00:00:57
Para alinear el texto dentro de las celdas, utilice el
00:00:59
los comandos y el grupo de cintas de alineación.
00:01:03
Para ordenar la información del
00:01:05
celdas o agregarle una fila de encabezado,
00:01:07
utilice los comandos del grupo de cintas de datos.
00:01:12
También puede convertir una tabla en
00:01:14
Hoja de cálculo de Excel gracias a este botón.
00:01:16
OneNote la convertirá y
00:01:18
inserte un icono con un icono incrustado
00:01:20
vista previa dinámica del archivo.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Maak betere tafels.
00:00:03
OneNote ondersteunt nu nieuwe opmaak
00:00:05
opties voor celarcering, koprijen,
00:00:07
en het sorteren van gegevens in tabelcellen,
00:00:09
zodat u kunt ordenen en weergeven
00:00:12
informatie zoals jij dat wilt.
00:00:14
Open de pagina met de
00:00:16
tabel die u wilt opmaken.
00:00:17
Klik ergens in de tabel om de
00:00:21
verborgen tabblad Table Tools op het lint.
00:00:23
Je kunt nu een van de volgende dingen doen
00:00:26
om elk onderdeel nauwkeurig te selecteren
00:00:27
van de tabel voor de aanvraag
00:00:29
opmaak voor de selectie.
00:00:30
Gebruik de opdrachten in de lintgroep Select.
00:00:35
Om overbodige rijen te verwijderen of
00:00:37
kolommen uit je tabel,
00:00:38
gebruik de opdrachten in de lintgroep Verwijderen.
00:00:43
Om extra rijen of kolommen toe te voegen,
00:00:45
gebruik de opdrachten in de lintgroep Invoegen.
00:00:49
Om tabelranden en celschaduw toe te passen,
00:00:52
gebruik de opdrachten in de lintgroep Format.
00:00:57
Om de tekst in de cellen uit te lijnen, gebruik de
00:00:59
opdrachten en de lintgroep voor uitlijning.
00:01:03
Om de informatie te sorteren in het
00:01:05
cellen of voeg er een koprij aan toe,
00:01:07
gebruik de opdrachten in de lintgroep Gegevens.
00:01:12
Je kunt een tabel ook converteren naar een
00:01:14
Excel-spreadsheet dankzij deze knop.
00:01:16
OneNote converteert het en
00:01:18
voeg een pictogram in met een ingesloten
00:01:20
dynamische voorvertoning van het bestand.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Zrób lepsze stoły.
00:00:03
Program OneNote obsługuje teraz nowe formatowanie
00:00:05
opcje cieniowania komórek, wierszy nagłówków,
00:00:07
i sortowanie danych w komórkach tabeli,
00:00:09
abyś mógł organizować i wyświetlać
00:00:12
Informacje w taki sposób, w jaki chcesz.
00:00:14
Otwórz stronę zawierającą
00:00:16
tabela, którą chcesz sformatować.
00:00:17
Kliknij dowolne miejsce w tabeli, aby wyświetlić
00:00:21
ukryta karta Narzędzia tabeli na wstążce.
00:00:23
Możesz teraz wykonać dowolną z poniższych czynności
00:00:26
aby precyzyjnie wybrać dowolną część
00:00:27
stołu przed złożeniem wniosku
00:00:29
formatowanie do zaznaczenia.
00:00:30
Użyj poleceń w grupie Wybierz wstążkę.
00:00:35
Aby usunąć niepotrzebne wiersze lub
00:00:37
kolumny z tabeli,
00:00:38
użyj poleceń w grupie Usuń wstążkę.
00:00:43
Aby dodać dodatkowe wiersze lub kolumny,
00:00:45
użyj poleceń w grupie Wstaw wstążkę.
00:00:49
Aby zastosować obramowania tabeli i cieniowanie komórek,
00:00:52
użyj poleceń w grupie Formatuj wstążkę.
00:00:57
Aby wyrównać tekst w komórkach, użyj
00:00:59
polecenia i grupa wstążek linii trasowania.
00:01:03
Aby posortować informacje w
00:01:05
komórki lub dodaj do niego wiersz nagłówka,
00:01:07
użyj poleceń w grupie wstążki danych.
00:01:12
Możesz także przekonwertować tabelę na
00:01:14
Arkusz kalkulacyjny Excel dzięki temu przyciskowi.
00:01:16
OneNote przekonwertuje go i
00:01:18
wstaw ikonę z osadzonym
00:01:20
dynamiczny podgląd pliku.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:00
Készítsen jobb asztalokat.
00:00:03
A OneNote mostantól támogatja az új formázást
00:00:05
opciók a cellaárnyékoláshoz, fejlécsorokhoz,
00:00:07
és az adatok rendezése táblázatcellákon belül,
00:00:09
így szervezheti és megjelenítheti
00:00:12
Információ úgy, ahogy szeretné.
00:00:14
Nyissa meg az oldalt, amely tartalmazza
00:00:16
formázni kívánt táblázat.
00:00:17
Kattintson bárhová a táblázatban a megjelenítéshez
00:00:21
rejtett Táblázati eszközök lap a szalagon.
00:00:23
Most megteheti az alábbiak bármelyikét
00:00:26
bármely alkatrész pontos kiválasztásához
00:00:27
a táblázat alkalmazása előtt
00:00:29
formázás a kiválasztáshoz.
00:00:30
Használja a Szalag kiválasztása csoportban található parancsokat.
00:00:35
Szüktelen sorok törléséhez vagy
00:00:37
oszlopok a táblázatból,
00:00:38
használja a Szalag törlése csoportban található parancsokat.
00:00:43
További sorok vagy oszlopok hozzáadásához
00:00:45
használja a Szalagbeillesztés csoportban található parancsokat.
00:00:49
Táblázatszegélyek és cellaárnyékolás alkalmazása,
00:00:52
használja a Formátum szalagcsoport parancsait.
00:00:57
A szöveg cellákon belüli igazításához használja a
00:00:59
parancsok és az igazítási szalagcsoport.
00:01:03
Az információk rendezése a
00:01:05
cellákat, vagy adjon hozzá egy fejlécsort,
00:01:07
használja az Adatszalag csoportban található parancsokat.
00:01:12
Átalakíthat egy táblázatot
00:01:14
Excel táblázat ennek a gombnak köszönhetően.
00:01:16
A OneNote konvertálja és
00:01:18
beágyazott ikon beillesztése
00:01:20
a fájl dinamikus előnézete.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2955 Views

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!

ALL COURSES

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session