MS Excel Data Tab क्या हैं?

[{"selector":"#anim-9719252b-b420-4b1d-af5a-a4625b017af7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-05e6bd99-3151-4a9d-a33f-93cba5a7a89b","keyframes":{"transform":["translate3d(125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-150c64ba-7fe6-4409-bc51-6aca4fe16303","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d2d554ec-d00a-4ef5-a6fd-e22afd59f1e1","keyframes":{"transform":["translate3d(-119.66102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

MS Excel – Data Tab Sections.

[{"selector":"#anim-1ffea565-c55f-41fb-9b22-7e0883e80cc7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5ea9fa70-8bda-4e08-9753-03970c3a3565","keyframes":{"transform":["translate3d(-114.95328%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6178dc70-4c45-48c1-a809-49a5f54105cc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8b53cacf-1d77-4699-8dad-5ba615ab1af7","keyframes":{"transform":["translate3d(118.98305%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

1- Get External Data

[{"selector":"#anim-dbe8325c-104a-4195-a818-78b36c8566d9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bbc87d88-93ff-437a-bda3-d68eddeeebea","keyframes":{"transform":["translate3d(-125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ef749557-4616-4740-8413-a4abf1e5ba56","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f6f20ef9-b30a-498b-9fd7-5d0b0d3f9ce1","keyframes":{"transform":["translate3d(120.33899%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

2 - Connection

[{"selector":"#anim-92033a61-320c-4e5b-884b-cf3a7cd9bfce","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4a1c987c-cdb3-4a17-b13f-631d89ea834e","keyframes":{"transform":["translate3d(-124.91103%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-93f66aee-7114-45d3-a9fb-d8fcdd9bb294","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d126d7d0-fd8b-4e34-a075-a60e577ab70b","keyframes":{"transform":["translate3d(115.93221%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

3 - Sort & Filter

[{"selector":"#anim-353474f3-a398-419f-8c18-90828f3916d3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-915ce5ae-d34e-4185-9701-6122f2e279f7","keyframes":{"transform":["translate3d(-125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3b2fdb69-c6af-4558-8d8f-2908b57f6762","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f6e79190-4ed7-46f7-802c-5e88f9171d84","keyframes":{"transform":["translate3d(125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

4 - Data Tool

[{"selector":"#anim-18f63997-1599-4fab-8fd2-59ad6ae753cf","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efd3acf7-bd71-4264-88c0-b65c43efee20","keyframes":{"transform":["translate3d(-125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-50afd79c-4c4a-4c2d-a73f-d305ab7e7192","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-19a934ee-4b23-4c48-8895-f4ecc42f6e13","keyframes":{"transform":["translate3d(125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

5 - Outline

[{"selector":"#anim-197b66d4-4035-4f04-b923-a6ecabc4dde0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-63de284a-db5f-49fe-bce6-d6acf99ac6ef","keyframes":{"transform":["translate3d(-125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1d52986c-84a2-446c-9a84-2f29daa3cfa4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a3af5ec7-9816-45c2-91d8-b97c2d546c41","keyframes":{"transform":["translate3d(125.27472%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

ओर अधिक जानने के लिए नीचे दी गई लिंक पर क्लिक करें

[{"selector":"#anim-61b4f86d-cfd3-44a3-ace8-5e653afb6ada","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ebc7a109-fcee-4c0b-a6ba-2a2f559d5706","keyframes":{"transform":["translate3d(-125.64102%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7805234a-98db-4a8c-afc9-0c87df830389","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d1ae912a-3498-4624-a353-7243ab2fa777","keyframes":{"transform":["translate3d(125.27472%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

MS Excel Data Tab क्या हैं?

Data Tab का Use करना सीखें

MS Excel Data Tab क्या हैं?

MS Excel Data Tab का मुख्य उपयोग external sources से data को import करने और उसे अपनी आवश्यकता अनुसार shape देने के लिए किया जाता है।

MS Excel – Data Tab Sections.

MS Excel Data Tab में हमें 5 section देखने को मिलते है – 1-Get External Data. 2-Connections. 3-Sort & Filter. 4-Data Tools. 5-Outline.

1- Get External Data

इसमें हमें 5 option देखने को मिलते है – -From Access -From Web -From Text -From Other Source -Existing Connection

2 - Connection

MS Excel Data Tab के इस section मै हमें 4 option देखने को मिलते है – -Refresh All -Connection -Propertie -Edit Link

3 - Sort & Filter

इसमें हमें 7 option देखने को मिलते है – -Sort A to Z -Sort Z to A -Sort -Filter -Clear -Reapply -Advanced

4 - Data Tool

इसमें हमें 7 option देखने को मिलते है – -Text to Column -Flash Fill\ -Remove Duplicate -Data Validation -Consolidate -What-If Analysi -Relationship

5 - Outline

MS Excel Data Tab के इस section मै हमें 5 option देखने को मिलते है – -Group -Ungroup -Subtotal -Show Detail -Hide Detail

ओर अधिक जानने के लिए नीचे दी गई लिंक पर क्लिक करें

Click Here

Next Story >>