Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,730 --> 00:00:08,910
In this video we're going to learn how to use data and time formulas in Excel you're going to build
2
00:00:08,910 --> 00:00:16,140
up on the case study we used in the math formula section we'll use some common data and time functions
3
00:00:16,710 --> 00:00:22,190
to compare performance of become store across the four quarters.
4
00:00:22,230 --> 00:00:29,620
The case study workbook has all the information we calculated in the previous case study.
5
00:00:29,640 --> 00:00:40,070
In addition there's a new section starting in row 26 in this new section.
6
00:00:40,190 --> 00:00:47,840
We will calculate the number of working days in each quarter and then we'll calculate sales per day
7
00:00:48,020 --> 00:00:56,880
for each quarter so we can compare the performance of each quarter the workbook also the new sheet list
8
00:00:56,880 --> 00:01:07,870
of holidays this sheet has number of holidays in each quarter for each quarter it lists out that there
9
00:01:09,150 --> 00:01:17,310
which are marked a holiday so the store has closed on these days and therefore when calculating the
10
00:01:17,310 --> 00:01:21,360
number of working days will leave all these holidays from the calculation.
1283
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.