Excel Quick Tips: Learn the Magic of Excel in Minutes

سرفصل های دوره

Learn the most common Excel tasks in minutes with our easy-to-follow video tutorials.

1. Data Entry in Excel

1.1 series.xlsx

1. Generate a data series

2.1 Fill Multiple Cells with the Same Data.xlsx

2. Fill Multiple Cells with the Same Data

3.1 Quickly insert multiple rows and columns.xlsx

3. Quickly insert multiple rows and columns

4.1 weblinks.xlsx

4. Insert links, website address or emails

5.1 dropdow end.xlsx

5.2 dropdown start.xlsx

5. Create and manage dropdown lists

6.1 summing rows.xlsx

6. Summing rows of data

7.1 flash fill 2.xlsx

7. Fill in contents with Flash Fill

8.1 flash fill 2.xlsx

8. Fill in contents with Flash Fill (Advanced)

9.1 Create and format tables.xlsx

9. Create and format tables

10.1 Quickly insert a total.xlsx

10. Calculate a total quickly.mov

11.1 extract data.xlsx

11. Extract a portion of a cells value

2. Working with data in Excel

1.1 Select specific rows or columns.xlsx

1. Select specific rows or columns

2.1 Format selected data set end.xlsx

2.2 Format selected data set start.xlsx

2. Format selected data set (rowscolumns)

3.1 Find named ranges.xlsx

3. Find named ranges

4.1 sorting.xlsx

4. Change sort order for rows and columns

5.1 filterData.xlsx

5. Filter data

6.1 removeFilter.xlsx

6. Remove filter

7.1 text filter.xlsx

7. Filter data based on text and remove filter

8.1 duplicates.xlsx

8. Remove duplicate entries

9.1 Convert formula values to plain numbers.xlsx

9. Convert formula values to plain numbers

10.1 Transpose data from vertical to horizontal.xlsx

10. Transpose data from vertical to horizontal

11.1 Transpose data from horizontal to vertical.xlsx

11. Transpose data from horizontal to vertical

3. Formatting in Excel

1.1 wratp Text.xlsx

1. Wrap text

2.1 auto fit column data.xlsx

2. AutoFit Text in Columns in Excel

3.1 rotate cell data.xlsx

3. Rotate text data

4.1 allign cell data.xlsx

4. allign cell data

5.1 international currency formats.xlsx

5. international currency formats

6.1 cell styles.xlsx

6. Cell styles

7.1 Page options.xlsx

7. Page options

8.1 Adjust single row height and column width.xlsx

8. Adjust single row height and single column width

9.1 Adjust multiple row height and column width.xlsx

9. Adjust multiple rows height and multiple columns width

10.1 header.xlsx

10. Add headers

11.1 footer.xlsx

11. Add footers

12.1 Add a watermark.xlsx

12. Add watermark

13.1 conditional formattting.xlsx

13. Conditional formatting by cell contents and highlight them

14.1 Copy and paste cell formatting.xlsx

14. Copy and paste cell formatting

15.1 merge.xlsx

15. Merge cells

4. Viewing options on Excel

1.1 zoom.xlsx

1. Zoom Change magnification

2.1 freeze.xlsx

2. Freeze panesrowscolumnsheader

3.1 hide unhide.xlsx

3. Hide and unhide columns

4.1 groups.xlsx

4. Show and hide grouped data

5. Collaborate and Share on an Excel file

1.1 comment.xlsx

1. Insert and respond to comments

2.1 highlight custom.xlsx

2. Highlight portions of a spreadsheet

3.1 Enable Draw inside the ribbon.xlsx

3. Enable Draw inside the ribbon

4.1 draw.xlsx

4. Draw and mark up

6. Control Access on Excel Files

1.1 password.xlsx

1. Encrypt a workbook with a password.mov

2.1 password.xlsx

2. Remove passsword form a Encrypted workbook

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy