Ways in Which We Can Use ChatGPT in Excel!

Guides April 18, 2023

Generating Random Data

[{"selector":"#anim-bf48ef3e-220f-43cf-9819-4fc4bb540b0d","keyframes":{"opacity":[0,1]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-693a2cd0-de56-4359-ac76-c0f6cf2ea5cb","keyframes":{"transform":["translate3d(-112.80487%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e1861141-c256-423c-b84d-c3950ce7c8c4","keyframes":{"opacity":[0,1]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a09586e5-bc51-4b42-9596-9ae24e5fd597","keyframes":{"transform":["translate3d(119.12751%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-279814e2-84ea-4e68-bc3e-7418bbacf1b0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(24.994836910418204%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] ChatGPT can help you make numbers, words, and even whole lines that are completely random.

Data Cleaning

[{"selector":"#anim-5882931f-83c6-4114-ab9e-3232be4e079c","keyframes":{"opacity":[0,1]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8bec3ff6-b337-4035-b293-5d5821df7fc3","keyframes":{"transform":["translate3d(-112.80487%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7c46910d-6bb3-4ffb-bef8-a773cf6b3adb","keyframes":{"opacity":[0,1]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-234f102f-6c13-4275-9901-dbd1ff52de9e","keyframes":{"transform":["translate3d(119.12751%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-73fccc56-df5a-4991-a82f-c36000c9d8d0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(24.994836910418204%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] ChatGPT can help Excel users clean up their data.

Data Analysis

[{"selector":"#anim-56c721d0-6a2f-4af2-a209-5aa5921a7512 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(24.994836910418204%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-d7fd1c7f-5f2b-441f-8581-3c9f808f655a","keyframes":{"opacity":[0,1]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e062cbe1-09a7-4d8e-8e66-f778f73f24b6","keyframes":{"transform":["translate3d(-112.80487%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fac02723-d748-4556-a34a-cc421f1961d5","keyframes":{"opacity":[0,1]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4a784e39-3f42-42ac-98ac-b80d4d1f8fc0","keyframes":{"transform":["translate3d(113.23076%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] ChatGPT can help people look at data by showing them pictures and analysis of the data’s statistical patterns.

Automation

[{"selector":"#anim-e0205267-1134-4cec-b9f0-1d85bdc22964 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-ad8d72fe-4375-4f25-bf52-231eb85ba29d","keyframes":{"opacity":[0,1]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-58a97423-ad29-4ccd-a786-3642da01e08b","keyframes":{"transform":["translate3d(-112.80487%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-febf8385-c2d8-4cee-9122-9993eed7342f","keyframes":{"opacity":[0,1]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3f93c588-4a41-465c-bf03-49e0c1a185cc","keyframes":{"transform":["translate3d(113.23076%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1200,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] With ChatGPT, you can set up Excel tasks to run on their own.

Swipe up for more information

[{"selector":"#anim-cdca7c1d-9dd9-4aca-9d9a-f56928f70b1b [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-3ed18b75-a828-4101-8347-a59afcf9ac50","keyframes":{"opacity":[0,1]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e8a4b8a9-4710-4e72-8aac-ddca195c194a","keyframes":{"transform":["translate3d(-109.56522%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":1000,"duration":1200,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Swipe up