Microsoft Excel Beginner to Advanced

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

Microsoft Excel In Practice | Compatible with Microsoft Excel 2016, 2019, 365 | MS Excel Beginner To Advanced

1 - STRUCTURE DATA

1 - WELCOME TO THIS MS EXCEL COURSE

2 - QUESTIONS.html

3 - HARLINGEN START

3 - Kim-restaurant-Copy.xlsx

4 - APPEARANCE OF DATA FILE IN MS EXCEL

5 - BASIC REFERENCES IN MS EXCEL PART 1

6 - BASIC REFERENCES IN MS EXCEL PART 2

7 - RELATIVE ABSOLUTE REFERENCING IN MS EXCEL

8 - CONDITIONAL FORMATTING IN MS EXCEL

9 - ADDING REMOVING AND HIDING CELLS IN MS EXCEL

10 - EXERCISE 11

10 - FISH-AND-SHRIMP-RESTAURANT-Copy.xlsx

11 - SOLUTION EXERCISE 11

12 - CANCEL OPERATION AND SHORTCUTS IN MS EXCEL

12 - EXCEL-SHORTCUT-KEYS-Copy.pdf

13 - DATA VALIDATION IN MS EXCEL

14 - FIND AND REPLACE IN MS EXCEL

15 - FREEZE PANE IN MS EXCEL

16 - PATTERN RECOGNITION IN MS EXCEL

17 - PROTECTING DATA IN MS EXCEL

18 - SHEETS IN MS EXCEL

19 - SORT FILTER IN MS EXCEL

20 - EXERCISE 12

20 - FISH-AND-SHRIMP-RESTAURANT-Copy.xlsx

21 - SOLUTION EXERCISE 12

22 - SECTION 1 CONCLUSION

2 - FUNCTIONS

23 - AMSTERDAM START

23 - AMSTERDAM-BRIDGE-Copy.xlsx

24 - LANGUAGE OF FUNCTIONS

25 - SUM AVERAGE MIN MAX FUNCTION IN MS EXCEL

26 - SUMIF FUNCTION IN MS EXCEL

27 - COUNT FUNCTION IN MS EXCEL

28 - MACHINE ROMANCE

28 - PLANE-MANUFACTURER-Copy.xlsx

29 - EXERCISE 21

29 - PLANE-MANUFACTURER-Copy.xlsx

30 - SOLUTION EXERCISE 21

31 - AND FUNCTION IN MS EXCEL

32 - IF FUNCTION IN MS EXCEL

33 - NESTED IF FUNCTION IN MS EXCEL

34 - EXERCISE 22

34 - PLANE-MANUFACTURER-Copy.xlsx

35 - SOLUTION EXERCISE 22

36 - LEAVING AMSTERDAM

3 - VISUALIZING DATA

37 - ARRIVING IN WATERLOO

37 - MR-FARMER-Copy.xlsx

38 - CHOOSING RIGHT TYPE OF CHART IN MS EXCEL

39 - BAR CHART IN MS EXCEL

40 - PIE CHART IN MS EXCEL

41 - LINE CHART IN MS EXCEL

42 - MULTIPLE LINE CHART IN MS EXCEL

43 - SECONDARY AXIS IN MS EXCEL

44 - EXTRA-EXPLANATION-LOGARITHMIC-SCALES-kopie.pdf

44 - LOGARITHMIC SCALE IN MS EXCEL

45 - SCATTERPLOT IN MS EXCEL

46 - ARRIVING AT ATOMIUM

47 - ATOMIUM-Copy.xlsx

47 - EXERCISE 31

48 - SOLUTION EXERCISE 31

49 - PARETO CHART IN MS EXCEL

50 - ATOMIUM-Copy.xlsx

50 - EXERCISE 32

51 - SOLUTION 32

52 - BOXPLOTS THEORY

53 - BOXPLOTS IN MS EXCEL

54 - ATOMIUM-Copy.xlsx

54 - EXERCISE 33

55 - LEAVING WATERLOO

4 - ANALYZING DATA

56 - ARRIVING IN PARIS

56 - NAPOLEON-APPARTMENT-Copy.xlsx

57 - PIVOT TABLES IN MS EXCEL

58 - EXERCISE 41

58 - NAPOLEON-APPARTMENT-Copy.xlsx

59 - PIVOT CHARTS IN MS EXCEL

60 - EXERCISE 42

60 - NAPOLEON-APPARTMENT-Copy.xlsx

61 - GOAL SEEK IN MS EXCEL

62 - EXERCISE 43

62 - NAPOLEON-APPARTMENT-Copy.xlsx

63 - SOLVER IN MS EXCEL

63 - SOLVER-Copy.xlsx

64 - EXERCISE 44

64 - SOLVER-Copy.xlsx

65 - IMPORTANT INSTRUCTIONS.html

66 - THEORY CORRELATION

67 - THEORY SINGLE OLS REGRESSION

68 - SINGLE OLS REGRESSION IN MS EXCEL

69 - EXERCISE 45

69 - NAPOLEON-APPARTMENT-Copy.xlsx

70 - SOLUTION EXERCISE 45 SINGLE OLS REGRESSION

5 - FINALE

71 - BONUS LECTURE.html

189,000 تومان

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

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

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

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