I love building dashboards in Excel, but sometimes I get stuck making them both functional and simple enough for others to use. Too many buttons and drop-downs can overwhelm people.
What’s your approach to making Excel dashboards that are user-friendly without losing important details?

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

I use powerbi

smart

Wanted to add that nowadays I just create separate dashboard for each workbook

Related Posts

Can someone explain what is the diff bw Assurance and Consulting?

like

Does BOA provide welcome kit to new joiners?
If yes, what's that?

like

Been wrestling with treating myself to a Dewar’s 12 for an upcoming anniversary or paying the extra bit for the 15. Thoughts?

like

Hi
Is cab facility free for cisco employees. If not then how much is charged.
Considering 2-3 days hybrid, what you all suggest for commuting
I live 7 km from cessna park.
Needless to say.. I dont own any vehicle as of now. Probably will plan for one. @cisco

Hi fishes, Need info about Infosys Consulting bridge. Do we get to choose which practice we can join? Also is the process easy and worth it? What increase in pay can we expect? Infosys

like

Anyone left FIS Global within very short duration after joining like within 6 month or less than that ?
If yes what was the reason to leave that ? So that could understand cons of FIS.

Or anyone can help about Cons of FIS Global joining ?


Thanks

Has anyone here worked (or does anyone currently work) for Bernstein Litowitz (aka BLBG)? Very interested to learn what inside associates feel about the firm, its culture, work-life balance, billable hours, etc.

like

Tomorrow is zs holiday in India offices. So will be the salary get credited today??

like

My background is in tech transactional. I joined a cybersecurity SaaS startup at the end of last year and now also handle more generalist matters in addition to all things commercial-related. I have a number of books on contracts that I’ve found super helpful over the years (The Tech Contracts Handbook, A Manual of Style for Contract Drafting, Sign Here, etc.). Can anyone recommend books they’ve found helpful for L&E matters, privacy matters, product matters, or marketing/advertising matters?

like

Dear Sir/ Mam , now i am doing SAP Fico traing , i have completed B.com in 2012.
I have 6 year experience as a admin
Is it currently available job in market,
Any refferal

like

Working for Zs almost 2.5 years.. I didn't know bowl like this exists at all. Now a bit relieved.

Hello all.

like

Looking to buy a new family car. We have 4 kids and 2 dogs. Our current car is a Sienna but was hoping to get out of a minivan and into an SUV. Any thoughts on the best and biggest SUVs out there?

How is Ovative?
Good culture? Too much Koolaid like Target?

like

LTI is Hiring for below Oracle - BU positions

Need immediate to 30 days joiners only

Location: Bangalore/Mumbai/Pune/Hyderabad/Chennai

JDE CNC
YOE :4 - 10 Yrs
Skill : CNC

JDE Finance Functional
YOE: 4 - 10 Yrs
Skill : FUNCTIONAL-FINANCE

OCC (Oracle Commerce cloud)
YOE: 4 - 10 Yrs
Skill :OCC

Oracle Flexcube
YOE :4 - 10 Yrs
Skill: FLEXCUBE

Oracle CPQ CLoud
3-5 years of experience in Oracle CPQ Implementation & Support
location - Mumbai

Interested plz DM with job role to apply

Looking for job opportunity in Poltury or Aquaculture for kolkata West Bengal

like

Is there any specific payscale for each corporate grade band?

like

How long is too long to try to push back a start date? Getting a formal offer early next week but trying to keep that big law bonus if possible. Firm pays out bonuses Dec 30 & I have a vacation scheduled Dec 19-23 (and was planning on working remotely the week after too). Ideally want to get EOY bonus or negotiate for a signing bonus but is it too much to push for signing bonus and those weeks off? I'm open to working remotely those two weeks but know that may not be the best when I start.

like

How long as a senior associate at EYP till Consultant? Have a ex colleague who moved over with 3 yoe and is now a senior associate

like

How much is the fixed base and CTC range for a newly promoted M1?

like

Have anyone started getting promotion or hike letters in EY GDS

like

Additional Posts in Excel Genius

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

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

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

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

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

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)

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

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

like

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

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

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

Post Photo
likehelpful

Still don't have xlookup. #fomo

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

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

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

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