حالت شب

نکات سریع اکسل (2020)

Get fast answers to common Excel questions
00:37

Fill in a series of data
00:54
Quickly insert multiple rows and columns
00:46
Insert hyperlinks
00:59
Create and manage drop-down lists
01:25
Summing rows
01:00
Work with stock and geography data types
01:21
Fill in contents with Flash Fill
00:46
Quickly insert a total
00:54
Extract part of a cell's contents
02:39

Select specific rows or columns
00:50
Find named ranges
00:41
Change sort order
00:58
Filter data
00:50
Remove duplicate entries
01:44
Convert formula values to plain numbers
00:45
Transpose data from vertical to horizontal
01:35

Text wrap
00:46
Rotate and align cell data
00:56
Copy cell formatting
00:40
Apply international currency formats
00:51
Apply cell styles
00:46
Page options
01:00
Adjust row height and column width
00:54
Add headers and footers
00:57
Align cells
00:43
Add a watermark
01:15
Conditional formatting by cell contents
01:49
Copy and paste cell formatting
01:40
Merge cells
00:46

Change magnification
00:56
Freeze and lock panel options
01:02
Hide and unhide columns and rows
00:46
Show and hide grouped data
01:13

Insert and respond to comments
01:34
Collaborate on an Excel file with others
01:50
Highlight portions of a spreadsheet
01:19
Draw and mark up spreadsheets
01:10

Set document recovery options
00:52
Encrypt a workbook with a password
00:56
Restrict editing
01:15
Save as other file type
00:50
Inspect a spreadsheet
00:39
Check for compatibility issues
00:43
Add and reference worksheets
00:47
Lock cells
01:08

00:00

00:00

Hello, world! This is a toast message.

درصورتیکه بیش از 70% یک محتوا را مشاهده نمایید، به صورت تمام شده در نظر گرفته می شود.