MS-Excel -trick to format the data

By -
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


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

Comments

  1. anushyaJune 24, 2019 at 11:04 PM

    the explanation of this topic you posted is very good. please upgrade the new technologies about this topic.
    Selenium Training in Bangalore
    Best Selenium Training Institute in Bangalore
    Data Analytics Courses in Bangalore
    Digital Marketing Courses in Bangalore
    Python Training in Bangalore
    Big Data Training in Bangalore
    Hacking Course in Bangalore
    Selenium Course in Bangalore

    ReplyDelete
  2. velrajJune 25, 2019 at 5:58 AM

    I like the information. Good work and keep update more.
    Ethical 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

    ReplyDelete
  3. sultanaJune 26, 2019 at 5:34 AM

    I would definitely thank the admin of this blog for sharing this information with us. Waiting for more updates from this blog admin.
    Blue Prism Training in Chennai
    Blue Prism Training
    Azure Training in Chennai
    Cloud Computing Training in Chennai
    Automation Anywhere Training in Chennai
    Blue Prism Training in Anna Nagar
    Blue Prism Training in T Nagar
    Blue Prism Training in OMR
    Blue Prism Training in Porur

    ReplyDelete
  4. AparnaJune 28, 2019 at 3:52 AM

    Innovative blog...!!! This is the best post and I got more ideas from your post. Keep continuous....
    JMeter 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

    ReplyDelete
  5. RaviFebruary 19, 2020 at 1:47 AM


    This content of information has
    helped me a lot. It is very well explained and easy to understand.
    seo training classes
    seo training course
    seo training institute in chennai
    seo training institutes
    seo courses in chennai
    seo institutes in chennai
    seo classes in chennai
    seo training center in chennai

    ReplyDelete
  6. RaviFebruary 19, 2020 at 1:48 AM


    You write this post very carefully I think, which is easily understandable to me. Not only this, but another post is also good. As a newbie, this info is really helpful for me. Thanks to you.
    Tally ERP 9 Training
    tally classes
    Tally Training institute in Chennai
    Tally course in Chennai

    ReplyDelete
  7. UnknownJuly 11, 2021 at 9:19 PM

    Extremely decent review. I totally appreciate this site. Much obliged!

    best interiors

    ReplyDelete

Post a Comment

Popular posts from this blog

Microsoft BI Implementation - Cube back up and restore using XMLA command

By -
Image
Current BI implementation require to deploy the cube in multiple location to make it available  locally in each location to improve the performance. Cube development happening in one location say X but since the company is having presence in around the world and so business users sits in different locations X, Y and Z. Internet connectivity between X, Y and Z are not good and accessing the cube deployed in X from Y and Z is very slow and it impact the end user productivity. To overcome this issue, cube has to be deployed in Y and Z locally and upload the connection in their local SharePoint as mentioned below.  Fig 1 Now let see how we can automate all these process from taking back up of the cube database to restore it in each location. Follow the below mentioned steps to automate back up and restore of cube database. - select the back up option by right click on the cube database to be backed up and generate the XMLA script after providing necessary proper
Read more

Databricks - incorrect header check

By -
This post I would like to show you how we can fix the problem of " Incorrect header check " received while fetching the data from hive table. Actual message " SparkException: Job aborted due to stage failure: Task 0 in stage 63.0 failed 4 times, most recent failure: Lost task 0.3 in stage 63.0 (TID 3506, 10.1.1.7, executor 28): java.io.IOException: incorrect header check.   at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.inflateBytesDirect(Native Method)     at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.decompress(ZlibDecompressor.java:221)     at org.apache.hadoop.io.compress.DecompressorStream.decompress(DecompressorStream.java:82)     at org.apache.hadoop.io.compress.DecompressorStream.read(DecompressorStream.java:76)     at java.io.InputStream.read(InputStream.java:101) " To better understand the scenario, let me explain how the data got loaded in the hive table. we are storing the data from source systems to RAW layer. H
Read more