{ "_id": "5a56f68d15f6ef0013aad256", "name": "Excel Genius", "type": 2, "creatorId": "5a328e7245ae9f00180fa77e", "bowlType": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise", "isVisible": true, "isPublic": true, "divisions": [], "feedState": { "lastMessage": "Is there a shortcut that pulls up a list of shortcuts in excel?\n\nThought I had seen it mentioned before but can’t seem to find it now and all the lists I’ve found online don’t mention it.\n\nTIA and sorry for the basic question!", "lastSign": "McKinsey & Company", "lastUpdateDate": "2021-09-22T17:07:08.109Z", "lastMessageDate": "2021-09-22T17:07:08.109Z", "countOfSystemMessages": 0, "countOfUserMessages": 1015, "countOfMessages": 1011 }, "numberOfUsers": 30000, "relatedCrowdIds": [ "552d1d24dc1c586b09d2d051", "564a5cdb94887803001dd07c", "552d1d24dc1c586b09d2d052", "553769a790f5eebe1d2a0f92", "5565cfca8b2b9a03009acf57", "5eb1bcb23b975f0021424ca1", "55375ce690f5eebe1d2a0f88", "5682e6afd55b9e0f00fce669", "5787dd60a3f35c130082b851", "56c75c3c1dc12b0a0097ccb0", "56fd40e29238700e00b5ee4a", "5d0a757f66884500200aff25", "564cbaf767469503004fede0", "5e4bca4d473da1001b53cb24" ], "background": { "from": "05B3DF", "to": "0F71A6" }, "creationDate": "2018-01-11T05:30:53.591Z", "priority": 0, "isLocked": false, "description": "Discussions, Useful Tips, Resources, Macros, More", "numberOfNetworkingUsers": 322, "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/zyKRUmCcr4SD4.png", "handleUrl": "excel-genius", "fishIconColor": "4c28ff", "numberOfFollowers": 12394, "categories": [], "promptsDisabled": true, "roomEnabled": true, "suggestedIndustry": { "_id": "552d1d24dc1c586b09d2d051", "name": "Consulting", "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/q6ousBABT88sI.png", "crowdIconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/KF6SyAmqgD6Ae.png" }, "lastView": "Invalid date" }
Discussions, Useful Tips, Resources, Macros, More
Sign up to access more conversations in this bowl 🔑

Is there a shortcut that pulls up a list of shortcuts in excel? Thought I had seen it mentioned before but can’t seem to find it now and all the lists I’ve found online don’t mention it. TIA and sor… more

likefunny

I have a requirement to show an interactive scatter chart in Power Point from data stored in an Excel spreadsheet. Power Point and Excel files need to be in the same folder on a local machine and usa… more

like

Does anyone know how to keep in leading zeros when converting to a number, so I can do a vlookup across data sets?

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 a… more

like

Does anyone know a formula or how to do a power query to do a lookup function returning a value if it contains certain wording instead of an exact match? For example I could do a Vlookup but the table… more

like

👊Pay it Forward: What's the best Excel wisdom or advice you've ever gotten? Share it here and help another user! 👇

like

I created a macro in excel after googling some code and found one for when I have like 15 excel files with 2 sheets each for example, that I’m trying to combine into one workbook with 30 sheets. This … more

like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

Looking to do data analytics for nonprofit organizations. Any forms or websites to look?

like

I have been given a csv file and one of the columns has multiple properties. I want to split each of the properties into their own column. However every row doesn’t always have them in the same order and may have slightly different properties. Is there a way to sort this efficiently?- picture for reference, columns v onwards is how I have split with text to columns currently. Any help is greatly appreciated

Post Photo
like

Hello, I have an excel file that contains information that are all listed under one another and I would like each category to be in their own columns but same row. More in comment

like

I want to use power pivot to analyze and excel file with 3 million rows. However excel stops at 1 million. Does this mean that it’s chopping off the remainder data or is it just not showing it to me?

like

Hey all - any recommendations for creating a qualitative ROI model in xls? Client’s request is to keep it as simple as possible. Haven’t done any before so any recommendation is appreciated 🙏

like

Suppose I have a table where column Aksts groups and column B lists subgroups (so there are multiple unique values in B for each unique value in A). With pivot tables or anything else, is there a quic… more

like

I’m on a Mac and trying to do 2 things: Merge a bunch of P&L quick books sheets into one excel file, and then consolidate them into one table. Any suggestions?

like

I’ve got a pivot table set up of payments made throughout the year. How do I get the day that the most payments were made on ?

likehelpful

Excel gurus I need help ASAP! Is there a way to convert a process flow into a checklist in excel? The main confusion I’m having is how to take the diamonds of the process flow and based on the respons… more

like

Can anybody tell me how one can open a list off all tabs to navigate in a workbook with many tabs?

like

Anyone know a quick way to value paste for each tab to another excel file if I have 40 tabs in a file needed to copy. Each tab has many formula in there, but when copy-over I only want them to show ha… more

like
like

Hello! I am exhausted of googling how to create an excel file to add expanders within a cell and all I can find is how to group and hide. Which this is not what I am referring. I saw a file in which you can do this in excel but I can’t seem to find it. It looks something like the below picture. This is a plus sign in which you can expand and collapse. I appreciate your help

Post Photo
like

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yest… more

like

Is there a way to copy filtered data (hidden rows) and paste it into an entirely different worksheet that is also filtered?

like

Anyone run into an instance where one VBA goal seek will work within a loop and then another vba goal seek not in a loop within the same workbook won’t work? I’ve done some google research and it seem… more

like

Not sure where this post belongs because I don’t think it’s an excel solution, but I want to be able to pull data from various direct datafeeds (and be able to pull in reports from say excel as well).… more

like

Is there any way to generate a summary of comments or view all comment for a workbook?

like

Is there a factset formula to pull price and EV and EBITDA for a company at the date of IPO? Not sure if Factset is that sophisticated… I also suck with factset

like

How do you convert quarterly data to annual data (assume annual = average of 4 quarterly data points)? Data is in this format: C2: 2020-03 D2: 2020-06 E2: 2020-09 F2: 2020-12 G2: 2021-03 … I am able … more

like

I have a COUNTIF and want to single out data greater than 5 and less than 100. How do I include both within the formula?

like

Does anyone know how to make it so that a scatter plot doesn’t shrink when you filter on a table? Because the cells disappear with the filter, the scatter plot then goes to about half the size? Also h… more

like

Using Vlookup to pull corresponding service and corresponding region to these customer codes. Took codes from column D straight from the source file I’m looking in, so no way there are any typs or format issues. Any idea why some cells are pulling N/A?

Post Photo
like

Hi geniuses, question about updating data validation drop-downs. If I rename a value in a cell’s source list from “test” to “testing”, it does not automatically update the cell if I’ve already selecte… more

like

I run an NFL survivor pool each year. Is there any way I could create a sheet where people could only edit picks each week next to their name (not able to change other people's picks) and it could… more

like

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

like
Share this 🔥 post

Alright geniuses, I am stumped. I'm trying to calculate growth in rental income and want to compare only for properties that existed across the whole time frame. Since 12mths ago, new properties have been added to the portfolio and so rent is higher, but %growth should not include new properties that have come on. To illustrate, % growth from month1 to month6 should only include the properties in dark green in the numerator and not the rest of the properties showing income in month 6.

Post Photo
like

Building LBOs and my circularities keep breaking everytime I refresh or save the model. If I turn the circuit switch off and on then everything works again but it makes analysis really hard to run. An… more

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have … more

like

What are the most annoying things for you in old-school excel users? I’ll start: 1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like
Share this 🔥 post

What’s the cheapest way to download Microsoft excel? I don’t have a student email

likehelpful

How do you highlight two separate areas (you can do it with control shift) using only the keyboard? I heard you can do it with a F number key.

like
Download Fishbowl to see what others are saying
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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal