{ "_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": 666, "numberOfUsers": 208805, "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": 24, "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": "" }

What processes/ reports can typically be automated using excel? I’m in FP&A and there is a lot of manual/ tedious work and looking to automate some stuff.

like

Trying to use Ctrl + [ in current excel to trace formula dependents (and F5 to return back to where I was) but for some reason it’s taking me to some random tab. Never had an issue using this before. … more

like

I'm being pressured to switch to Google Sheets for collaboration, but my heart belongs to Excel. Is it worth resisting, or should I just embrace the change? What are the pros and cons you've e… more

like

How do I get rid of this STUPID menu bar that pops up every time I open excel? Was messing around with settings and somehow this became permanent…tried googling and everything to get it off and no luck.

Post Photo
likehelpful

I have 100+ forms that I need to combine data from into a master sheet. For example, a question on the form says “what is your favorite food” and the respondent would type in their food into cell B2. … more

like

A big debate in the office: tabs at the bottom vs. tabs at the top of a workbook? This feels like it could escalate into a full-blown war. Is there a clear winner here?

like

Does anyone have a good way to share a power pivot report with a Mac user? I’ve tried using excel online with sharepoint but the performance is abysmal and the query is not supported, so updates are m… more

like

The "Recommended Charts" feature is an absolute menace. It never gets my vibe and suggests hideous monstrosities. Does anyone actually find those recommendations useful - or is there a way t… more

like

I'm working on a project to enhance efficiency with after-call work at my job. I've organised different after-call work prompts,

I'm looking for a way to make it so that clicking on each cell in one sheet function… more

like

Coworker keeps asking me to build his reports for him... he just doesn't want to put in the effort. Do I teach him to fish, or keep doing it myself to get him off my back?

like

Hoping for help with my Excel 365 problem. I have 3 columns: Amount Due, Date Pd, Cash Available. (see image below) In Col 3 want to create a function that subtracts Amount Due from Cash Available only if there is a date in the Date pd column, otherwise if Date pd column is blank do nothing. I think I should be using an if function, but not sure how to set it up. Thanks in advance for all your help.

Post Photo
like

PivotTables terrify me. I just can't wrap my head around them. Are they worth the struggle?

likehelpful

Looking for someone who is great with expense budgeting/forecasting. I have a technical interview for an FP&A analyst role and I’ve been given historical expense data for the past 24 months. Expenses ar… more

likehelpful

Looking to train Llama 3 to work as an Excel assistant locally. Does anyone know of a large dataset that I could use to train it? Thanks

like

Any suggestions building a Gantt type presentation with an hourly timeline vs. days? Data: Task, start time, end time both in 24hr/military time.

like

Hi all, I can’t figure out what’s wrong i checked the cells and info to ensure there’s no errors or odd fields, column A where the dates are looks as it should but I can’t group it?? Thoughts. Thank you

Post Photo
like

Any good online courses to sharpen my Excel skills? Free is ideal, but willing to invest if it's amazing.

like
Share this 🔥 post

How can I gather data from the internet into one spreadsheet? For example: I want the color, height and bloom season of certain rose types in my spreadsheet.

likeuplifting

I need a new mouse that will ease my wrist pain. Any ergonomic recommendations for heavy Excel users?

like

What are some awesome, lesser-known Excel blogs or channels? I need to freshen up my knowledge.

likehelpful

Any good tutorials for XLookup?

like
Share this 🔥 post

Am I the only one who hates those template spreadsheets with all the fancy (and distracting) bells and whistles? Simple is best, right?

likesmart

I am looking for some practice on building financial statements from scratch for a case study I have coming up. Does anyone know of a resource/tool that can generate raw data to manipulate into financ… more

like

My company insists on using paper forms and then manually inputting data into Excel. I'm dying inside. How do I convince them to digitize without sounding like a whiny millennial?

like

What’s the best template you’ve seen for excel task list that can be used for a project management?

like

Any recommendations for Excel classes or online courses I can take? I want to learn more about how I can make Excel work for me, beyond learning formulas and operations from piece-by-piece YouTube vid… more

like
Share this 🔥 post

In a giant table, I want a formula that can look for a specific set of serial numbers and then return all the information in that row next to that serial number. What formula should I use? VLookup onl… more

like

Hi, does anyone have access to the FMVA modelling course provided by CFI? I'm really sorry but I can't afford this course and I'm wondering if anyone could grant me access to it. I have an interview on Tues… more

like

How often do you use dynamic arrays? I’ve created a couple reports using them which summarize csv data into a nicer format, but everyone else who uses the workbook freaks out about them.

like

Excel humor is its own special language. What's your favorite spreadsheet-y joke?

like

Is there a such job as Excel support? Where people can contact you to troubleshoot their spreadsheets? That would be a dream job for me! 🤓

likeuplifting

I get weirdly competitive with those online Excel-timed challenges. It's both thrilling and pathetic. How seriously do you take those things?

like

Hello all, I feel some empty because I don’t have a mastery of excel please I need a platform to obtain excel skills ! Can someone guide ! Thanks

likehelpful

In need of cool Excel project ideas to practice my skills. Something more interesting than the usual budget trackers, please!

like

Looking for an efficient way to pull a bunch of addresses from various websites into an Excel sheet. I’ve tried Power Query but the data isn’t in tables on the various sites. I’ve tried ChatGPT but it… more

like

Coworker keeps asking me to do their Excel tasks for them. I don't mind helping occasionally, but this is becoming ridiculous. How do I set boundaries without seeming like a jerk?

likeupliftinghelpful

What are some Excel tips for impressing my Supervisors/Bosses? I'm low on the totem pole and just work in the warehouse but for a couple months I was taking care of Quarantined Parcel Management (lots of exce… more

like

How do I protect & hide formulas at the same time allow data entry in others? So, the entire sheet isn’t protect, just formula cells? Please help

like

I'm secretly automating like half of my job using macros + AI and have a ton of free time. Do I tell my boss and risk getting more work, or do I just enjoy the easy days?

likesmart

I built the most amazing, automated Excel report, and my boss barely even glanced at it. Instead, they got excited over a coworker's flashy PowerPoint with zero substance. Feeling pretty defeated … 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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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