Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай The Excel Bootcamp: Zero to Mastery, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:02:54
    The Excel Bootcamp: Zero to Mastery
  • Урок 2. 00:05:13
    Course Outline
  • Урок 3. 00:10:03
    Hello Excel Part 1
  • Урок 4. 00:12:11
    Hello Excel Part 2
  • Урок 5. 00:11:55
    Data Entry Part 1
  • Урок 6. 00:10:39
    Data Entry Part 2
  • Урок 7. 00:10:55
    Autofill
  • Урок 8. 00:11:29
    Working With Ranges
  • Урок 9. 00:09:41
    Working With Rows and Columns
  • Урок 10. 00:09:36
    Resizing Rows and Columns
  • Урок 11. 00:09:48
    Freezing Rows and Columns
  • Урок 12. 00:10:34
    Working With Multiple Worksheets
  • Урок 13. 00:14:02
    Find and Replace
  • Урок 14. 00:10:24
    Working With Multiple Workbooks
  • Урок 15. 00:04:36
    Intro to Formatting
  • Урок 16. 00:11:07
    Formatting Numbers
  • Урок 17. 00:11:28
    Formatting Dates and Times
  • Урок 18. 00:11:31
    Font Styles
  • Урок 19. 00:10:39
    Text Wrapping and Alignment
  • Урок 20. 00:09:20
    Cell Borders and Merging
  • Урок 21. 00:08:11
    Intro to Filtering
  • Урок 22. 00:16:01
    Advanced Filtering
  • Урок 23. 00:14:26
    Sorting in Excel
  • Урок 24. 00:08:29
    Intro to Formulas
  • Урок 25. 00:09:51
    Arithmetic Formulas
  • Урок 26. 00:07:49
    Applying Formulas to Text
  • Урок 27. 00:09:04
    Applying Formulas to Dates
  • Урок 28. 00:12:21
    Copying and Cutting Formulas
  • Урок 29. 00:13:37
    Cell References
  • Урок 30. 00:02:50
    Hiding Rows and Columns
  • Урок 31. 00:01:53
    Budget Project: Introduction
  • Урок 32. 00:06:22
    Budget Project: Formulas 101
  • Урок 33. 00:10:46
    Intro to Excel Functions
  • Урок 34. 00:14:37
    Arithmetic Functions
  • Урок 35. 00:06:04
    Counting Functions
  • Урок 36. 00:02:24
    The Status Bar
  • Урок 37. 00:09:11
    Rounding and Truncation
  • Урок 38. 00:08:23
    Median
  • Урок 39. 00:07:54
    Standard Deviation
  • Урок 40. 00:05:35
    Budget Project: Crunching Numbers With Excel Functions
  • Урок 41. 00:12:20
    Conditional Calculations I
  • Урок 42. 00:12:10
    Conditional Calculations II
  • Урок 43. 00:14:13
    Conditional Calculations III
  • Урок 44. 00:04:53
    Budget Project: Conditional Calculations
  • Урок 45. 00:04:16
    Introducing Date and Time Functions
  • Урок 46. 00:07:35
    Parsing Date and Time Components
  • Урок 47. 00:05:50
    The DATE Function
  • Урок 48. 00:07:31
    Applying the DATE and TIME Functions
  • Урок 49. 00:09:10
    DATEDIF and NETWORKDAYS
  • Урок 50. 00:06:38
    Transforming Date Values
  • Урок 51. 00:08:36
    Budget Project: Date and Time Functions
  • Урок 52. 00:06:14
    LEFT, RIGHT, and MID
  • Урок 53. 00:15:21
    FIND and LEN
  • Урок 54. 00:10:17
    Text Cleaning Functions
  • Урок 55. 00:02:56
    Exercise: Imposter Syndrome
  • Урок 56. 00:15:37
    The IF Function
  • Урок 57. 00:10:45
    AND and OR
  • Урок 58. 00:10:27
    VLOOKUP
  • Урок 59. 00:09:26
    VLOOKUP with IFERROR
  • Урок 60. 00:02:59
    Intro to Modeling
  • Урок 61. 00:07:08
    The PMT Function
  • Урок 62. 00:08:17
    Data Validation Lists
  • Урок 63. 00:16:12
    Scroll Bars
  • Урок 64. 00:11:16
    Named Ranges
  • Урок 65. 00:07:26
    Model Design
  • Урок 66. 00:11:54
    Budget Project: Modeling
  • Урок 67. 00:09:10
    Custom Formats
  • Урок 68. 00:07:10
    Conditional Formatting I
  • Урок 69. 00:10:19
    Conditional Formatting II
  • Урок 70. 00:13:11
    Introducing Charts
  • Урок 71. 00:07:10
    Column Charts
  • Урок 72. 00:12:08
    Line Charts
  • Урок 73. 00:09:56
    Budget Project: Data Visualization
  • Урок 74. 00:10:05
    External Data
  • Урок 75. 00:05:56
    Text to Columns
  • Урок 76. 00:09:59
    Table Features
  • Урок 77. 00:14:10
    Tables as Named Ranges
  • Урок 78. 00:09:33
    Budget Project: Structured Data
  • Урок 79. 00:13:04
    Intro to Pivot Tables
  • Урок 80. 00:14:09
    Adding Layers to Pivot Tables
  • Урок 81. 00:10:58
    Pivot Table Formatting and Layout
  • Урок 82. 00:10:04
    Filtering Pivot Tables
  • Урок 83. 00:11:13
    Slicers
  • Урок 84. 00:09:45
    Pivot Table Math
  • Урок 85. 00:06:29
    Budget Project: Pivot Tables
  • Урок 86. 00:09:25
    Intro to Macros
  • Урок 87. 00:04:54
    Running Macros With Buttons
  • Урок 88. 00:09:45
    Editing Macros
  • Урок 89. 00:19:28
    Macros - A Case Study
  • Урок 90. 00:06:53
    Budget Project: Macros and VBA
  • Урок 91. 00:01:18
    Thank You!