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

If someone sent me an excel model as a pdf, I would punch them in the throat

likesmart

These are really good tips and good to know because I have one person I share Excel files with that literally always has issues opening it. She swears she can't open excel documents on her computer but she had done it before so it literally makes no sense to me.

Related Posts

My friend needs a referral for ETL( SQL, informtica). Can anyone please provide referral?

like

Hi please advise

can join client organisation; will their be any conflicts with current company?

like

How do you manage a long distance relationship? I got engaged 3 months ago and my fiancé and I live in different cities. I just can’t stop thinking about her and feel horrible there on.

like

How to get Id card.I am being boarded virtually!

like

What do Deloitte GPS PPMDs make?

like

Any idea why Sap labs will provide delayed joining? After a month time frame.

like

Hello,
Anybody who can guide me into getting a job into Salesforce field in Toronto, Canada

like

How many days before onboarding mail came for BOA?

like

Does anyone here have a Tesla? Should I do it???...

like

Recently sold my car on carvana. I had initially bought it using a loan from DCU. Now that carvana has paid me the balance after paying of the loan, i still see on the dcu app that I owe money to dcu. People that can relate, can you take me through next steps?

like

Recently was informed that my salary will be increasing and was asked to sign a Confidentiality and Assignment of Inventions Agreement.

Anyone experience this before? Is it pretty typical?

like

Can we stay long term in nagarro for about 3-4 years thinking about it any suggestions

like

How much do professional, high-earning (300k+) people put down as down payment for their first home / condo in Manhattan? 20% seems pretty high given the median prices, but looks like thats standard

like

Is it just me or do people drive like maniacs in the Denver metro? Constant tailgating no matter what the speed limit or if there’s traffic or construction. I’m appalled by how dangerous some people here drive. Relax, getting there a few seconds faster isn’t worth anyone’s life. Aren’t y’all supposed to be too high to be driving like this anyway?

like

What products are people buying now?

Do you have a "Design System Council" or "Design Council" in your team? What kind of topics do you talk about? Just learned we have that and unclear what it's about.

like

Does FDD vary by firm or do they pretty much compete and do the same work? Like which one has the best practice in NYC from the big4?

like

I have a partner who routinely ignores emails or responds to them several weeks later. He has to approve every single document sent to the client or the court, which means you have a physically go to his office to ask him to review something. Half of the time you go to meet with him in person, he’s either on a call or otherwise busy. I find that this basically creates more work and makes meeting deadlines extremely difficult. Is this normal?

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

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?

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

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

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

Would anyone be willing to teach me vlookup?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

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

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

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

like

Anyone know what these badges are?

Post Photo
likefunny

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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

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

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