589689.xyz

Udemy - Microsoft Excel - Advanced Excel Formulas & Functions

  • 收录时间:2022-01-15 18:04:46
  • 文件大小:3GB
  • 下载次数:1
  • 最近下载:2022-01-15 18:04:46
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 05 Lookup & Reference Functions/051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).mp4 172MB
  2. 02 Excel Formulas 101/006 Excel Formula Syntax.mp4 114MB
  3. 02 Excel Formulas 101/012 Saving Time with Function Shortcuts.mp4 104MB
  4. 04 Common Excel Statistical Functions/035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.mp4 95MB
  5. 10 Extra Bonus Functions/104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4 92MB
  6. 02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 89MB
  7. 05 Lookup & Reference Functions/041 Joining Data with VLOOKUP.mp4 82MB
  8. 02 Excel Formulas 101/009 Formula Auditing_ Trace Precedents & Dependents.mp4 80MB
  9. 05 Lookup & Reference Functions/052 Selecting List Items with CHOOSE.mp4 80MB
  10. 04 Common Excel Statistical Functions/034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.mp4 73MB
  11. 10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4 72MB
  12. 06 Text Functions/061 Converting Text to Values with TEXT & VALUE.mp4 55MB
  13. 07 Date & Time Functions/074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4 55MB
  14. 04 Common Excel Statistical Functions/028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.mp4 54MB
  15. 02 Excel Formulas 101/008 Common Excel Error Types.mp4 53MB
  16. 02 Excel Formulas 101/010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).mp4 53MB
  17. 05 Lookup & Reference Functions/040 Introduction to VLOOKUP_HLOOKUP.mp4 52MB
  18. 02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed & Relative References.mp4 51MB
  19. 02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.mp4 49MB
  20. 05 Lookup & Reference Functions/044 Approximate Match Lookups.mp4 46MB
  21. 02 Excel Formulas 101/015 PRO TIP_ Creating Drop-Down Menus with Data Validation.mp4 44MB
  22. 06 Text Functions/064 Combining RIGHT, LEN, and SEARCH.mp4 42MB
  23. 05 Lookup & Reference Functions/043 VLOOKUP Reference Array Options.mp4 40MB
  24. 02 Excel Formulas 101/016 Congrats, You're a Developer!.mp4 34MB
  25. 06 Text Functions/063 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 34MB
  26. 04 Common Excel Statistical Functions/031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.mp4 31MB
  27. 06 Text Functions/062 Searching Text String with SEARCH & FIND.mp4 31MB
  28. 05 Lookup & Reference Functions/055 PRO TIP_ Using OFFSET to Create Interactive Charts.mp4 30MB
  29. 10 Extra Bonus Functions/101 Creating Custom References with INDIRECT.mp4 30MB
  30. 01 Getting Started/001 Course Structure & Outline.mp4 29MB
  31. 03 Conditional Statements & Logical Operators/021 Adding Conditional AND_OR Operators.mp4 28MB
  32. 05 Lookup & Reference Functions/048 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4 27MB
  33. 07 Date & Time Functions/076 DEMO_ Building a Simple Budget Pacing Tool.mp4 26MB
  34. 01 Getting Started/004 Setting Expectations.mp4 25MB
  35. 08 Formula-Based Formatting/082 Formatting Cells Using Stats Functions.mp4 24MB
  36. 05 Lookup & Reference Functions/047 Combining INDEX & MATCH to Dynamically Search Ranges.mp4 24MB
  37. 06 Text Functions/059 Combining Text with CONCATENATE (&).mp4 24MB
  38. 04 Common Excel Statistical Functions/033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4 24MB
  39. 06 Text Functions/058 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4 21MB
  40. 03 Conditional Statements & Logical Operators/024 Common IS Statements.mp4 21MB
  41. 08 Formula-Based Formatting/083 Formatting Cells Using Text Functions & Logical Operators.mp4 21MB
  42. 09 Array Formulas/097 Creating a _MAX IF_ Array Formula with Multiple Criteria.mp4 20MB
  43. 03 Conditional Statements & Logical Operators/023 Fixing Errors with IFERROR.mp4 20MB
  44. 05 Lookup & Reference Functions/050 SNEAK PEEK_ XLOOKUP (Office 365 Only).mp4 20MB
  45. 05 Lookup & Reference Functions/049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.mp4 19MB
  46. 06 Text Functions/060 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4 17MB
  47. 03 Conditional Statements & Logical Operators/019 Anatomy of the IF Statement.mp4 17MB
  48. 03 Conditional Statements & Logical Operators/020 Nesting Multiple IF Statements.mp4 16MB
  49. 05 Lookup & Reference Functions/042 Fixing Errors with IFERROR & VLOOKUP.mp4 15MB
  50. 08 Formula-Based Formatting/080 Highlighting Rows Using the MOD Function.mp4 15MB
  51. 04 Common Excel Statistical Functions/027 Basic Excel Statistical Functions.mp4 15MB
  52. 10 Extra Bonus Functions/102 Linking to Worksheet Locations with HYPERLINK.mp4 14MB
  53. 04 Common Excel Statistical Functions/032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4 14MB
  54. 07 Date & Time Functions/068 Understanding Excel Date Syntax with DATEVALUE.mp4 14MB
  55. 09 Array Formulas/092 Restructuring Data with TRANSPOSE.mp4 14MB
  56. 07 Date & Time Functions/072 Calculating the Month Start or End with EOMONTH.mp4 13MB
  57. 09 Array Formulas/089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.mp4 13MB
  58. 09 Array Formulas/098 Converting Boolean Values Using the Double Unary (_--_).mp4 12MB
  59. 08 Formula-Based Formatting/079 Creating, Editing & Managing Formula-Based Rules.mp4 12MB
  60. 03 Conditional Statements & Logical Operators/022 Using NOT & ____ Conditionals.mp4 11MB
  61. 05 Lookup & Reference Functions/038 Working with Named Ranges.mp4 11MB
  62. 07 Date & Time Functions/067 Introduction.mp4 11MB
  63. 09 Array Formulas/094 Returning the Largest Values in a Range.mp4 11MB
  64. 04 Common Excel Statistical Functions/030 Row-Level Calculation with SUMPRODUCT.mp4 11MB
  65. 07 Date & Time Functions/075 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4 10MB
  66. 08 Formula-Based Formatting/081 Formatting Based on the Value of Another Cell.mp4 10MB
  67. 09 Array Formulas/091 Defining & Referencing Named Array Constants.mp4 10MB
  68. 01 Getting Started/003 Excel-Demo-Workbooks-COMPLETE.zip 10MB
  69. 06 Text Functions/065 Replacing Text with SUBSTITUTE.mp4 10MB
  70. 05 Lookup & Reference Functions/039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.mp4 10MB
  71. 05 Lookup & Reference Functions/046 Matching Text & Values with MATCH.mp4 9MB
  72. 09 Array Formulas/096 Creating a _MAX IF_ Array Formula.mp4 9MB
  73. 08 Formula-Based Formatting/078 Introduction.mp4 9MB
  74. 09 Array Formulas/093 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4 9MB
  75. 09 Array Formulas/087 Rules of Excel Array Functions.mp4 9MB
  76. 10 Extra Bonus Functions/100 Introduction.mp4 9MB
  77. 07 Date & Time Functions/069 Formatting Dates & Filling Date Series.mp4 9MB
  78. 07 Date & Time Functions/071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4 8MB
  79. 05 Lookup & Reference Functions/054 Combining OFFSET with COUNTA to Create a Flexible Range.mp4 8MB
  80. 05 Lookup & Reference Functions/037 Introduction.mp4 7MB
  81. 09 Array Formulas/090 Using Array Constants in Formulas.mp4 7MB
  82. 09 Array Formulas/099 HOMEWORK_ Excel Array Functions.mp4 7MB
  83. 09 Array Formulas/085 Introduction.mp4 7MB
  84. 05 Lookup & Reference Functions/053 Defining Ranges with OFFSET.mp4 7MB
  85. 04 Common Excel Statistical Functions/026 Introduction.mp4 6MB
  86. 04 Common Excel Statistical Functions/029 Randomization with RAND() & RANDBETWEEN.mp4 6MB
  87. 03 Conditional Statements & Logical Operators/018 Introduction.mp4 6MB
  88. 02 Excel Formulas 101/005 Introduction_ Excel Formulas 101.mp4 6MB
  89. 05 Lookup & Reference Functions/045 Navigating Cell Ranges with INDEX.mp4 6MB
  90. 07 Date & Time Functions/073 Calculating % of Year with YEARFRAC.mp4 6MB
  91. 09 Array Formulas/095 Counting Characters Across Cells.mp4 6MB
  92. 07 Date & Time Functions/070 Creating Real-Time Functions with TODAY & NOW.mp4 5MB
  93. 01 Getting Started/003 Excel-Demo-Workbooks.zip 5MB
  94. 09 Array Formulas/088 Pros & Cons of Array Functions.mp4 5MB
  95. 02 Excel Formulas 101/017 HOMEWORK_ Excel Formulas 101.mp4 5MB
  96. 06 Text Functions/057 Introduction.mp4 4MB
  97. 05 Lookup & Reference Functions/056 HOMEWORK_ Excel Lookup & Reference Functions.mp4 3MB
  98. 06 Text Functions/066 HOMEWORK_ Excel Text Functions.mp4 3MB
  99. 01 Getting Started/003 Excel-Formulas-Functions.pdf 2MB
  100. 03 Conditional Statements & Logical Operators/025 HOMEWORK_ Excel Logical Operators.mp4 2MB
  101. 04 Common Excel Statistical Functions/036 HOMEWORK_ Excel Stats Functions.mp4 2MB
  102. 08 Formula-Based Formatting/084 HOMEWORK_ Excel Formula-Based Formatting.mp4 2MB
  103. 07 Date & Time Functions/077 HOMEWORK_ Excel Date & Time Functions.mp4 1MB
  104. 01 Getting Started/003 Excel-Homework-Workbooks.zip 138KB
  105. 09 Array Formulas/097 Creating a _MAX IF_ Array Formula with Multiple Criteria.en.srt 33KB
  106. 05 Lookup & Reference Functions/051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).en.srt 26KB
  107. 05 Lookup & Reference Functions/049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.en.srt 26KB
  108. 05 Lookup & Reference Functions/042 Fixing Errors with IFERROR & VLOOKUP.en.srt 23KB
  109. 04 Common Excel Statistical Functions/035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.en.srt 23KB
  110. 05 Lookup & Reference Functions/052 Selecting List Items with CHOOSE.en.srt 19KB
  111. 09 Array Formulas/098 Converting Boolean Values Using the Double Unary (_--_).en.srt 18KB
  112. 02 Excel Formulas 101/006 Excel Formula Syntax.en.srt 16KB
  113. 05 Lookup & Reference Functions/054 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt 16KB
  114. 07 Date & Time Functions/076 DEMO_ Building a Simple Budget Pacing Tool.en.srt 15KB
  115. 02 Excel Formulas 101/012 Saving Time with Function Shortcuts.en.srt 14KB
  116. 02 Excel Formulas 101/009 Formula Auditing_ Trace Precedents & Dependents.en.srt 14KB
  117. 10 Extra Bonus Functions/101 Creating Custom References with INDIRECT.en.srt 14KB
  118. 05 Lookup & Reference Functions/055 PRO TIP_ Using OFFSET to Create Interactive Charts.en.srt 14KB
  119. 02 Excel Formulas 101/008 Common Excel Error Types.en.srt 13KB
  120. 10 Extra Bonus Functions/104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).en.srt 13KB
  121. 02 Excel Formulas 101/007 Writing Efficient Formulas with Fixed & Relative References.en.srt 12KB
  122. 06 Text Functions/065 Replacing Text with SUBSTITUTE.en.srt 12KB
  123. 02 Excel Formulas 101/010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).en.srt 11KB
  124. 03 Conditional Statements & Logical Operators/021 Adding Conditional AND_OR Operators.en.srt 11KB
  125. 09 Array Formulas/099 HOMEWORK_ Excel Array Functions.en.srt 11KB
  126. 04 Common Excel Statistical Functions/034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.en.srt 11KB
  127. 04 Common Excel Statistical Functions/033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.en.srt 11KB
  128. 02 Excel Formulas 101/011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt 10KB
  129. 10 Extra Bonus Functions/103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).en.srt 10KB
  130. 07 Date & Time Functions/074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.en.srt 9KB
  131. 02 Excel Formulas 101/015 PRO TIP_ Creating Drop-Down Menus with Data Validation.en.srt 9KB
  132. 07 Date & Time Functions/072 Calculating the Month Start or End with EOMONTH.en.srt 9KB
  133. 05 Lookup & Reference Functions/047 Combining INDEX & MATCH to Dynamically Search Ranges.en.srt 9KB
  134. 04 Common Excel Statistical Functions/028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.en.srt 9KB
  135. 09 Array Formulas/089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.en.srt 8KB
  136. 05 Lookup & Reference Functions/043 VLOOKUP Reference Array Options.en.srt 8KB
  137. 05 Lookup & Reference Functions/041 Joining Data with VLOOKUP.en.srt 8KB
  138. 05 Lookup & Reference Functions/040 Introduction to VLOOKUP_HLOOKUP.en.srt 8KB
  139. 10 Extra Bonus Functions/102 Linking to Worksheet Locations with HYPERLINK.en.srt 8KB
  140. 06 Text Functions/064 Combining RIGHT, LEN, and SEARCH.en.srt 8KB
  141. 06 Text Functions/063 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt 8KB
  142. 04 Common Excel Statistical Functions/027 Basic Excel Statistical Functions.en.srt 7KB
  143. 02 Excel Formulas 101/016 Congrats, You're a Developer!.en.srt 7KB
  144. 05 Lookup & Reference Functions/044 Approximate Match Lookups.en.srt 7KB
  145. 06 Text Functions/062 Searching Text String with SEARCH & FIND.en.srt 7KB
  146. 04 Common Excel Statistical Functions/031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.en.srt 7KB
  147. 03 Conditional Statements & Logical Operators/020 Nesting Multiple IF Statements.en.srt 7KB
  148. 08 Formula-Based Formatting/083 Formatting Cells Using Text Functions & Logical Operators.en.srt 7KB
  149. 08 Formula-Based Formatting/079 Creating, Editing & Managing Formula-Based Rules.en.srt 7KB
  150. 05 Lookup & Reference Functions/048 Combining MATCH & VLOOKUP for More Flexible Lookups.en.srt 7KB
  151. 05 Lookup & Reference Functions/050 SNEAK PEEK_ XLOOKUP (Office 365 Only).en.srt 7KB
  152. 08 Formula-Based Formatting/082 Formatting Cells Using Stats Functions.en.srt 7KB
  153. 11 Wrapping Up/105 BONUS LECTURE_ More from Maven Analytics.html 7KB
  154. 04 Common Excel Statistical Functions/032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.en.srt 6KB
  155. 07 Date & Time Functions/068 Understanding Excel Date Syntax with DATEVALUE.en.srt 6KB
  156. 09 Array Formulas/092 Restructuring Data with TRANSPOSE.en.srt 6KB
  157. 02 Excel Formulas 101/013 Accessing Tools with Alt Key Tips.en.srt 6KB
  158. 07 Date & Time Functions/075 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt 6KB
  159. 03 Conditional Statements & Logical Operators/019 Anatomy of the IF Statement.en.srt 6KB
  160. 03 Conditional Statements & Logical Operators/023 Fixing Errors with IFERROR.en.srt 6KB
  161. 09 Array Formulas/091 Defining & Referencing Named Array Constants.en.srt 6KB
  162. 06 Text Functions/061 Converting Text to Values with TEXT & VALUE.en.srt 6KB
  163. 01 Getting Started/004 Setting Expectations.en.srt 5KB
  164. 04 Common Excel Statistical Functions/030 Row-Level Calculation with SUMPRODUCT.en.srt 5KB
  165. 08 Formula-Based Formatting/080 Highlighting Rows Using the MOD Function.en.srt 5KB
  166. 06 Text Functions/066 HOMEWORK_ Excel Text Functions.en.srt 5KB
  167. 01 Getting Started/002 READ ME_ Important Notes for New Students.html 5KB
  168. 03 Conditional Statements & Logical Operators/024 Common IS Statements.en.srt 5KB
  169. 05 Lookup & Reference Functions/056 HOMEWORK_ Excel Lookup & Reference Functions.en.srt 5KB
  170. 07 Date & Time Functions/069 Formatting Dates & Filling Date Series.en.srt 5KB
  171. 05 Lookup & Reference Functions/038 Working with Named Ranges.en.srt 5KB
  172. 09 Array Formulas/087 Rules of Excel Array Functions.en.srt 5KB
  173. 09 Array Formulas/090 Using Array Constants in Formulas.en.srt 5KB
  174. 08 Formula-Based Formatting/081 Formatting Based on the Value of Another Cell.en.srt 5KB
  175. 06 Text Functions/060 Extracting Strings with LEFT, MID, RIGHT & LEN.en.srt 5KB
  176. 06 Text Functions/058 Capitalization with UPPER, LOWER, PROPER & TRIM.en.srt 5KB
  177. 06 Text Functions/059 Combining Text with CONCATENATE (&).en.srt 5KB
  178. 03 Conditional Statements & Logical Operators/022 Using NOT & ____ Conditionals.en.srt 4KB
  179. 09 Array Formulas/096 Creating a _MAX IF_ Array Formula.en.srt 4KB
  180. 03 Conditional Statements & Logical Operators/025 HOMEWORK_ Excel Logical Operators.en.srt 4KB
  181. 07 Date & Time Functions/071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.en.srt 4KB
  182. 05 Lookup & Reference Functions/039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.en.srt 4KB
  183. 09 Array Formulas/094 Returning the Largest Values in a Range.en.srt 4KB
  184. 05 Lookup & Reference Functions/046 Matching Text & Values with MATCH.en.srt 4KB
  185. 09 Array Formulas/088 Pros & Cons of Array Functions.en.srt 3KB
  186. 07 Date & Time Functions/070 Creating Real-Time Functions with TODAY & NOW.en.srt 3KB
  187. 09 Array Formulas/093 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt 3KB
  188. 07 Date & Time Functions/077 HOMEWORK_ Excel Date & Time Functions.en.srt 3KB
  189. 05 Lookup & Reference Functions/053 Defining Ranges with OFFSET.en.srt 3KB
  190. 07 Date & Time Functions/073 Calculating % of Year with YEARFRAC.en.srt 3KB
  191. 05 Lookup & Reference Functions/045 Navigating Cell Ranges with INDEX.en.srt 3KB
  192. 07 Date & Time Functions/067 Introduction.en.srt 3KB
  193. 02 Excel Formulas 101/005 Introduction_ Excel Formulas 101.en.srt 3KB
  194. 04 Common Excel Statistical Functions/029 Randomization with RAND() & RANDBETWEEN.en.srt 3KB
  195. 08 Formula-Based Formatting/084 HOMEWORK_ Excel Formula-Based Formatting.en.srt 3KB
  196. 09 Array Formulas/086 READ ME_ Array Formulas are Changing!.html 3KB
  197. 09 Array Formulas/085 Introduction.en.srt 2KB
  198. 09 Array Formulas/095 Counting Characters Across Cells.en.srt 2KB
  199. 10 Extra Bonus Functions/100 Introduction.en.srt 2KB
  200. 08 Formula-Based Formatting/078 Introduction.en.srt 2KB
  201. 01 Getting Started/003 DOWNLOAD_ Course Resources.html 2KB
  202. 01 Getting Started/001 Course Structure & Outline.en.srt 2KB
  203. 05 Lookup & Reference Functions/037 Introduction.en.srt 2KB
  204. 03 Conditional Statements & Logical Operators/018 Introduction.en.srt 2KB
  205. 04 Common Excel Statistical Functions/026 Introduction.en.srt 2KB
  206. 06 Text Functions/057 Introduction.en.srt 1KB
  207. 02 Excel Formulas 101/014 BONUS_ Mac Shortcuts.html 1KB
  208. 04 Common Excel Statistical Functions/036 HOMEWORK_ Excel Stats Functions.en.srt 1KB
  209. 02 Excel Formulas 101/017 HOMEWORK_ Excel Formulas 101.en.srt 845B