Since it's been mentioned here before, how do I effectively use AI to do Excel stuff for me?

like
Posting as :
works at
You are currently posting as works at

Have you tried co-pilot? You can basically ask it to generate reports, tables, insights, and trends with a single prompt.

likehelpful

Ai isn’t very good at math yet so it can’t do it for you.

You can use it to help you write code or recommend a formula or troubleshoot

like

It can be useful when you need help writing a formula. Just describe the situation like you would when you make a post on here asking for help, but enter it into ChatGPT or copilot. Sometimes it does very well, other times it just gives you something to start from.

helpful

Excel is the OG of AI.

like

You wait for AI to exist

It isn't - if it was, I'd have sold everything and bought Ms stocks already. LLM is not AI

“Stuff” is an example of the problem, AI is not yet to the point to deciphering generalities in to complex solutions. It can help w/ general formulas and vba but it is not going to create miracles for you. The best skill I’ve seen some use for Excel is working with AI to see if it can help answer a scoped formula or code question but the user still has to customize to their purpose. Learn terms and the types of questions to input without relying on it to "fix" the problem.

Related Posts

BUMP: what 3-4 schools did people apply to R1?

like

Do you feel that in SEO there are too many ways of conducting the same tasks. I have had a string of managers within the past year, it’s starting to get very annoying as each person says method A is wrong and B is right, another manager would have the complete opposite view. Have you had similar experiences when this practice and adjustment begins to interfere with client deliverables.

like

Hello! I’m a clinical healthcare worker and am currently working on a master’s in finance to pivot to healthcare consulting.

I’m trying to get an internship next summer (I have the time off work) but am having difficulty finding internships for non-MBA master’s degree candidates. (I have a clinical MA and doctorate & it’s been an auto-reject from analyst internships.)

Would anyone be willing to connect for internships or work for companies that love non-traditional candidates? Thank you

like

Hi fishes, 26 of nov i give the interview after that 28 of nov i got a mail to upload document on ibegin and same day my doc is verified .

But in 29 of nov show two status in ibegin current and previous status in current it show resume is shotlisted and previous it show evaluation in progress.what it mean?

like

Anyone heading back into the EY office next week?

Hello Everyone,
I recently shifted to Boston with my girlfriend. Hoping to connect and meet new peeps. We basically are fresh out from our grad school and started working in analytics domain. Love to have few people to chill and experience new city. DM or comment to connect

What's currently in your refrigerator? I have a bottle of milk that apparently expired a month ago, stale bread and almond butter that could pass as cement. #adulting

like

Self-employed freelance logo designer, anyone know of any jobs?

like

Can someone please refer me in Qualcomm as embedded software engineer, I have below mentioned skills : C,C++,RTOS(FreeRTOS),I2C,SPI,UART

like

Anyone interested in working for Sogeti/Capgemini in technology and would like a referral, please let me know. We have open roles for software developers, cloud architects and data engineers

likefunny

Does anyone knows how to contact Footprint Coalition found.??? I am interested in work with them, but there is only a contact by mail if You want to make an economic collaboration... Please, anyone?? Also, I am available for work in LA or remotely...

like

Is Disney a buy @ 112? I know the upside is if/when the parks can reopen it should go up. Also Disney+ is continuing to beat expectations. Just worries that the parks will@be delayed even more which will hurt them

likehelpful

FAR on Saturday - Absolutely terrified. I feel like there’s so much I don’t know how to do and idk how to handle not knowing everything.

Any advice on how to tastefully tell your manager that you no longer want to be a charge nurse anymore? For us being in charge is having full assignment 3p-7p & being responsible for assigning pts , communicating w/ supervisor about various issues, making the assignment for next shift, and a mini report about each pt for the next charge. On the weekends, same responsibilities but 7a-7p. We don't get any additional pay for being in charge and I'm sick of the added responsibility and stress of it.

like

Hi
I have one year experience in AWS python
development.now i Switched to nokia here i am working in 5g technology automation testing.

I am under training now, will i have a good career in Nokia or should I switch to development? please help

Hi All!
Anyone from the insurance industry based in Jakarta, Indonesia? Would be happy to connect/network over coffee

like

Can anyone provide TC for manager positions at Liberty or Progressive? Are they offering remote for these jobs?

likesmart

What’s a good starting salary for a newer attorney? I’ve never worked anywhere but in the public sector (even before becoming an attorney). I currently clerk for a judge and now am up to $44k as of July 1. I’m in KY. I’ve recently had a couple attorneys reach out to me about joining their practice. I’m not ready to leave my current role but I have no idea what to consider as a reasonable salary. I’ve been licensed a year and this is my first law-related job so I’m a complete newbie.

like

Is FDD more enjoyable work-wise than Accounting Advisory Services (CMASS, FAAS, etc.)?

like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How do you fix microsoft excel cannot paste data error?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What are your top Excel ninja tricks? Ones that few people know...

like

Would anyone be willing to teach me vlookup?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

How long did it take you to become good at excel? Like fast?

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Anyone know what these badges are?

Post Photo
likefunny

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal