1

00:00:00,680 --> 00:00:01,830

Hello everybody.



2

00:00:01,830 --> 00:00:07,860

I'm Rishabh from your learning solutions and I'm going to talk about one specific area of Excel that



3

00:00:07,860 --> 00:00:13,980

is it's almost all the time you're going to work with will contain it in various forms and you would



4

00:00:13,980 --> 00:00:19,310

want to extract meaningful information from them clean them and use this for your presentation.



5

00:00:19,470 --> 00:00:25,140

So let's see what's set in the program if you want to be putto with the concept of beat what the different



6

00:00:25,170 --> 00:00:26,820

functions working in Excel.



7

00:00:26,820 --> 00:00:28,110

What are the do's and don'ts.



8

00:00:28,170 --> 00:00:31,830

You must understand how is access storing the date.



9

00:00:32,010 --> 00:00:38,830

In short every valid deed deed which you understood by Excel is stored as numbers.



10

00:00:38,910 --> 00:00:45,110

The moment you change the format to General you will notice it converts to number and we will explain



11

00:00:45,210 --> 00:00:46,620

what does that number mean.



12

00:00:47,510 --> 00:00:52,940

Once we understand the basic concepts of data we move on to the basic utilities that are available in



13

00:00:52,940 --> 00:00:53,590

Excel.



14

00:00:53,600 --> 00:00:58,750

For example when you drag a particular date there are various options like fill months failures filled



15

00:00:58,750 --> 00:00:59,790

days etc..



16

00:00:59,840 --> 00:01:01,210

What does those mean.



17

00:01:01,220 --> 00:01:05,070

Next we'll see what the different basic functions do.



18

00:01:05,150 --> 00:01:12,200

For example Day to your read and read could the practical utility lie all along the way will also come



19

00:01:12,200 --> 00:01:18,380

across some fascinating formulas which will allow you to get maximum out of available dates.



20

00:01:18,410 --> 00:01:24,650

So for example the formula text will help you extract which it is which month and which yard.



21

00:01:24,980 --> 00:01:31,190

You must also be aware of the shortcut keys which allow you to feed in the dead and dying faster along



22

00:01:31,190 --> 00:01:32,270

with the functions today.



23

00:01:32,310 --> 00:01:38,120

Now we'll also talk about two very important functions called Editta and you must and we'll see how



24

00:01:38,120 --> 00:01:44,330

do they help us perform this kind of calculation whereby you might be asked to calculate in the current



25

00:01:44,330 --> 00:01:44,750

month.



26

00:01:44,870 --> 00:01:49,870

First of next month or first offcut and month in finance and accounting.



27

00:01:49,880 --> 00:01:54,790

Quite a few times you need to calculate 30 days from now or one month from now.



28

00:01:54,830 --> 00:01:56,860

We'll see the difference with the rich.



29

00:01:56,860 --> 00:02:02,000

Both these questions must be approached at times if you wish to calculate five year bonus.



30

00:02:02,000 --> 00:02:03,670

When is the bonus getting due.



31

00:02:03,680 --> 00:02:08,360

After five years of completion of employment highly funded.



32

00:02:08,530 --> 00:02:12,150

When the retirement age of 60 How do you calculate that retirement age.



33

00:02:12,220 --> 00:02:16,330

Next we've also devoted some time on how to clean the deats.



34

00:02:16,330 --> 00:02:23,260

Sometimes the date adn a certain format which are not accepted by Excel not clearly read by Excel and



35

00:02:23,290 --> 00:02:30,460

will see how using simple tricks can you clean one unstructured beat to find final output which is easily



36

00:02:30,460 --> 00:02:33,250

readable by Except if you you're into project management.



37

00:02:33,250 --> 00:02:40,080

You must also make note of some important functions which will help you calculate dead ladies.



38

00:02:40,180 --> 00:02:44,190

The number of business days between two sets of dates and so on.



39

00:02:44,290 --> 00:02:50,500

For example you are given a project stardate and it must be completed in 5 business days.



40

00:02:50,500 --> 00:02:53,340

Now how do you calculate the end date.



41

00:02:53,370 --> 00:02:59,200

At times you might consider Saturday Sunday to be the VIGEN you must exclude those in certain countries.



42

00:02:59,260 --> 00:03:03,130

Friday-Saturday are holidays so those must be excluded.



43

00:03:03,130 --> 00:03:04,560

How do you tackle that.



44

00:03:04,630 --> 00:03:11,650

If you are using dates in a pool table will also show you this transition from a simple list of dates.



45

00:03:11,860 --> 00:03:17,140

You get to make a report like this which bifurcates the report in different yards and different ones.



46

00:03:17,320 --> 00:03:22,660

And this shows you the bifurcation of people joining across different months and years over a period



47

00:03:22,660 --> 00:03:23,870

of time.



48

00:03:23,890 --> 00:03:29,130

I hope by now you would have got a brief enough idea about how we are going to go about in this program



49

00:03:29,140 --> 00:03:32,860

to what depth we are going to get inside the dates of Excel.



50

00:03:32,980 --> 00:03:37,770

If you want to learn all of these join in today and I'll see you then in the program.