MS-Excel -trick to format the data
Most of our day to day work we need to use MS-Excel to summarize or calculate some business data. We may have to bucket these data into various format. For e.g I need to analyze last year sales data month on month but the date should be in this particular format YYYY-MM-DD and the format of the same in spread sheet is in this format YYYYMMDD.
We can change the format by two methods-
1. add custom format by right clicking and select custom option
give the required format here as showed in Fig 2 which enables to use the same format easily in other part of the excel as well.
2. second option is very easy like any other formula in excel
We can change the format by two methods-
1. add custom format by right clicking and select custom option
Fig 1 |
give the required format here as showed in Fig 2 which enables to use the same format easily in other part of the excel as well.
Fig 2 |
2. second option is very easy like any other formula in excel
Fig 3 |
I like the information. Good work and keep update more.
ReplyDeleteEthical Hacking course in Chennai
Ethical Hacking Training Institute in Chennai
Hacking course in Chennai
ccna Training in Chennai
Salesforce course in Chennai
PHP Training in Chennai
Tally course in Chennai
Ethical Hacking course in OMR
Ethical Hacking course in Anna Nagar
Ethical Hacking course in Vadapalani
Innovative blog...!!! This is the best post and I got more ideas from your post. Keep continuous....
ReplyDeleteJMeter Training in Chennai
JMeter Training
Power BI Training in Chennai
Job Openings in Chennai
Linux Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
JMeter Training in Velachery
JMeter Training in Vadapalani