Me: Simple math. Excel: Let's go back in time to when no one asked for this.

Post Photo
funnylike
Posting as :
works at
You are currently posting as works at

It is just one of those things that adds character to it! Honestly though once I really got comfortable using Excel I don’t have as many oddball problems anymore. Not to say never, sometimes it really does like to still make some creative choices when using it. Ctrl Z is my best friend in it.

like

This kind of thing drives me insane!! I cannot tell you how many times I have had it out with Excel because it starts doing things like this and I am like no no, I didn't want that as a date. If I wanted that as a date I would have typed it that way!

Related Posts

Hello fishes,
I have 5 years of experience. I have received offer letter for IN3 role (java developer) with 22LPA(fixed)+variable(4)+joining bonus(2)..Is this good package or are they lowballing me..?? Should i try for counter offer… will they increment in case of counter offer??

like

When asked,do you disclose your current rate in an interview? Are you required to provide evidence? What is the norm? Thanks!!!

like

Hi Fishes!
I just got an offer from Quantiphi Analytics, Bangalore
Role: Data Engineer
Salary Offered: 16 LPA (14 fixed)
Current: 5.7
YOE: 3
Could you let me know if i should join this company? Considering its a startup and the offer is more than I expected

like

Anyone considered renting furniture vs. buying furniture for their apt?

like

Could you seriously date someone who isn't on the same financial level as you?

like

I am looking forward to working as an Operations Associate at ShareChat . Please let me know if there are any opportunities.

like

I am currently a VP in due diligence in EY. Looking for opportunities in Dubai or Singapore. Request if anyone can help.

like

What are the career prospects for FSO Audit? FP&A a possibility?

like

Hi guys, I am looking for a change after 11 years serving in the current organization. I have total 13 yrs exp. with only 13 LPA as I am in the same organization and didn't switch. With EY in the HR discussion they stated 19.4 LPA fixed, but I requested for 20 LPA fixed (though the difference is not much). The HR stated they may need to take approvals and the call ended. Do you know whether they will come back? How many days usually it takes HR to come back? It's the 3rd day almost.

like

A report opened to me that they are having money problems and wants a raise. We are remote and they moved to a high CoL city. We gave an increase to help with retention 6mths ago. In my response, I helped mentor with best practices on how to ask for a raise professionally since I need to make a case to my Head on finances. But their performance has been avg and not seemingly worthy of another large raise within a short period of time. But how do I respond when they talk about personal finances?

like

Anyone else having one of those days where you just can’t seem to do anything right? I’m dropping balls left and right here

like

I sat down to check my email before I showered this morning, had an “urgent please handle ASAP” message waiting for me, and guess what I still haven’t done today??

likefunnyhelpful

Where did you get your leather briefcase/satchel? What are features you will be looking for in your next one?

likefunny

Starting IVF in a month - any guidance in prep for it, things that may help increase success for egg retrieval or anything like that? I started taking supplements advised by my doctor, but curious to hear of anything else! Thank you SO much!

like

How much do you pay per lb for wash and fold?

likehelpful

Anyone know how to get a position as an HRBP without HRPB experience? All positions I've looked at want previous experience. Would over 5 years of HR experience and a PHR suffice, or what skills should be added to that?

like

Looking to sublease a 2/2 at the Santal in SW austin overlooking hill country views July-November 2k/month

like

Hey all! Need a couple book recs for an upcoming beach trip.

Looking for a great non-fiction, relating to travel or world history (not just one moment in time). Could also be about the marketing world or memoirs of a business leader kinda thing.

Fiction wise I also like fantasy, paranormal, and romance. Some fave book series are the Black Gryphon from Mercedes Lackey, Game of Thrones, and From Jamaica Lane series. Similar books?

like

Hey beautiful people,
I’m 27Y and work in tech. Unfortunately my carpal tunnel is getting worst slowly. I’m worry that I still have like 45 years more to be retired and can’t stop working because I have a f* mortgage to pay 😭 I have a super ergonomic workstation, but I know my hand needs a long rest, and I can’t do it… Does anyone relate? What do you recommend?

like

Have been hunting desperately for childcare bc spouse and I are both FT lawyers trying to handle 4 immunocompromised elementary age kids at home but have been striking out. Have even been considering having one of us take a leave, going part time (career suicide/knock us off partner track) or quitting. Just found someone highly recommended, experienced, patient, etc. Interview went super well but candidate disclosed they are in recovery for substance abuse, last relapse 2 yrs ago. DUI. Thoughts?

like

Additional Posts in Excel Genius

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

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

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

Would anyone be willing to teach me vlookup?

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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

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?

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

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

Still don't have xlookup. #fomo

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

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

Post Photo
likehelpful

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

Anyone know what these badges are?

Post Photo
likefunny

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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