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

Can you practice for leetcode without knowing how to code?

happy deepavali makkale :) I am missing home very badly now , hope you all have a lot of fun.

What impact has the prestige of your school had on your career?

Hey
Is WFH permanent at SDC?

Hey fishes,

Help me to choose out of the below .
1) U.S Onsite from current company with 74k
2) Offer from EY, TCS with 13lpa package

YoE : 4.5
Tech stack : Data science, Python (1yr)
Current CTC: 5.5 lpa

Currently interviewing at JPMorgan in their CIB division for a associate operations role. Have met with 5 people for two different teams and another person for another team, all of which I believe are 3 total open positions for 3 different teams. Any insight on the interview process or how long it takes or any sort of idea to give me on what I could look for that might help me believe I might get an offer? Checked my online application again recently and still says “In Consideration”

What is the salary structure in verizon?

Hi Everyone,
How much Databricks(Company) can offer in India for Data engineer role with 10 YOE

Trying to get into a big, famous shop. But everything good dies at smaller shops in my town (not NY or LA) bc of the client or CDs that never made it. Feel like I’m stuck in a loop 🔄

Tired of this constant grind and constant layoff situation in NYC. Thinking of making the move to LA. Any thoughts? Yay or nay?

Can someone help me with the ServiceNow ITSM dumps?

Experience:7.9 years
Profile: python automation testing
CCTC: 11LPA
How much CTC can I expect in HCLT please anyone suggest.

A promotion from analyst to senior analyst OR analyst to associate OR analyst to consultant should increase your salary by what %?

Scrum Master with 3 YOE, 1yr in agile. Technical background. Secret clearance and working in Federal. Two in demand certs (SAFe SSM & SGP). Currently making 103.5k in DC. Realistically what is the highest I can negotiate for at competing firms?

Let's talk about Stranger Things S5 predictions!!! I think one of the main characters will get killed off. My bet is on Eleven but that may be too obvious. Wbu?

How is everyone feeling about the market today? Buy? Sell? Wait?

Which offer would you choose? Current comp is 110k.

1. LinkedIn: $130k TC, client facing role
2. Health tech company: $150k TC, marketing strategy role

Debating if the brand prestige/benefits of LI are worth it versus a no-name company with higher pay..

How are the hikes at @UBS

My company IPG, IPG health/ FCB health is hiring, if you’re interested, curious, need a referral. Please DM me and I’ll be happy to assist :)

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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.

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?

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.

How long did it take you to become good at excel? Like fast?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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 🙏

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

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?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..