Excel lessons

#excel #learning #lesson
Excel lessons: https://www.youtube.com/playlist?list=PLQRFjvjAQy61CjcS1cLamI2kFXrI1ZT0q

Chapters:
0:00 intro
0:08 Create a new blank file
0:20 Create a new file from template
0:40 Save file
0:53 Select the default folder for saving files
1:12 Open saved files
1:23 Print file
1:37 Encrypt file with password
1:57 Decrypt file with password
2:21 Rewind the action back and forth
2:39 Select all cells
2:51 Copy cell - paste a cell, cut a cell - paste a cell
3:13 Pressing the Alt key enters characters into the sections of the menu, which, together with the Alt key, will allow you to quickly switch to the specified menu.
3:26 External info about file
3:42 Create a simple formulas from cells
4:16 Align content in cells
5:08 Underline or Double underline, content in cells
5:30 content in cells in bold or italic type
5:43 Automatic numbering of text by cells
6:12 Display content in cells with different fonts and sizes
6:52 Display content in cells with strikethrough and change font color
7:17 Display content in cells in superscripts or subscripts
7:42 Draw a table in color
8:05 Change table border types
8:36 Diagonal table borders
9:12 Different colors of table borders
9:41 Merge cells into one cell
10:01 Slope of content into cells
10:26 Move content in cells
10:42 Wrap text in cell
10:57 Copy a cell with or without its design
11:22 Copy a cell with or without its design
11:50 Copy cell with design and cell size
12:09 Copy cell with reverse formula
12:30 Copy cell with formula results
12:55 1. Copy cell design without content. 2. Freeze dynamics of formula
13:23 The image shows the value of the cell, statically or dynamically.
13:53 Cell format painter
14:12 Copy cell with more options
14:34 Dynamic copying of cells, without loss of connection
14:56 Copy vertical table to horizontal
15:14 Easily convert numbers to percentages
15:36 Change decimal place of a number
15:52 Converting a number to currency format
16:19 Change table format if values are greater than specified.
16:43 Change the format of the table if the values are in the specified range.
17:06 Change the format of the table if the cell contains specific text.
17:32 Change the format of the table, if the cell contains specific piece of text.
17:54 Change the format of the table, if the cell contains specific dates.
18:22 Change the format of the table, if the cells contains dublicats or unicue content.