Hello everyone! In this video, I'll be creating a table in Excel and thoroughly explain each step I take using simple words. You'll learn how to create complex headers, set up filters, add hyperlinks, freeze panes, and master basic calculations. Also, I will share with you some tricks that will come in handy for quick and efficient work in this program. I will explain the material in such a way that even a first-grader can understand it!

00:00 - Introduction
01:15 - Creating a table header
02:43 - Combining cells into excel
03:11 - Adding borders in the header
03:26 - An important recommendation when creating a complex header
05:08 - Format painter
05:37 - Deleting a column
06:06 - Text alignment in the center of the selection
06:55 - Converting a range of cells into a smart table
09:35 - Copying and pasting data into a table
10:00 - The design of the table in excel
13:56 - Simple calculations in the excel table
16:16 - Adding a summary line
18:23 - Adding a column/row
19:56 - Numbering of rows in the table
20:25 - Conditional Formatting
22:10 - Sorting and filtering data in excel
24:11 - Pinning table areas
25:19 - Inserting notes and links into a cell
27:35 - Solving the problem with the numbering of the list
29:33 - The ending

To support the author financially https://www.donationalerts.com/r/semy...

#excel
#excelforbeginners
#exceltutorial
#spreadsheet
#excelformula
#tableinexcel