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

Can also confirm that ChatGPT is actually really great with Excel help, and also some light coding tasks depending on what you want to do. Sometimes there is so much information to sift through when you are trying to figure out the best way, being able to use that saves me time.. Usually anyways!

like

As a novice to ChatGPT, How do you actually tell it your questions? No laughs for this old guy!😎

like

I used copilot to write vba scripts. It is amazing.

like

No laughs it’s a great question and takes practice to learn prompting

like

Is this the standard version or are you paying an additional fee?

I've found that the paid Chat GPT works far better than the free version so that's what I'd recommend. i haven't used it a ton for Excel but I'm interested to try it out!

like

Related Posts

I can't wait for it to cool off so I can try my hand at making furniture. Too hot to work in my shop right now. Planning to make this out of wood.

Post Photo
like

Can we change project in Capgemini?

What is your typical class size for your shop class? Do you have a maximum?

like

Anyone from Tax coming to office today to meet Joan ?

like

Hi all! In which order do you recommend studying BEC chapters ? Which ones are heavily tested compared to others ? (For example in AUD A3-A4 were tested for sims and I’ve studied A1-A5-A6)

like

If you had to choose between Cyberpunk, Elden Ring, and Dying Light 2, which would you pick and why?

like

I am moving to Hyderabad on 4th Nov. Can anyone tell me if they have a vacant room in an already occupied flat near office. I am preferably looking for something within walking distance. Please help 🙏

like

Any Immigration lawyers here?

like

Where are the good point promotions? Spg (soon), Hyatt recently just ended and those were lame. Anyone know good ones going on or starting relatively soon? Interested in rental and air promotions, too.

like

Hi fish,
After how many days of Capgemini L2 round can i expect hr call. Thanks in advance

BONUS. What’s amount bonus do you get, and how often? Including bonus structure (ex for meeting billable hours), firm/boss randomly bonuses you, Christmas bonus, etc)

like

Recently got an offer from KPMG. But the offer letter is in their portal with no KPMG letterhead or signatures. Next thing is there is no joining details like reporting office or whom should I report to on joining date. I have tried to contact HR via mail/ call. No response. What to do? Has anyone joined KPMG recently? How do they communicate the joining details? Please tell me

like

Any openings for a CA , with 4 years of experience in CFO advisory services, current ctc is 10 lpa, looking for a switch to KGS similar profile or some other department ( Corporate Finance, FPnA etc), any leads would be appreciated

like

Hey Fishes 🐟,

Where can I get study material for SAP IS-U ? I visited lot of sites but couldn't find detailed explanation for each concept.

like

If you could change anything to increase minority representation in marketing, what would you change? I think I'd want at least 2-3 minority employees in creative leadership positions to make sure things like colorism in ads less likely to pass the final edit.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anyone from PA Consulting know the ranges for Consultant Analyst and what a typical offer package would look like?

like

Salary for vp, group director with 13+ years experience?

What is the salary range for a practice management consultant?

like

Hi what is an acceptable salary range for an associate director in biotech( +10 y experience)

like

Additional Posts in Excel Genius

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

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

likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How do I compare two sheets to make sure they are identical?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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

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!

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.

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

Post Photo
likehelpful

Still don't have xlookup. #fomo

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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 you fix microsoft excel cannot paste data error?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
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