{ "_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": 231539, "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": "" }

I'm teaching an afterschool program for high schoolers that's called Excel Gurus and wondering what you think I should make sure not to miss? It's introductory, but most students have used… more

like
Share this 🔥 post

What are your feelings about Google Sheets.

like

Got this during an interview pipeline. How far could you realistically get? What would you look for if you were the test giver?

My opinion is this is a useless test at 30min. You wither get a messy result thay probably hasn't been checked for accuracy or an incompete assignment yielding little to no insight.

Post Photo
like

I have a large excel file made up of invoiced amounts. I need to make a MUS selection on absolute (abs) values; my issue is the total abs value is really big because there are duplicate amounts/items of the same abs value (see pic). As an example, I want to get rid of the items that net to zero (red font) and keep whichever value remains (green highlight)...does anyone have a solution? My population is roughly 500k rows so simply highlighting and deleting isn't efficient.

Post Photo
like

Have you found any competitive softwares that you would say rival Excel for most functions? Not just Google Sheets but even other types of UX too.

like

Built my sister a home financing tool a few years ago when she was on the market. Figured it would be nice to share here too. Nothing fancy, there’s a bunch of these tools online, but sometimes it’s better on a spreadsheet. It’s google sheets though, so chill if you hate sheets with all your might 😂https://docs.google.com/spreadsheets/d/1RBBLrVVYLE-ydyvFjEwmRQsOqG8qY6onv3I7u06YGu4/edit?usp=sharing

Post Photo
likehelpfulsmartfunny
Share this 🔥 post

Do you use Excel for personal finances? What are you doing/how?

like

I’m trying to derive the year in which a threshold is reached (sorry for the incorrectly formatted years). I.e when $10B is achieved, or $12B. The model has a lot of moving components so the thresholds move around based on about 15-20 different assumptions. What would the formula be to help get this? Basically once I know the year, I have to layer in an incentive component but the years will change based on the drivers.

Post Photo
like

Do you have a favorite spot to find excel templates? Google is overwhelming and spammy.

like

Hello,
Can someone recommend me a good excel intermediate class? I want to learn about functions and making dash boards for my data analysis.

like

Can a spreadsheet software (excel, apple numbers, etc) be better than using one of those budgeting apps? Thoughts?

like

Any advice to improve excel skills - specifically for accounting and also general things that are good to know?

like

Hi! I am Marcelle and work in professional development. I am reaching out to query on any recommendations for top notch Excel courses which can be purchased for basic, advanced and financial modelling (Balance Sh… more

like

Greetings! My name is Faith! I currently work in healthcare and will be transitioning into tech as a Data Analyst once I complete my 12 week program that starts next month. Currently I’m teaching myse… more

like

How do I create a daily task tracker to track all the things I do during a day, week or month? So I can easily explain what I’ve been working on and keep track of important tasks or projects?

likefunny

Might be an easy question. But what’s the easiest way for someone to download contacts from an excel sheet to their iPhone?

like

Help me recreate a TB to import into Caseware. I have 7 entities, and 3 (4 for revnue) sub mappings. How do I recreate the trial balance for import? I need to pull for example columns 1) revenue 2) contract or non contract s… more

like

ChatGPT could make this bowl obsolete. See y’all in confession bowl

likefunnysmart

recommendations for using RegEx or RegEx-like features to find/replace confidential information (SSN, tel numbers, emails, names [no specific format]) *without* using a VBA macro?
I’ve gone through all of th… more

like
like

What it's an easy way to change border color on your own active cell when there is up four people that work from it simultaneously?

likehelpful

Be does anyone here want to help me start a campaign to steer Microsoft away from side pane navigation?

like

I am trying to create a formula that will look at an employees Total Direct Comp $’s against the market 50-75th %ile numbers and if it is 5-10% greater than than the 50th %ile of the market it would deliver a la… more

likehelpfulfunny

I’d like to know what I’m doing wrong with this VBA code, I want the data to refresh every 10 seconds. Any help please?
Dim Timer as Date Sub Refresh_Data()
A… more

like

I have a massive data dump from a client. Each row is a specific incident that: 1) occurred on a single asset, 2) either low, minor, major or serious level, 3) happened to an employee, customer or contractor, and… more

likehelpful

I would like to learn more about excel, if someone will let me pick there brain.

likesmart

Seems like a basic formula question. I need a formula that i will enter a specific value each month but need it to divide by a different cell in the same spreadsheet. I want to be able to show a subse… more

like

Hey all. Could use your help with figuring out a formula. I have a column with text and I want a formula to turn each cell into an acronym. So take "Long Island City" and make "LIC"… more

like

Hi

I need assistance with a task. I have an excel spreadsheet with rules for a platform. I have another excel spreadsheet that is an audit of how that platform is currently setup. Is there a way that I… more

like

Is there any way to figure out if one formula in particular is slowing down a sheet?

like

Hi! Need to plot revenue and headcount on the map (US). What is the best tool? Ideally, looking for those bubbles that would show the relative size of customer accounts

likehelpful

I made a YouTube tutorial on Sumifs targeted toward beginners. Anyone willing to critique my first video? In need of honest feedback. DM me your email and I’ll send a link!

Post Photo
likeuplifting

Any favorite, underused chart types in excel? Keep getting requests for "more eye-catching charts" from my manager so trying to change up a chart or two while keeping them useful

like

I've been asked to make a testing issue tracker. The challenge is that there's a many-to-many relationship between test cases & issues (i.e. a case would be impacted by multiple issues, & an issue can impact … more

like

Hello,

Does anyone know if Excel 3d map could filled in map for one state with several territories? I have tried and doesn’t work. If not, what mapping tool could do this?

Thank you for any input!

like

Hello,

I am a self-taught Excel user who has reached the limits of what those around me can help teach me, and the limit of knowing how to word what I am trying to do to be able to find an Excel tutorial for help. My boss has offered to pay for Excel classes, and I am more of hands on learner, so I need a class that also provides practice documents. Any suggestions for quality, thorough online Excel classes would be greatly appreciated. Thanks!

Post Photo
likeuplifting

Are excel exports either not working or taking a long time to download for others today? My partner and I (different companies) both are experiencing problems lol

likesmart

Has anyone used chatGPT or another genAI tool for formulas? Any success there? I've found mixed results mostly

like

Anyone have Excel ideas for the following problem:

Need to basically VLOOKUP multiple records within a comma delimited cell and return multiple matches in a comma delimited cell. For example: France = Paris, Italy… 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