filmov
tv
Master the art of big data processing and analysis in Excel!
Показать описание
Master the art of data processing and analysis in Excel with this real-life dataset from a digital hydrological station! Join us as we dive into this massive dataset with around 1 million rows, collected every 15 minutes for five years. Learn how to manipulate and analyze data using Excel's powerful tools and techniques. Don't miss out on this opportunity to level up your data skills - subscribe now!
00:00 Introduction to Data
01:07 Loading the Data
06:35 Getting Daily Subtotal
11:56 Getting Monthly Subtotal
12:08 How to Separate Text From Date/Number
13:18 How to change Date format from m/d/yyyy to m/yyyy
17:54 Getting Yearly Subtotal
00:00 Introduction to Data
01:07 Loading the Data
06:35 Getting Daily Subtotal
11:56 Getting Monthly Subtotal
12:08 How to Separate Text From Date/Number
13:18 How to change Date format from m/d/yyyy to m/yyyy
17:54 Getting Yearly Subtotal
0:05:25
0:00:43
0:00:16
0:03:35
0:52:40
0:19:25
0:57:22
0:05:15
0:08:23
0:27:54
0:08:20
0:16:34
0:17:15
0:26:07
0:00:33
0:00:27
0:13:05
0:00:45
0:00:25
0:13:49
0:00:54
0:01:05
0:00:32
0:03:01