Scribd
Upload
60 views2 pages

Notes 1

Uploaded by

tejog58640
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
60 views2 pages

Notes 1

Uploaded by

tejog58640
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Power BI Download & Install

In case you have not installed Power BI, here is the link :-
[Link]

Click on download
Select x64
Click on download
install it

Raw Dataset

[Link]

Chatgpt

[Link]

Prompt 1

Create an excel formula to give values "Delay" if the difference of dates in cell c2 and b2 in days is
greater than 4 otherwise the value should be "On time"

Solution 1

=IF(C2-B2>4, "Delay", "On time")

Prompt 2

write an excel formula to extract name from email id in f2 with @ as a seperator

Solution 2

=LEFT(F2, FIND("@", F2) - 1)

Prompt 3

I have comma separated values in G2, Write 3 excel formula to extract the values as comma as a
separator in H2, I2 and J2
H2

=TRIM(LEFT(G2, FIND(",", G2)-1))

I2

=TRIM(MID(G2, FIND(",", G2)+1, FIND(",", G2, FIND(",", G2)+1)-FIND(",", G2)-1))

J2

=TRIM(RIGHT(G2, LEN(G2)-FIND(",", G2, FIND(",", G2)+1)))

Final Dataset

[Link]

You might also like