Am I the only one who hates those template spreadsheets with all the fancy (and distracting) bells and whistles? Simple is best, right?

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

I like starting simple and adding my own bells and whistles so the sheet sings the exact tune I want it to.

like

Ok, boomer

I'm my opinion, bells and whistles are for Power BI. Excel is for storing data (assuming you don't have a better way like SharePoint lists or Databricks or something) and doing simple ad hoc calculations that won't be needed very often in which case, Power BI.

Related Posts

I've been exploring exit opportunities for a few months and still holding out for the right opportunity. However, I've had A LOT of recruiters reach out to me for positions that are way below my current salary. They do the whole "your background and expertise is exactly what we're looking for" then turn around and offer a salary range that is 20k below my current level. My resume clearly says I've got 10yrs experience and an MBA. I **don't think* I should be getting offers of 80k-100k

like

Hello Fishes,

I have passed the TR and MR rounds at Cognizant. HR is saying they will schedule today but are not sending invites; this has been going on for a week; what does this mean?

Getting into the military helped my feeling of abandonment due to my father's absence. It sounds funny, but being in the military showed me another type of parenthood that I needed.

like

will cognizant blacklist me if i didn't join. my joining date in cognizant is 24th april and thinking of emailing my decision today.

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

Has anyone used PracticeDump to study for CFE? Is it legit? I’m thinking of getting it since it’s so much cheaper than the one offered by ACFE website

like

Is the working hours mentioned in my workspace correct? I have recently been allocated to a project and it shows timings from 11 pm -9 am..

like
like

Is there another RSM bowl?

smartlike

Why do we do this to ourselves? I’ve been working 90+ hour weeks for the past 9 months, always under insane pressure, I’ve given up weekends, holidays, any possible time, and the firm still wants more

like

What’s the word on the street about work life balance at Edelman? Are the hours insane?

like

This reminds me of all the Chads and Brads Crypto Bros. 😂🙄

Post Photo
likefunny

New to LA... what’s the best places to meet people? I live in downtown

How to prepare for Amazon Business analyst role? (I cleared the first SQL round). Also, what to expect in terms of base package for L4/L5. The role is based in NYC.

like

Hi all,
Been doing privacy for about a year now in-house. Got my CIPP/US.
Having major imposter syndrome still. I feel like the minute I finally have a grasp, something changes. The law and nuances just seem overwhelming. Maybe it’s just a lack of guidance/uniformity in the US. I’m not sure if I feel this way because it is simply the nature of the work or because I’m just not capable.
😔

likehelpful

Happy Friday to all the "super lawyers" out there.

Never forget that you're not just super. You're super duper!

Post Photo
funnylike

Considering pivoting into tech. Currently considering Project Management or Presales tech. I understand the general roles of each. Presales seem to make more than PM, so I am leaning towards presales. Curious if any PMs considered presales and why you decided to do Project management instead

like

Hi All, currently Visa is approved, stamping is yet to be done... But the package is 60k only and I heard from colleagues who are already there, that this is not sufficient... I am working at a package of 12 LPA in India, and I think switching is the best option rather than going to US. Need your opinion please

like

Hi Fishes, How is CIO Advisory Cloud Team in KGS ? How are the growth opportunities, WLB being with the Cloud Advisory team? Is it worth joining?

Position interviewed for: Cloud Architect , YOE: 5 KPMG KGS

like
like

Additional Posts in Excel Genius

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

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

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

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

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

like

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

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

like

Would anyone be willing to teach me vlookup?

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

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

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

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

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

Anyone know what these badges are?

Post Photo
likefunny

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