{ "_id": "5a56f68d15f6ef0013aad256", "_isBlocked": false, "creationDate": "2018-01-11T05:30:53.591Z", "categories": [], "description": "Discussions, Useful Tips, Resources, Macros, More", "relatedCrowdIds": [ "552d1d24dc1c586b09d2d051", "55375ce690f5eebe1d2a0f88", "5c751b9f2f6b98001bc666f8", "564a5cdb94887803001dd07c", "5565cfca8b2b9a03009acf57", "553769a790f5eebe1d2a0f92", "5787dd60a3f35c130082b851", "552d1d24dc1c586b09d2d052", "5682e6afd55b9e0f00fce669", "5e77c585cba148001ab93ed9", "5d0a757f66884500200aff25", "56c75c3c1dc12b0a0097ccb0", "56fd40e29238700e00b5ee4a", "575591bd4715870e00d30511", "5e8d00ee065ee5002135bc2f", "5ef17d0fc9914f0024fe1911", "6307b985e8cea3002c9297b4", "63079a6ca12e86002600a26a", "5e7169c6c917a6001ba5fefc", "63079f67548aa90022fc0415", "564cbaf767469503004fede0", "5e4bca4d473da1001b53cb24", "5eb1bcb23b975f0021424ca1", "63c7b55b3b4cbc0052c7df17" ], "fishIconColor": "4c28ff", "hideNumberOfUsers": false, "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/zyKRUmCcr4SD4.png", "rectangleIconUrl": "", "isLocked": false, "isCommentsEnabled": false, "isPublic": false, "handleUrl": "excel-genius", "isVisible": true, "name": "Excel Genius", "networkingEnabled": false, "numberOfNetworkingUsers": 684, "numberOfUsers": 231542, "type": 2, "bowlType": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise", "background": { "from": "05B3DF", "to": "0F71A6" }, "regions": [ "61891c8e2ca26eaffdf8d90f" ], "requestToJoinSettings": { "isJoinReasonRequired": false, "shouldRequestPhoto": false, "isMultipleChoiceEnabled": false }, "bowlTypes": [ { "bowlTypeId": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise" } ], "currentMonthPosts": 1, "joinMode": 0, "suggestedIndustry": { "_id": "55375ce690f5eebe1d2a0f88", "name": "Tech", "iconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/tech_9Hox4.png", "crowdIconUrl": "https://dslntlv9vhjr4.cloudfront.net/crowd_images/qwBNWfWrlFN7L.png" }, "noIndex": false, "lastView": "" }

How do you highlight your excel skills on your resume?

like

Good morning, afternoon and evening everyone! I’m creating a ranking system and need some opinions! Do you believe a ranking system should start with a 0 or 1 for the lowest?

like

Cells filled with data,
Formulas weave magic spells,
Insights come alive.

likefunny

Since it's been mentioned here before, how do I effectively use AI to do Excel stuff for me?

like

What's the simplest Excel solution that someone has come to you for?

like

How do you generate a random number in excel? Wrong answers only! 🤡

like

Imagine you receive an annual grant of restricted stock units (RSUs) in January. The RSUs vest quarterly over three years. How would you write a formula to generate the total vested amount in a given … more

likehelpful

Hi everyone, anyone know of any easy tutorials to learn basic SQL? or any other kind a queries using excel?

like
Share this 🔥 post

How do you automatically enter consecutive numbers per row, i.e, "1, 2, 3, 4, 5, 6, etc...

like

What's the most in-depth Excel-related question you've been asked during an interview?

like

What new Excel trick did you learn this week? Please share with the bowl! 🌟

likesmart

Where can I learn more about mastering pivot tables?

like
Post Photo
likefunny

How can I limit a calculation to only show values between +/- 100%? I have a calculation showing thousands of percent and want to limit.

likesmart

Are there any older versions of Excel that you actually prefer to the current version?

like

Starting at MBB soon, can someone recommend some good excel courses or atleast list the skills I should really master to do well as a consultant?

like
Share this 🔥 post

Does anyone use Excel for general task management? Wondering how to make it work for me.

like

Is AI going to replace excel?

likesmartfunny

Hey everyone,

I was looking to see if someone has a template or can assist me in creating an Excel sheet for my startup business to calculate sales, revenue, and expenses.

like

Geniuses & Wizards -

I have a large data set; that associates
1) Business Name to 2) Process ID. In a Process; there can be several 3) Legal Entities.

Problem:
Multiple processes can be linked to a… more

like

Anyone have a few go-to resources for data evaluation functions?

like

Have You used Office Scripts in Excel instead of VBA? If yes, what kind of procedures did You replace?

like

Does anyone here work for an Excel consulting firm or as an independent Excel consultant full-time? Curious to know what your salary looks like.

like

Can someone kindly share how to strip out notes/comments out of an excel template? They are so annoying and I can’t figure this simple little task out.

Post Photo
like

My bank is looking for an online excel training course for new hires on our project finance team- any recommendations? General financial modeling is fine but would be a plus if the course is specific … more

like

Has your company enabled Microsoft Copilot in your Office package?

like

I'd like to pull numbers of how many active contracts are up for renewal each month in 2024.

I have a master contracts spreadsheet with (in addition to many other columns, but these 2 are what I need to filter):
-An expiration dates column
-Dates are formatted as: 28-Feb-24
-A column indicating active/inactive

Goal is to use data to create similar chart.

Hopefully that makes sense!

Post Photo
like

How creative do you like to get with your charts and visuals? I probably spend way too much time on the details TBH.

like

With hat in hand and head bowed, I come for help from the genius community.
I have a trash format dataset that I'm trying to extract clean data from, all within Excel.
I am looking for a single form… more

like

How many tabs is too many for a single spreadsheet?

likefunny

Going through an interview process and might have an Excel Case Study to do for fund/portfolio modeling.

I’m confident in my skills but would still like to practice as much as possible. Anyone have a … more

likesmart

According to some, generative AI makes this bowl obsolete because anyone can simply type their excel question into ChatGPT and get an accurate, immediate answer. Taking this to the extreme, I presume that all of … more

like

Excel VS Google sheets for spreadsheet collaboration?

like

I need help writing an OFFSET formula that will 1) return the array of numbers below including the blanks in the correct order and 2) be dynamic such that if I add the number 11 either in the cell directly below the 10 OR below the 10 but with blank cells between will continue to pull the full array including blanks up until the 11. I know how to do this if there are no blanks, but the blanks present an issue because I can't combine the usual OFFSET with COUNTA functions.

Post Photo
like

After grouping rows or columns, is there a short key to extend or collapse the grouped rows/columns?

like

This bowl has been obsolete since ChatGPT was released last may. Yet, the posts keep rolling in. Genuinely asking, why are you all still asking a bunch of strangers to write an excel formula for you i… more

likefunnyuplifting

ChatGPT said I should ask y’all to share your spreadsheet horror stories so we can learn from our bad experiences…now I’m too curious not to! The worst experience I’ve ever had was as a consultant, sh… more

likesmart

I have names of people in Column A and their scores in column B. I also have names of same people in Column F and scores of them in column G. Now I want to create a new column H with single list of na… more

like
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 join this community 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