Microsoft Excel and Google Sheets for Data Analysis

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

Unlocking the Power of Microsoft Excel and Google Sheets for In-Depth Data Analysis and Visualization

1 - Introduction

1 - Introduction

2 - Excel and Google Sheet basics

2 - Getting started with Excel

3 - Getting started with Google Sheet

4 - Course Resources.html

5 - Worksheet Basics in Excel

6 - Worksheet Basics in Google Sheet

7 - Entering values and Formulas in Excel

8 - Entering values and Formulas in Google Sheet

9 - Data Formats in Excel

10 - Data Formats in Google sheet

11 - Data Handling Basics Cut Copy and Paste in Excel

12 - Data Handling Basics Cut Copy and Paste in Google Sheet

13 - Saving and Printing in Excel

14 - Saving and Printing in Google Sheet

3 - Essential Excel Google Sheet functions

15 - Basic Formula Operations in Excel

16 - Basic Formula Operations in Google Sheet

17 - Mathematical Functions in Excel Part 1

18 - Mathematical Functions in Excel Part 2

19 - Mathematical Functions in Google Sheet Part 1

20 - Mathematical Functions in Google Sheet Part 2

21 - Textual Functions in Excel Part 1

22 - Textual Functions in Excel Part 2

23 - Textual Functions in Google Sheet Part 1

24 - Textual Functions in Google Sheet Part 2

25 - Logical Functions in Excel

26 - Logical Functions in Google Sheet

27 - DateTime Functions in Excel

28 - DateTime Functions in Google Sheet

29 - Lookup Functions V Lookup Hlookup IndexMatch

30 - Lookup Functions in Google Sheet

4 - New XLookup only for Excel 2021 and office 365

31 - XLookup as a replacement of Vlookup

32 - Handling NA and Approximates match in Xlookup

33 - Wildcard matching in XLookup

34 - Search modes in XLookup

5 - Data Tools

35 - Data Tools in Excel part 1

36 - Data Tools in Excel part 2

37 - Data Tools in Google Sheet

6 - Formatting data and tables

38 - Formatting data and tables in Excel

39 - Formatting data and tables in Google Sheet

7 - Pivot Tables

40 - Pivot Tables in Excel

41 - Pivot Tables in Google Sheet

8 - Charts

42 - Excel Charts Categories of messages that can be conveyed

43 - Elements of charts

44 - The easy way of creating charts in Excel

45 - The easy way of creating charts in Google Sheet

46 - Bar and column charts in Excel

47 - Bar and column charts in Google Sheet

48 - Formatting charts in Excel part 1

49 - Formatting charts in Excel part 2

50 - Formatting charts in Google sheet

51 - Line Charts in Excel

52 - Line Charts in Google Sheet

53 - Area Charts in Excel

54 - Area Charts in Google Sheet

55 - Pie and Doughnut Charts in Excel

56 - Pie and Doughnut Charts in Google Sheet

57 - Why we should avoid Pie charts

58 - Scatter plot or XY charts in Excel

59 - Scatter plot or XY charts in Google Sheet

60 - Frequency Distribution and Histograms in Excel

61 - Frequency Distribution and Histograms in Google Sheet

62 - Sparklines in Excel

63 - Sparklines in Google Sheet

9 - Pivot Chart

64 - Pivot Charts in Excel

65 - Pivot Charts in Google Sheet

10 - Map Charts

66 - Map charts in Excel

67 - Map charts in Google Sheet

11 - Special purpose charts

68 - Stock charts in Excel

69 - Stock charts in Google Sheet

70 - Radar charts in Excel

71 - Radar charts in Google Sheet

72 - Heatmaps in Excel

73 - Heatmaps in Google Sheet

12 - Named Ranges

74 - Named Ranges in Excel

75 - Named Ranges in Google Sheet

76 - Indirect Functions in Excel

77 - Indirect Functions in Google Sheet

13 - Shortcuts

78 - Shortcuts in Excel

79 - Shortcuts in Google Sheet

14 - Macros

80 - Macros in Excel

81 - Macros in Google Sheet

15 - New Importing data from PDF and websites

82 - Importing tables from PDF Excel 2021 and office 365

83 - Importing tables from PDF Google Sheet

84 - Importing data from Website Excel 2019 and above

85 - Importing data from Websites Google Sheet

16 - Advanced Excel

86 - Advanced Excel Analytics in Excel

87 - Solving a transportation problem using Excel

17 - Addons in Google sheet

88 - Addons in Google Sheet

89 - Sharing in Google Sheet

18 - Congratulations about your certificate

90 - The final milestone

91 - Bonus Lecture.html

45,900 تومان

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

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

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

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