How do we go from data to decision faster using Excel?
How can we make formulas more understandable, and dashboards more actionable?

Would love to hear what others are exploring!

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

Excel is a tool, if you don't know what you want to tell with the data or how to clean it then it is useless. For dashboards try adding multiple each using different pivot table and then add slicers linked to control all pivots. So you can apply filters that all graphs change by.

like

Great advice

Related Posts

like

Guys, for 6 YOE in java fullstack developer. What is current market price ?

Techs : Java springboot microservices (9/10), angular/reactjs (7/10)

like

I am teaching 4 sections of math this year. My school curriculum is IReady. Which find to be to complex and busy for SPED kids. Does anyone use an interactive notebook along with standard curriculum? If so what fo you use?

like

Anyone have good alternatives to the integer card game for 7th grade? With Covid I don't think I can use the cards

like

My friend is working in Microsoft as a project manager. Got an offer to join make my trip as a technical program manager. Current salary is 15l (base 11.5). How much should he ask for? Microsoft MakeMyTrip

like

How to avoid immediate staffing after completing the one project?
Somebody advice on this please.
I literally need 1-2 weeks bench/off time.

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

I've cleared the technical and managerial round in Citiustech. I will have my HR discussion tmrw. My current CTC is 12.75 LPA. I've asked for 17 LPA fixed during the initial stage of interview schedule. Will they offer as my expectation ?

YOE -4+
Stack - ETL developer

@CitiusTech

like

Can we share one company offer letter to another company ??

It says strictly confidential and copying or distribution of this e-mail or use of information contained herein is strictly prohibited and may violate rights to proprietary information.


Any other way I can avoid this process?

like

Moving to London from US. Any recommendations on international moving/shipping service providers?

Currently I have 6.5 years of experience, completed 2 years in current organisation and I got very good hike also (after hike CTC is 24 LPA )
And my manager got changed also but I am frustrated with my new Manager.
should i start preparing for next/better Company like Amazon, Microsoft ?

Has anyone recently interviewed with S&P Global and got an offer?

Hii guys, need 11 likes to dm. 😊 Thanks

like

Hello!
I’ve been working as a RPA developer for 4 years. I joined a program that trained me in this role as a opportunity to start a career when my initial plan fell through. I’ve don’t pretty good so far…given multiple roles, pay increases etc. Honestly I don’t enjoy my job anymore and would like to make a change. I want to transition to a tech Product Owner/Manager role. Any advice on how to transition ?

like

An adorable yellow lab puppy came in today after swallowing a spoon. What’s your strangest foreign body case so far?

like

Anyone know where I can rent a small boat for 2-4 hours relatively cheap? TIA

like

Does anyone know a good Laptop for $1100 that would have the following specifications: Intel I5 10th Gen, processor, 512GB SSD, 16 GB RAM with Windows pro, with at least a year of warranty?

like

If you could rename your firm to make it more representative of said firm, what would it be?

like

Additional Posts in Excel Genius

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

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

likehelpful

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Would anyone be willing to teach me vlookup?

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

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

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

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

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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