Basics of Creating Tables in Excel

Video Description

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/semyon_solomin #excel #excelforbeginners #exceltutorial #spreadsheet #excelformula #tableinexcel