{ "_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": 670, "numberOfUsers": 212210, "type": 2, "bowlType": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise", "background": { "from": "05B3DF", "to": "0F71A6" }, "roomEnabled": false, "requestToJoinSettings": { "isJoinReasonRequired": false, "shouldRequestPhoto": false, "isMultipleChoiceEnabled": false }, "bowlTypes": [ { "bowlTypeId": "58e6c2e40ebdd20010849126", "bowlTypeName": "Professional Expertise" } ], "currentMonthPosts": 17, "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": "" }

Can someone refer me to a sql bowl?

like

What are some unique applications of conditional formatting y'all have tried? I made a pretty cool checklist that updated according to the task's completion percentage.

like

Does anyone know how to make a FILTER formula that would bring any data from a column if the first 3 letters match “abc” or the first 4 letters match “abcd”?

It seems like you cant use the LEFT formul… more

Has anyone figured out flash fill because I swear it NEVER gets it right when I try it. What's the secret to making it work?

Post Photo
funnylike

What is your favorite excel add in?

What do you guys use excel for in your personal life? Besides budgeting because, duh.

like

When are we going to see GenAI for Excel? I'm done with these formulas lol.

like

Any way to collapse the content of several cells into the top cell in a selected range?

I'm converting PPT tables to Excel, but any table cell with multiple lines gets copied over as multiple excel… more

How do y’all return a deduped list? I either paste special and remove duplicates, or use a combination of UNIQUE and FILTER.

like

You can never be too careful lol

Post Photo
likefunny

Client had provided an updated data dump PnL for 100+ assets with the quarters of each year going in descending order. I have built my working sheet in ascending order. Instead of redoing a new worksh… more

Grateful for the help Excel but please, sit this one out 😩

Post Photo
funnylikeuplifting

What’s the most complex formula or function you’ve ever created in Excel?

like

What are some Excel keyboard shortcuts you can't live without?

likeuplifting
Share this 🔥 post

All the updates to Excel and it still struggles with this 😅

Post Photo
likefunny

Quick question: our GM makes 4% of NI. Net income changes once his commission is posted. I had an algebraic formula to calculate early in my career. I now calc by reducing NI by incremental perce… more

like

Does anyone know how to consolidate data from several Excel files, please?

helpful

Can anyone help me with margins when printing in excel? No matter how hard I try or what I look up, I can’t seem to get rid of white space on the left and bottom when I’m printing.

I’ve tried putting e… more

A committed and seasoned professional specializing in Administrative & Executive support for 7+ years. I regularly provide Management, Coordination, Administration, and Events and Conference servi… more

Yup, this. I've been burned too many times!

Post Photo
likefunnyupliftinghelpful

Excel on a mac is infuriating. I'm pretty sure the 7th circle of hell is people forced to build complex Excel spreadsheets using a Mac. Pure torture.

likefunny

Um excuse me who disrespected PowerPoint like this?! Switch it with Word, then you've got a decent ranking.

Post Photo
funnylike

My job is willing to pay for an Excel course, I'm looking for a really robust training that covers everything from formulas and functions to Macros and VBA. Anyone have any good suggestions?

like

I have two tables. I want to add a Start Date for the actions in Table 2, by looking up values in Table 1. Start Date is the date when the number in Table 1 is >1 the first time. So for Action 1, Start Date is 9/1/2024, and for Action 2, it is 10/1/2024. Any recommendations on the formula? Thank you.

Post Photo

I don't know who made this but its on the money. Why is 80% of my job working in Excel ? What the heck did I get as masters degree for 😂

Post Photo
like

I understand this is an Excel Genius group but I need help. I want to perfect my Excel skills. I am still a new learner, how do I do that please? Thanks

like

Hi all. I'm looking for some career advice. I'm an Excel geek and spend my days using Power Query, Power Pivot and VBA to simplify and automate processes. My current role does not have many interesting pr… more

like

Anyone else use vlookup a lot? There's usually always something I have to fix but I think I've finally gotten the hang of it! Small wins 😌

Post Photo
likesmart

I need to improve my skills. Can anyone recommend . I need intermediate upwards.

like

I made the mistake of helping my boss with a simple excel formula and now I'm getting pulled into weekly meetings to show her and other execs how to set up their reports. This better lead to a promotion lol.

Post Photo
likefunnysmart
Share this 🔥 post

Using Google sheet and not sure why the MAX ROW formula is giving me 10 instead of 12? Help!!!

Post Photo

Fellow needs 🤓, what's the best way to convert a folder full of .xls files into xlsx? Preferable if the solution can avoid VBA. Is Power Automate a possibility? Thanks!

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