Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:02:54
    The Excel Bootcamp: Zero to Mastery
  2. Урок 2. 00:05:13
    Course Outline
  3. Урок 3. 00:10:03
    Hello Excel Part 1
  4. Урок 4. 00:12:11
    Hello Excel Part 2
  5. Урок 5. 00:11:55
    Data Entry Part 1
  6. Урок 6. 00:10:39
    Data Entry Part 2
  7. Урок 7. 00:10:55
    Autofill
  8. Урок 8. 00:11:29
    Working With Ranges
  9. Урок 9. 00:09:41
    Working With Rows and Columns
  10. Урок 10. 00:09:36
    Resizing Rows and Columns
  11. Урок 11. 00:09:48
    Freezing Rows and Columns
  12. Урок 12. 00:10:34
    Working With Multiple Worksheets
  13. Урок 13. 00:14:02
    Find and Replace
  14. Урок 14. 00:10:24
    Working With Multiple Workbooks
  15. Урок 15. 00:04:36
    Intro to Formatting
  16. Урок 16. 00:11:07
    Formatting Numbers
  17. Урок 17. 00:11:28
    Formatting Dates and Times
  18. Урок 18. 00:11:31
    Font Styles
  19. Урок 19. 00:10:39
    Text Wrapping and Alignment
  20. Урок 20. 00:09:20
    Cell Borders and Merging
  21. Урок 21. 00:08:11
    Intro to Filtering
  22. Урок 22. 00:16:01
    Advanced Filtering
  23. Урок 23. 00:14:26
    Sorting in Excel
  24. Урок 24. 00:08:29
    Intro to Formulas
  25. Урок 25. 00:09:51
    Arithmetic Formulas
  26. Урок 26. 00:07:49
    Applying Formulas to Text
  27. Урок 27. 00:09:04
    Applying Formulas to Dates
  28. Урок 28. 00:12:21
    Copying and Cutting Formulas
  29. Урок 29. 00:13:37
    Cell References
  30. Урок 30. 00:02:50
    Hiding Rows and Columns
  31. Урок 31. 00:01:53
    Budget Project: Introduction
  32. Урок 32. 00:06:22
    Budget Project: Formulas 101
  33. Урок 33. 00:10:46
    Intro to Excel Functions
  34. Урок 34. 00:14:37
    Arithmetic Functions
  35. Урок 35. 00:06:04
    Counting Functions
  36. Урок 36. 00:02:24
    The Status Bar
  37. Урок 37. 00:09:11
    Rounding and Truncation
  38. Урок 38. 00:08:23
    Median
  39. Урок 39. 00:07:54
    Standard Deviation
  40. Урок 40. 00:05:35
    Budget Project: Crunching Numbers With Excel Functions
  41. Урок 41. 00:12:20
    Conditional Calculations I
  42. Урок 42. 00:12:10
    Conditional Calculations II
  43. Урок 43. 00:14:13
    Conditional Calculations III
  44. Урок 44. 00:04:53
    Budget Project: Conditional Calculations
  45. Урок 45. 00:04:16
    Introducing Date and Time Functions
  46. Урок 46. 00:07:35
    Parsing Date and Time Components
  47. Урок 47. 00:05:50
    The DATE Function
  48. Урок 48. 00:07:31
    Applying the DATE and TIME Functions
  49. Урок 49. 00:09:10
    DATEDIF and NETWORKDAYS
  50. Урок 50. 00:06:38
    Transforming Date Values
  51. Урок 51. 00:08:36
    Budget Project: Date and Time Functions
  52. Урок 52. 00:06:14
    LEFT, RIGHT, and MID
  53. Урок 53. 00:15:21
    FIND and LEN
  54. Урок 54. 00:10:17
    Text Cleaning Functions
  55. Урок 55. 00:11:36
    TEXTJOIN
  56. Урок 56. 00:08:19
    Budget Project: Text Functions
  57. Урок 57. 00:02:56
    Exercise: Imposter Syndrome
  58. Урок 58. 00:15:37
    The IF Function
  59. Урок 59. 00:10:45
    AND and OR
  60. Урок 60. 00:11:58
    IFS
  61. Урок 61. 00:10:27
    VLOOKUP
  62. Урок 62. 00:09:26
    VLOOKUP with IFERROR
  63. Урок 63. 00:12:01
    XLOOKUP
  64. Урок 64. 00:08:50
    Handling Errors with XLOOKUP
  65. Урок 65. 00:10:47
    Matching Lists
  66. Урок 66. 00:04:11
    Budget Project: IF Statements
  67. Урок 67. 00:02:59
    Intro to Modeling
  68. Урок 68. 00:07:08
    The PMT Function
  69. Урок 69. 00:08:17
    Data Validation Lists
  70. Урок 70. 00:16:12
    Scroll Bars
  71. Урок 71. 00:11:16
    Named Ranges
  72. Урок 72. 00:07:26
    Model Design
  73. Урок 73. 00:11:54
    Budget Project: Modeling
  74. Урок 74. 00:09:10
    Custom Formats
  75. Урок 75. 00:07:10
    Conditional Formatting I
  76. Урок 76. 00:10:19
    Conditional Formatting II
  77. Урок 77. 00:13:11
    Introducing Charts
  78. Урок 78. 00:07:10
    Column Charts
  79. Урок 79. 00:12:08
    Line Charts
  80. Урок 80. 00:09:56
    Budget Project: Data Visualization
  81. Урок 81. 00:05:56
    Text to Columns
  82. Урок 82. 00:10:05
    External Data
  83. Урок 83. 00:09:59
    Table Features
  84. Урок 84. 00:14:10
    Tables as Named Ranges
  85. Урок 85. 00:09:33
    Budget Project: Structured Data
  86. Урок 86. 00:13:04
    Intro to Pivot Tables
  87. Урок 87. 00:14:09
    Adding Layers to Pivot Tables
  88. Урок 88. 00:10:58
    Pivot Table Formatting and Layout
  89. Урок 89. 00:10:04
    Filtering Pivot Tables
  90. Урок 90. 00:11:13
    Slicers
  91. Урок 91. 00:09:45
    Pivot Table Math
  92. Урок 92. 00:06:29
    Budget Project: Pivot Tables
  93. Урок 93. 00:13:30
    SEQUENCE
  94. Урок 94. 00:11:03
    SORT
  95. Урок 95. 00:07:33
    UNIQUE
  96. Урок 96. 00:08:56
    CHOOSECOLS
  97. Урок 97. 00:13:52
    FILTER I
  98. Урок 98. 00:13:00
    Combining FILTER, CHOOSECOLS and SORT
  99. Урок 99. 00:13:25
    FILTER II
  100. Урок 100. 00:11:03
    FILTER III
  101. Урок 101. 00:12:45
    Refactoring with Tables
  102. Урок 102. 00:12:58
    Refactoring with LET
  103. Урок 103. 00:03:49
    Project 1 - Introduction
  104. Урок 104. 00:08:56
    Project 1 - Solution
  105. Урок 105. 00:08:03
    Combining FILTER, UNIQUE and SORT
  106. Урок 106. 00:10:03
    Referencing Dynamic Arrays I
  107. Урок 107. 00:11:41
    Referencing Dynamic Arrays II
  108. Урок 108. 00:08:29
    Creating Dynamic Drop - Down Lists
  109. Урок 109. 00:03:48
    Project 2 - Introduction
  110. Урок 110. 00:11:35
    Project 2 - Solution
  111. Урок 111. 00:12:37
    GROUPBY - Part 1
  112. Урок 112. 00:14:04
    GROUPBY - Part 2
  113. Урок 113. 00:06:36
    GROUPBY - Part 3
  114. Урок 114. 00:14:51
    PIVOTBY
  115. Урок 115. 00:09:22
    Project 3 - Introduction
  116. Урок 116. 00:12:08
    Project 3 - Solution
  117. Урок 117. 00:09:25
    Intro to Macros
  118. Урок 118. 00:04:54
    Running Macros With Buttons
  119. Урок 119. 00:09:45
    Editing Macros
  120. Урок 120. 00:19:28
    Macros - A Case Study
  121. Урок 121. 00:06:53
    Budget Project: Macros and VBA
  122. Урок 122. 00:05:25
    Capstone Project Demo
  123. Урок 123. 00:02:48
    Introducing the Project Template
  124. Урок 124. 00:02:54
    Applying Number Formats
  125. Урок 125. 00:02:06
    Solution: Applying Number Formats
  126. Урок 126. 00:01:41
    Creating Drop Down Lists
  127. Урок 127. 00:03:38
    Solution: Creating Drop Down Lists
  128. Урок 128. 00:02:37
    Creating the Retirement Age Slider
  129. Урок 129. 00:04:25
    Solution: Creating the Retirement Age Slider
  130. Урок 130. 00:04:12
    Applying Cell Styles
  131. Урок 131. 00:03:09
    Solution: Applying Cell Styles
  132. Урок 132. 00:03:25
    Defining Names
  133. Урок 133. 00:03:43
    Solution: Defining Names
  134. Урок 134. 00:03:44
    Fetching the Investment Return
  135. Урок 135. 00:05:23
    Solution: Fetching the Investment Return
  136. Урок 136. 00:03:35
    Plan Year and Age
  137. Урок 137. 00:02:11
    Solution: Plan Year and Age
  138. Урок 138. 00:03:30
    Working Income
  139. Урок 139. 00:03:39
    Solution: Working Income
  140. Урок 140. 00:02:01
    Income Tax and Yearly Expenditures
  141. Урок 141. 00:02:51
    Solution: Income Tax and Yearly Expenditures
  142. Урок 142. 00:01:21
    Yearly Savings
  143. Урок 143. 00:02:33
    Solution: Yearly Savings
  144. Урок 144. 00:02:26
    Earned Interest and Retirement Savings Balance
  145. Урок 145. 00:02:25
    Solution: Earned Interest and Retirement Savings Balance
  146. Урок 146. 00:04:22
    Earned Interest and Retirement Savings Balance II
  147. Урок 147. 00:05:07
    Solution: Earned Interest and Retirement Savings Balance II
  148. Урок 148. 00:04:45
    Wrapping Up the Calculations Worksheet
  149. Урок 149. 00:05:41
    Solution: Wrapping Up the Calculations Worksheet
  150. Урок 150. 00:03:43
    Retirement Age and Years Calcs
  151. Урок 151. 00:02:50
    Solution: Retirement Age and Years Calcs
  152. Урок 152. 00:05:32
    The Banner Message
  153. Урок 153. 00:04:24
    Solution: The Banner Message
  154. Урок 154. 00:01:52
    The Retirement Balance Chart
  155. Урок 155. 00:04:57
    Solution: The Retirement Balance Chart
  156. Урок 156. 00:08:36
    Dynamic Charts with OFFSET I
  157. Урок 157. 00:14:29
    Dynamic Charts with OFFSET II
  158. Урок 158. 00:08:44
    Solution: Dynamic Charts with OFFSET
  159. Урок 159. 00:03:21
    Formatting the Retirement Balance Chart
  160. Урок 160. 00:03:32
    Solution: Formatting the Retirement Balance Chart
  161. Урок 161. 00:04:47
    The Detail Worksheet
  162. Урок 162. 00:08:08
    Solution: The Detail Worksheet
  163. Урок 163. 00:01:01
    The End (a.k.a. Retirement)
  164. Урок 164. 00:01:18
    Thank You!