What are some good resources for making dynamic dashboards in Excel? Or would PowerBI be the way to go? I'm looking at a small dataset so I figured Excel could work just fine.

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

F

I’m not aware on how to build dashboards in excel. It’s either tableau or power bi

PBi would be the easiest way and a smaller dataset makes it even easier if you already know how to use it.

With a good dataset. You basically just drag and drop and design the dashboard in no time.

I’ve made some great dashboards in Excel for clients without a PBI or Tableau option. Mostly because the handoff to their staff was much less technical and wouldn’t be able to update or manage a true dashboard. Excel is great just use charts, a lot of formatting, spark lines and such, and conditional formatting. Plenty of YouTube tutorials

Search “Excel dashboard” on Youtube and you’ll be surprised what people can do. Super easy to replicate as well.

Related Posts

like
like

I am unable to log into the ionboard portal. Anyone facing the same issue. Please let me know.

DM me if you’re looking for a referral to work at Dell Technologies. Global offices eligible

like

48/M, average health. Few weeks ago I had a seizure out of the blue. First time ever, no family history. At the hospital given lots of tests: MRI, CT, EKG, EEG, blood/urine/COVID tests. Everything came back normal. Since hospital discharge I’ve seen cardiologist and wore halter monitor for a week. All good. Have neurologist appointment next month but afraid no one knows why this happened. In the meantime no one wants me to drive a car. Can this happen again? Can anyone relate to this situation?

like

Anyone looking for a job change? DM me for a Deloitte referral. We are hiring numerous positions across the country.

likesmart

Anyone hiring a junior level producer?

Can anyone refer me for SAP Functional Consultant role??? I have 5.5 YOE from KPMG & EY so far. Worked in SAP Implementation/Deployment program as a Techno-Functional role.

Hey fellow Fishes,

I am about to embark a new role remotely. It is also a fully remote role as well, love to hear personal success stories of how their onboarding and learning has been in a remote role and any tips/best practices

like

Does anyone know what vaccinations are looking like? Where to get them and when they’ll be available?

like

Hi All,

I am looking for a new opportunity on ITSM domain accross India on an immediate basis. Please let me know in case you can extend any help.


Prompt response is appreciated

For those of you that have been to Costa Rica, how difficult is driving there? Planning on renting a car and worried about the roads/road signs since I know minimal Spanish.

like

Republicans annoy me because Biden is fumbling the bag right now and wrecking everything and republicans decide that RIGHT NOW is the time to die on the hill of a social issue. We have a litany of economic and energy and strategic issues and they decide to just randomly do this for no reason

like

Hey fishes, aside from the obvs candidates (fjord, Ideo, snook, deloitte digital, ey Parthenon, pwc consumer bit), who else is doing good work in the UX research/service design space? UK/Europe based.

like

Has anyone taken sabbatical? What was the process and did it affect your year-end?

likehelpful

Still don't have xlookup. #fomo

like

Let’s take a poll. What is the worst big law practice in terms of lifestyle and which is the best?

like

Are Coforge reviews fake on Glassdoor? Had a discussion with their HR today. He was telling Coforge is doubling in size and revenue in the next 2 years, we had the least attrition. You can do your research. Maybe Delhi Noida based companies, I really feel scared about. I think they will say anything to get a joining.

Anyone else dealing with anxiety around the uncertainty of continued remote work? We were so dysfunctional and unproductive in the office, the thought of going back is giving me nightmares.

like

I have a technical interview with Google Software Engineering team. Anyone know what kind of questions they will ask? What are the best Google offices in the US or Canafa? are they flexible with remote work?

like

Additional Posts in Excel Genius

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

like

Still don't have xlookup. #fomo

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

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

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Any book recommendations on excel modeling for real world business applications?

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

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

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

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

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

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

like

Anyone know what these badges are?

Post Photo
likefunny

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

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

Post Photo
likehelpful

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