Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT

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

Starting from Zero, Master Excel, Data Analysis in Excel, leveraging advanced tools like Power Pivot, DAX, & ChatGPT

1 - Level 1 Getting to know Excel

1 - Getting started with Excel

2 - Understanding and working with Cell

3 - Understanding and working with Column

4 - Understanding and working with Row

5 - Mastering Copy Paste

6 - Mastering Autofill

7 - Intelligent navigation with Excel data

8 - Basic Mathematical functions

9 - Unlocking Keyboard Shortcuts with Masterkey

10 - Homework Entering 10 records in Excel

11 - Best Practices Entering data in Excel

2 - Level 2 Cleaning data

12 - Product-Lookup-removing-duplicates.xlsx

12 - Remove duplicates

13 - Product-Lookup-removing-spaces.xlsx

13 - Removing spaces

14 - Product-Lookup-spell-check.xlsx

14 - Spell check

15 - Find Find Replace

15 - Product-Lookup-find-find-and-replace.xlsx

16 - Product-Lookup-blanks.xlsx

16 - Replacing blank cells

17 - Product-Lookup-Proper-case.xlsx

17 - Using proper fonts

18 - Extracting Substring or part of data

18 - Substring.xlsx

18 - Substring-unsolved.xlsx

3 - Level 3 Transforming Data

19 - Merging data in cells

19 - Product-Lookup-merging-data-in-columns.xlsx

20 - Product-Lookup-unmerge-or-delimate.xlsx

20 - Text to Columns

21 - Data Sorting

21 - Product-Lookup-sorting.xlsx

22 - Transpose.xlsx

22 - Transpose Data

23 - Flash Fill

23 - Flash-fill.xlsx

4 - Level 4 Compiling data

24 - Vlookup

24 - Vlookup-practice-file.xlsx

25 - Hlookup

25 - Hlookup.xlsx

26 - IndexMatch.xlsx

26 - Index and match

27 - Consolidate

27 - Consolidate.xlsx

28 - Append data with Power Query

28 - MonthlySalesFiles.zip

5 - Level 5 Getting ready for Data Analysis

29 - Getting-ready-for-data-analysis-lectures.xlsx

29 - Manipulating dates Date Month Year

30 - Manipulate dates Name of the Day Name of the Month

31 - Manipulating dates Day of the week Week of the year

32 - Day of the Year

33 - Quarter of the Year

34 - Dynamic TODAY Tomorrow Yesterday

35 - Calculating Age

36 - Adding conditional columns based on IF

37 - NESTED IF

38 - IF OR

39 - IF OR Multiple Column

40 - IF OR OR OR Practice

41 - IF AND

42 - IF AND AND AND Practice

6 - Writing formulas to Clean transform Compile Analyze Data with AI ChatGPT

43 - Note for upcoming lectures.html

44 - Getting started writing basic formulas with AI

45 - Writing complex IF formulas with AI

7 - Level 6 Basic Data Analysis Ad hoc Data Analysis

46 - Analysis-sheet.xlsx

46 - Freeze Panes

47 - Filters and advance filters

48 - Conditional Formatting

49 - Subtotals

50 - COUNTIF

51 - COUNTIFS

52 - SUMIF

53 - SUMIFS

8 - Level 7 Data Analysis

54 - Analysis-lectures.xlsx

54 - Introduction to Data Analaysis and Data

55 - Summay by a parameter

56 - Adding parameters with drill down and drill up

57 - Breaking down information by Column

58 - Filtering the data in reports

59 - Understanding Value Field Settings

60 - Working with Dates in rows

61 - Grouping example

62 - Compiling data on one sheet

63 - Slicers

64 - Timeline

65 - Adding Calculated Fields

66 - Calculated Fields Why this approach is better

9 - Level 8 Preparing Dashboard

67 - Dashboard-data.xlsx

67 - Introduction and first chart

68 - Exploring the chart options further

69 - Compiling data on one sheet

70 - Adding timeline time slicer on dashboard

71 - Adding and adjusting slicers

72 - Adding trendline charts

10 - Advanced Data Analysis Introduction and set up

73 - Beyond Pivot Tables

74 - A Quick Glimpse into Power Pivot

75 - Installing Power Pivot in Excel

76 - Business-Data-course-file.xlsx

76 - Download section data file.html

77 - Understanding Relational Data

78 - Uploading data to Data Model

79 - Connecting Tables Data Modeling

80 - Deploying Power Pivot and Exploring it

81 - Distinct Count The Amazing New Field Summarization

82 - Lecture-file-Section-10.xlsx

82 - Section file.html

83 - Next step

11 - Unlocking Advanced Calculations and Analytics

84 - Introduction to DAX

85 - Day Month Year

86 - Month Name WeekDay Name WeekDay

87 - IF IF OR IF AND IF OR AND

88 - Homework IF.html

89 - Multiple conditions with IN

90 - Variables Simplifying formulas

91 - Lecture file.html

91 - Lecture-file-Section-12-File1.xlsx

92 - Nested IF in DAX

93 - SWITCH SWITCH TRUE

94 - SWITCH Continued

95 - Next steps

12 - Putting ChatGPT to write DAX

96 - Firing up the ChatGPT

97 - Intro Prompt.html

98 - Writing Basic DAX functions with ChatGPT

99 - Just received a ChatGPT update

100 - Making ChatGPT write Conditional Columns

101 - Biggest use of ChatGPT with DAX.html

13 - DAX Part 2

102 - Simple Mathematical Calculation Column

103 - Simple Mathematical Column 2 Calculating Sales

104 - RELATED the vlookup xlookup of DAX

105 - RELATED within Calculations

106 - Deleting the unwanted columns

14 - DAX Measures The Real Deal

107 - Our first DAX Measure SUM

108 - Other Basic functions.html

109 - SUMX

110 - SUMX with RELATED

111 - Download the new and old section files here.html

111 - Section-14-File.xlsx

111 - Section-14-File-2.xlsx

112 - Let CHATGPT write measures for you

113 - CALCULATE Calculate values matching a Specific Criteria

114 - A complex calculation with our CALCULATED Value

115 - Section file.html

115 - Section-14-File-2.xlsx

15 - Time Intelligence with DAX

116 - Understanding standard time intelligence and its problems

117 - MIN and MAX

118 - ALL Bypassing Filters MIN Date Across Data

119 - Homework MAX Date Across.html

120 - YTD Year to Date Values

121 - QTD Quarter to Date and MTD Month to Date

122 - TTD Total to Date

123 - FTP For the period Values

124 - Rolling Sum and Moving Average

125 - Rolling Sum and Moving Average excluding the first two months

126 - Excel file for download.html

126 - Section-15-file.xlsx

16 - Time Intelligence with DAX Part 2 Comparison over periods

127 - Calculating Previous Month Value

128 - Calculating Previous Period Value dynamically

129 - Presenting growth in percentage

130 - Calculating Previous Corresponding Period value

131 - Homework PCP Growth.html

132 - PCP Growth

133 - 5.PCP-Growth

133 - Section file.html

17 - Clean Transform with Power Query

134 - Introduction

135 - Navigating to Power Query

136 - Combining Sales from three tables to one

137 - Adding a Unique row identifier for each row Index Column

138 - Adding new columns

139 - Merging tables

140 - Other key features and Uploading data

141 - Book2.xlsx

141 - Section data file.html

18 - Bonus Section

142 - Bonus lecture.html

189,000 تومان

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

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

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

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