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.

768 views

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.