I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

Hello! I’m looking for study materials for the PHR. Does anyone have recommendations for cost effective resources or perhaps willing to part with your study materials?

Any online services that diagnose adhd ? Based in the uk and the wait it weeks if not months.

Senior managers, at what age you got promoted to senior manager?

Hi Fishes,
I have 1.8 yrs Exp and working in the Big data domain and have a few offers please help to decide on the comparatively better option based on salary, Work-life Balance, security, and Carrer Growth.

EY GDS: CTC 12 ( 11.20 Fixed )
Publicis Sapient: 16 CTC ( 14.5 LPA FIXED )
Neudesic (IBM) 16 CTC ( 14.5 FIXED + WFH Remote Complete )
PubMatic: 22.70 CTC + 2 lakhs Joining Bonus ( 16 fixed LPA + Other benifits, stocks, etc )

It will be very helpful if you can suggest with some reason.

Traveling to NYC soon and I wanted to know what restaurants are worth visiting... I feel like I have high standards working in the hospitality business!

Best Chipotle location in the city?

I swear the quality at Chipotle has gone down. Not sure if it’s because I always order online for pick up? For me, it’s never made right and doesn’t taste the same. Any similar experiences?

D 🐟: What are the differences in benefits between Deloitte Advisory and Consulting?

can you help me evaluate this offer

BCG
Machine Learning Engineer 1
Yoe: 1 + master's degree
Org: Gamma X
Base: 120k
Signing bonus: 10k
Annual cash bonus: 20% of the base
Location: NYC

Anyone has idea about Capgemini g gurgaon location ? Which is the nearest metro ?

Hello. Has anyone successfully used the LazyApply app to find a job? Is it worth the subscription? Are the calls for interview from high or low quality opportunities?

Hello Team,
I had recently applied for Technical solutions specialist - Infrastructure.
Not sure why my resume got rejected.
I highly doubt the resume got rejected by some automation tool.
Is there a way my resume can directly reach to hiring managers?

Thoughts on this trade?

I get Derek Carr and Darren Waller
I give Tom Brady and Mike Gesicki

2 QB league, Russell Wilson and Matthew Stafford are my other QBs

2 QB, 3 WR, 2 RB, 1 TE, 1 FLEX

Best consulting companies in the social sector?

Literally all of my LinkedIn connections are recruiters lmao

PARTNERS: two questions —1. If you see an associate has really low hours for the month, do you imagine them chillen on a beach somewhere or do you consider they probably spent most of their days sitting in front of the computer being “available”? 2. If you send an associate a random e-mail on a weekend like “Can you pull X and send to Y”, would you get annoyed if they responded saying they weren’t by a comp or would you consider it reasonable that they wouldn’t be by a comp on a weekend?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?