Hey have anyone ever had an Excel mistake that ended up teaching you something valuable?

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

Related Posts

PwC India Anyone who recently joined pwc India bangalore data analytics team can you tell me how’s the WLB and growth here !?PwC India PwC

like

Hey folks , I am about to buy am office chair for my personal use , would love to get some recommendations from you'll
I wish to buy an ergonomic chair with my budget being upto 20 k
Do let me know any recommendations if you would have.

like

I am at salary negotiation phase with accenture hiring team. Somebody give me pro tips to fetch more CTC.

like

Sharing about a Patient Experience Consultant position salary range of $80k-95k depending on education and experience in Washington DC

like

Hi All,
Need some suggestions, I'm currently working with EY GDS as full stack developer as Senior Associate III with 7.3 years of experience.
Current CTC: 30.5L (24 fixed + 6.5 bonus)
I'm looking for change now which companies should I target to? who can give me atleast 45-50L with job security.

Any suggestions?

like

Anybody going for NHO on 14th Nov to ey gds kolkata office?

I am sex addict. I have to continue to remind myself that I am always in recovery. Had a major acting out a month ago, lost my fiancé and just taking one day at a time. That’s all I can do. Just remind myself so I don’t stop working

like

Hello,
There is an opening in my company for PMO.
Senior PMO position 5-10 experience.

Hi team ,
I resigned and my last working day was last day of month .
The company KPMG was suppose to deduct my joining bonus and other things in final settlement. Last working day was last day of month , which means i got full salary.
What they will do in final settlement? Will they ask me to pay separately? I have resigned and joined another organisation. Any one knows what will happen ?

like

Has anyone ever taken a break from advertising? What job did you do (in-house, something completely different)? Did you find it difficult to come back?

I’m really burned out and need a break.

like

Ibm or Capgemini Which one should i join for better job security?
Yoe 9
Skill java, microservice,aws.

Guys random question. Is their any role of participation in events like the one happened today in lcci IDS in the career progression? Everyone was singing dancing i felt like if I'm not participating it will affect my career progression in lilly.

funny

It feels like my pay and title are lower than my scope of duties. I manage Youtube channels and do all strategy, planning, talent management, rework content for socials, reporting, graphic design, + a bunch of other stuff. Do you think I should be something like Video Content Manager? A Strategist maybe? My company doesn't have career pathing & I think they'd be happy to keep giving me more work with the same pay. TIA!!

like

Someone just asked me to give a presentation at 7:30 am on Nov 1. I am saying no because I want to have fun on Halloween night with my neighbors. 👻🎃

likefunny

Accenture vs ZS for WLB?

I have technology backgorund but if ZS WLB is good might consider strategy too.

like

How do referrals work?
If I get a referral from someone and I apply, then can I still reach out to a recruiter on LinkedIn expressing interest in the role? And do I let them know that I already applied? I’m sure they get tons of messages so I want to write something that won’t be overlooked. Any advice is appreciated:)

helpful

Hi people. Can anyone from ac Kolkata let me know when is the announcement of appraisal and promotions?

helpful

What are some questions you always ask during your interview? I feel like I need to be asking more.

like

Are there actually tax cuts switching from home office in NYC to Hoboken?

like

Additional Posts in Excel Genius

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

Anyone know what these badges are?

Post Photo
likefunny

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

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

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

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Any book recommendations on excel modeling for real world business applications?

like

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

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

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

How do you fix microsoft excel cannot paste data error?

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

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