Microsoft Excel Basic to Advanced: A Complete Learning Path

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

Master Microsoft Excel from the ground up, covering essential basics to advanced techniques in this comprehensive course

1 - Create and open Workbook

2 - Tabs and Ribbon

3 - Errors Function

4 - AND and OR Function

5 - NOT Function

6 - XOR Function

7 - SWITCH Function

8 - CELL Function

9 - IFS Functions

10 - Nesting IF Functions

11 - Use IF function to calculate letter grades in Excel

12 - Use IFS function to calculate letter grades in Excel

13 - Use Filter Function in Excel

14 - DATE Function

15 - DATEIF Function

16 - EDATE Function

17 - EOMONTH Function

18 - DateValue Function

19 - TODAY and NOW Function

20 - Convert Time Hours Minutes and Seconds

21 - Count Function

22 - Round Function

23 - Sum Function SUM SUMIF SUMIFS SUMPRODUCT

24 - Average Function

25 - Subtotal Function

26 - Power Function

27 - Mod Function

28 - INT TRUNC Function

29 - MAX MIN MAXA and MINA Function

30 - Find and Replace

31 - LEN Formulas

32 - MID Formulas

33 - Rept Formulas

34 - Split Formulas

35 - Text Formulas

36 - Trim Formulas

37 - Show Gridlines

38 - INDEX Function

39 - MATCH Function

40 - EXACT Function

41 - VLOOKUP APPROXIMATE MATCH Function

42 - VLOOKUP Function

43 - HLOOKUP Function

44 - XLOOKUP Function

45 - Exact match vs Approximate match

46 - Hyperlink

47 - How to import data web to excel

48 - Use DETECTLANGUAGE formula in google spread sheets

49 - How to convert number to word

50 - Dynamic Drop Down List

51 - Dependent dropdown List

52 - Charts Graphs

53 - How to Use Pivot Tables

54 - Sort Function

55 - Filter Function

56 - Merge and Separate data using flash fill

57 - Freeze panes

58 - Split panes

59 - Rename and Color Worksheets

60 - Add and Delete Worksheets

61 - Hide and Unhide Worksheets

62 - Move and Copy Worksheets

63 - Worksheet Groups

64 - Proetect Worksheet

65 - Protect Workbook

66 - Lock Individual Cells and Protect Sheets In Excel

67 - Sharing Excel Workbook with Multiple Users

68 - Headers and footers

69 - Page settings

70 - Page break view

71 - Print selection

72 - Set print area

139,000 تومان

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

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

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

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