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?

Did you change anything on your resume when you have 2 FT jobs?

Does anyone have any insight on picking up a J2 while working for the US Federal Government? Does holding a high security clearance play a role in maintaining a J1&2; as in, will periodic clearance checks for J1 hit on J2?

How many of you that have been in PA for at least 10 years feel like you are a well rounded individual? Is your personal identity only about your job, status, and wealth or do you have enough contd

Pros/cons of government clients? (US Army, USPS, state lotteries, CDC, etc)

Has anyone heard anything new on the future of MDC and its agencies in 2019?

A friend of mine and I are both starting our life firms from scratch. We both do two different areas of law. How can we help each other with referrals and networking? We live in an area that’s pretty geographically large in two different parts of town.

Hi All, Need some help deciding an offer for IT Audit Senior Internal Auditor Role

1. Job A - 90K + 3500 Fixed Bonus + Unlimited Leaves
Industry Based Role

2. Job B - 84K + 12K Joining Bonus + 20 Leaves Please help.
Big 5 Consulting Role

Any opportunity in Gl in .Net position having 5.2 years of IT experience and 3.8 years experience in .net.

I feel like Orrick has such a good rep but in here people seem to complain a lot. Anyone know anything about TCG or corporate?

Becoming less and less interested in continuing with the CPA exam. Staff 2 studying for a year with 0 exams passed. What're my options without finishing? I don't think I will actually be able to pass.......

Friendly reminder folks- don’t work for Havas Health and You. They cut the freelancers hourly rates, again and made it so there’s no OT. The resource manager at HOV said if I couldn’t swing $80 an hour as an HCP copywriter, she’d have to find someone else. Good luck 👍🏻

How do I sell a product which is not required in the market right now but would be really great in the future (software). Having lot of troubles getting meetings

Does Bank of America have a car lease policy ? If yes, which band are eligible for the same ?

Can anyone help me with salary range of Associate Delivery Manager?

Hello friends,

How is stratacent as a company to join?

Thoughts on leaving PA primarily due to the metrics based culture (utilization, dtc, use of X digital tool, revenue, margin, etc). I find this aspect of PA stressful and exhausting but not sure if this is something you just get used to. Currently a manager and seems like the metrics just change over time / don’t get easier.

How do MBAs feel about doing one year consulting then a year in industry strategy analyst role vs 2 years consulting?

Recent admit here - how important are these pre-MBA Virtual networking sessions? Feeling like it’s hard to network virtually.

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 🙏

How do I compare two sheets to make sure they are identical?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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?

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 set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

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?

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

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!

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!

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

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?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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?