Hello everybody.
I'm Rishabh from your learning solutions and I'm going to talk about one specific area of Excel that
is it's almost all the time you're going to work with will contain it in various forms and you would
want to extract meaningful information from them clean them and use this for your presentation.
So let's see what's set in the program if you want to be putto with the concept of beat what the different
functions working in Excel.
What are the do's and don'ts.
You must understand how is access storing the date.
In short every valid deed deed which you understood by Excel is stored as numbers.
The moment you change the format to General you will notice it converts to number and we will explain
what does that number mean.
Once we understand the basic concepts of data we move on to the basic utilities that are available in
Excel.
For example when you drag a particular date there are various options like fill months failures filled
days etc..
What does those mean.
Next we'll see what the different basic functions do.
For example Day to your read and read could the practical utility lie all along the way will also come
across some fascinating formulas which will allow you to get maximum out of available dates.
So for example the formula text will help you extract which it is which month and which yard.
You must also be aware of the shortcut keys which allow you to feed in the dead and dying faster along
with the functions today.
Now we'll also talk about two very important functions called Editta and you must and we'll see how
do they help us perform this kind of calculation whereby you might be asked to calculate in the current
month.
First of next month or first offcut and month in finance and accounting.
Quite a few times you need to calculate 30 days from now or one month from now.
We'll see the difference with the rich.
Both these questions must be approached at times if you wish to calculate five year bonus.
When is the bonus getting due.
After five years of completion of employment highly funded.
When the retirement age of 60 How do you calculate that retirement age.
Next we've also devoted some time on how to clean the deats.
Sometimes the date adn a certain format which are not accepted by Excel not clearly read by Excel and
will see how using simple tricks can you clean one unstructured beat to find final output which is easily
readable by Except if you you're into project management.
You must also make note of some important functions which will help you calculate dead ladies.
The number of business days between two sets of dates and so on.
For example you are given a project stardate and it must be completed in 5 business days.
Now how do you calculate the end date.
At times you might consider Saturday Sunday to be the VIGEN you must exclude those in certain countries.
Friday-Saturday are holidays so those must be excluded.
How do you tackle that.
If you are using dates in a pool table will also show you this transition from a simple list of dates.
You get to make a report like this which bifurcates the report in different yards and different ones.
And this shows you the bifurcation of people joining across different months and years over a period
of time.
I hope by now you would have got a brief enough idea about how we are going to go about in this program
to what depth we are going to get inside the dates of Excel.
If you want to learn all of these join in today and I'll see you then in the program.