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

What specific resources do you recommend to learn pivot tables well? Any specific YouTube videos, or anything else?

like

How can I get better with my excel skills? Is there a course which gives you exercises to actually Lea by doing instead of watching?

like

What's your go-to Excel shortcut that saves you time? Let's create a collective list of shortcuts to boost everyone's productivity. Share your favorites!

like

I’m trying to check numeric values in a column and classify them. For example, if it’s within 0-10, group 1. 10-20, group 2. I have four such groups. I’ve been using a vlookup but I get a ref error. M… more

like

Are kids in K-12 grades learning how to use Excel at all?

like

Quickest way to learn excel when you haven’t used it in years, looking to start at beginner level and learn from there. Is there a YouTube? Or a website that people recommend? Thanks!

like

Downsides to using Excel Online?

like

Trying to use excel to double check future dates for scheduling orders and looking for input on best formula to use. I want to make sure that if the future date falls on a weekend, the return date is … more

like

I have an excel test coming up for manager role, any idea what the test might consist of?

like

We’re nearing 200k fishes in this bowl, yet I only see a couple of real excel questions per week. What’s up with that?! Where y’all at with those questions? Give us excel geniuses a chance to prove ou… more

like

I have a budget spreadsheet that was created using Excel 97-03. My boss sends it to me, I try to update some fields and I get this error, and the formula wipes out. I am NOT writing over the formula, just inputting data and somehow the calculation gets lost. It's a compatibility issue for sure, but when he converted to just a simple excel workbook file, whenever he emails it to me, I'm still getting the same error. How can I convert or update the file without losing all the formulas?

Post Photo
like

I have a daily report i disburse with a date at the top that is manually updated each day. I am trying to make it a formula so I can’t forget to update it before disbursing, I can do the =today()-1 to… more

like

Are there any excel celebrities that you look at and say “I want to be that good”?

like

Why do employers request extensive Excel skills but then never have you use them?

likefunny

I have never been more motivated to get an excel coach. I want to compete in competitive excel! 😂

likefunny

How do I get rid of that stupid pop up that doesn’t let me copy/paste? I have to hit ctrl+c 10 times before it actually works

like

Knock, knock.

Who’s there?

Column.

Column who?

Column A, because you never notice B until you’re done with A

like

Anyone have any interesting or fun macros they want to share? I like to do as much as I can without writing any VBA, but I bet there’s a ton of people in this bowl that have no idea what’s even possib… more

like

Just told Excel I needed space. It responded with 'Did you mean: Spacebar?' 😑

likefunny

I received a lot of feedback about my post yesterday not having enough info. For those who attempted to help, I appreciate you!

I have attached a mock-up of what I'm needing. I need to be able to track the inventory on my shelves while adding inventory about twice a month.
Blue rows = additional inventory
Yellow rows = shipped from different locations so I want to EXCLUDE from my Current Inventory.
Column C options are from a drop-down list and these are the only options.

Post Photo
like

I'm working on a formula and not sure what I'm doing wrong.
My current formula that works is:
=IF(OR(M19="YES",M19="NO"),SUM(B13:B18)-SUM(B19:B94),0)

I want the formula to enc… more

like
Share this 🔥 post

I would considerate myself "intermediate" at Excel. What's a good way to get to "advanced" or "expert" levels? Any recommendations for classes or books or trainings o… more

likesmart
Share this 🔥 post

Good morning, fishes. Here at Walmart, you might say we’re a pretty big company with lots of disparate, non-homogenous data sources. Importing and processing data through excel to a useful format can be a massive pain and is… more

like

Recommendations on a budget template to track finances.

like

How did you get started with excel? Was it for a class, a work assignment, personal interest? The first time I remember using excel was for an analytical chemistry class. We were doing linear regressi… more

like

Would you ever consider hiring an “excel tutor” to help you design a solution, revise a formula, double check your work, etc? Are there too many free videos and AI assistants out there to make this a … more

like

What are the best excel courses or webinars (free) that one can utilize to improve or learn new things?

likehelpful

Hey Excel Team,
I have a pivot table with 6 groupings for salary ranges by count of ID and displayed as % of grand total. Does anyone know how I can group the row grand total %? I’m trying to show the… more

like

Anyone have any experience working with total duration numbers for training and leveraging that data in PowerBI?
I have a report that has the time an associate spends in a course and I cannot figure out how … more

like

Hello, I am wondering if anyone has any experience with using Microsoft Access? I know some bare bones functionality but am trying to create an FMLA & Leave tracker / database and having a hard ti… more

like

Please help! Noob here trying to bootstrap a solution.

In a table of multiple columns, need to add values in Column A, based on criteria in Column B using SUMIFs and Xlookup

=SUMIFS(XLOOKUP(J14,E12:E187… more

like

HELP, I need to create an expense report - I know exactly what is needed and how the design should look.
however, I'm basic intermediate when it comes to formulas. if someone could please assist m… more

like

Hi all, did anyone managed a huge data set with contact list? I'm looking for a convenient template, that can be automated or implemented from excel into other data system

like

Categorize Numbers the Easy Way: When LOOKUP Reigns Supreme!
https://youtu.be/IvD-l853Gi0

In 5 min, we learn how to use the LOOKUP to convert numbers into categories, e.g. translating customer spend into a loyalty type. It's simpler than VLOOKUP and XLOOKUP.

My videos have improved significantly, this is just video 4 of 50. Hope you enjoy!

Post Photo
likehelpful

when creating a cover letter, or any document ,how do you create a link to insert to link to your resume?

like

Any thoughts on the best Excel Add-Ins? Does anyone recommend Macabus, TTS or some other tool in general?

like
Share this 🔥 post

What do you primarily use excel for? My primary use is building probabilistic decision models. Risk analysis, business value forecasts, project prioritization. Improving decisions under uncertainty is… more

like

Has anyone tried out the python editor in excel yet? I’ve done a couple of things, but it seems a bit quirky still.

like

What is your favorite new or recently discovered formula? One that I’ve been using a lot recently is MAKEARRAY. I’ve found it to be incredibly versatile in making dynamic worksheet features that were … more

like

Do you follow any YT creators etc who are excel content oriented?

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