Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай 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
• Урок 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
• Урок 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!