2200:06:33,339 --> 00:06:36,302a different set of summary numbers.12300:06:36,302 --> 00:06:41,324So by the fifth time I actually went through this exercise, Jack12400:06:41,324 --> 00:06:45,974kind of got tired of preparing the numbers again and again,12500:06:45,974 --> 00:06:51,310he told me look, I can see that what you need is something else.12600:06:51,310 --> 00:06:55,260I will prepare for you a set of the detailed data of the sales12700:06:55,260 --> 00:06:59,849of these three years, and I will, using this detailed data,12800:06:59,849 --> 00:07:03,190you will be able to create any kind of12900:07:03,190 --> 00:07:05,580report of summaries that you want.13000:07:05,580 --> 00:07:08,930And you can show different aspects of the business.13100:07:08,930 --> 00:07:13,721And more than that, you will be able to give it to Lucy,13200:07:13,721 --> 00:07:18,093and explain to her how she can use the data to create13300:07:18,093 --> 00:07:20,403the summaries she wants.13400:07:20,403 --> 00:07:25,329The different comparisons on different axis, and so on,13500:07:25,329 --> 00:07:27,930based on this set of data.13600:07:27,930 --> 00:07:32,380And if this is gonna work out, we can produce new sets of data13700:07:32,380 --> 00:07:36,810with the same kind of detail going forward, and13800:07:36,810 --> 00:07:40,450this is the way we can monitor the performance going forward.13900:07:40,450 --> 00:07:44,710And so this is what we're going to do.14000:07:44,710 --> 00:07:47,530I'm waiting for the detailed data to come.14100:07:47,530 --> 00:07:50,150And just one more advise that Jack gave me,14200:07:50,150 --> 00:07:53,370as he's pretty knowledgeable about using Excel,14300:07:53,370 --> 00:07:58,970is that what you really need is to create pivot tables and14400:07:58,970 --> 00:08:02,220to use also Excel tables.14500:08:02,220 --> 00:08:04,150I knew a little bit about pivot tables,14600:08:04,150 --> 00:08:06,619Excel tables was something I didn't know about.14700:08:06,619 --> 00:08:08,862So, this is something I will have to look at.14800:08:08,862 --> 00:08:11,894And so I'm waiting for the detailed data, and14900:08:11,894 --> 00:08:15,780we'll see you in the next part, when we receive the data and15000:08:15,780 --> 00:08:19,157start exploring it using pivot tables and tables.
đang được dịch, vui lòng đợi..