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