When I build reports, I always struggle between including all the details and keeping it simple enough for people to actually use. Sometimes I feel like I either overwhelm my audience or leave out something important.
How do you strike the right balance in your Excel reports?

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

If you have access to your audience, know what information they need. Have meaningful header cells and labels. If needed or possible, add a narrative to summarize or give context to the report.

like

Yes totally agree - knowing what your stakeholder needs is the most important

Related Posts

How do you get a job working in food science research? What are some of the best companies to work for in that field?

like

I’m interested in reaching for a position as manager for a local retailer, but I hate having to play the bad guy. How can I become more comfortable with fulfilling that role?

like

I recently started working a side gig to supplement my income. It's tiring but I felt I had no other choice. Has anyone else here started working a side gig too?

like

If an individual resides in CT and works in NY can we serve them in NY?

like

What advice do you have for building a MAKERS Club?

like

Check the overtime laws for your state!!

I just recently worked 58.6 hours in a week, weekly pay, nice OT profit right? Depends on where you live.

In Iowa, there is no Overtime pay mandate, the overtime pay is at the discretion of the business. I received 58.6 hours of base pay for the week.

If the company makes less than $1 million per year or does not engage in intercontinental sales, the company is not required to pay the overtime rate of time and a half, just your base rate.

like

NYC Resturant List!! Category is Seafood:

theBoil
Surf Bar
Hot & Spicy
Luke’s Lobster
Cajun Sea & Oyster Bar
Seafood City
Claw Daddy’s
Burger and Lobster

like

Has anyone in your company heard the word (cross-connect) or (leased Line) perhaps you have heard this from the network team at your financial institution?

like

Here a European from one of those communist countries who use taxes to have free ish healthcare and that.

I'm about to move to the US and just realised that paid holidays are not a thing there. What's the deal? Some agencies better than others? Can I get days even if I don't get paid? So much to do outside of work, I need dayzzzz

like

Given that a lot of ZSers ate joining Novartis, do you think that we can have a whatsapp group for the same? Thoughts?

like

Hello Witch employees.
Can someone help me with job reference.
Thanks in advance

Post Photo
like
like

Anybody here from Morgan Stanley Bangalore. Need help with referral.

like

Hi Fishes, we’ve opening for Oracle DBA Administration and I can refer who is fit n willing to switch.. DM me your mail ID

Post Photo
like

Curious to know what salary Social Media Managers are making in the NYC area. Interviewing for management roles and here comes the dreaded convos for desired compensation.

Hi Fishes,

I am about to have HR discussion for Assistant manager Analytics.
I have 5.6 YOE , CCTC - 14 LPA

How much would you guys suggest I should ask?

Thanks

like

KGS advisory line of business: One thread for all ratings please - Continue after me...
Rating : 2
Hike : 20%
Bonus : 24% annual (joined mid year so I got fixed CTC*12% for 6 months)

like

Any good coffee brand suggestions in the US or Europe that match up to filter coffee taste back home?

like

Is Disney a buy @ 112? I know the upside is if/when the parks can reopen it should go up. Also Disney+ is continuing to beat expectations. Just worries that the parks will@be delayed even more which will hurt them

likehelpful

Hi Fishes, Recently got offer from Salesforce as an Technical Salesforce Support Engineer. Can you please share what actually it is. I'm from java background YOE 2.

I'm confused which one have to choose one hand I'm holding LTI offer as Java developer.

Additional Posts in Excel Genius

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

Still don't have xlookup. #fomo

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

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

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

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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

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

Post Photo
likehelpful

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

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)

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

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

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

Would anyone be willing to teach me vlookup?

like

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

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

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

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

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

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