I know this should be easy but I haven't had luck figuring this out online. I have a pivot table, in the rows I have Group name, in the values I have count of another column that marks tasks complete. I want to create another column that shows the percentage of tasks complete per group. I know I need to create a calculated field, but nothing's working 🥲 please help!

My challenge to everyone of you. Every leader, every future leader, everybody who will lead this industry one day: when we get back to normal, whatever that will look like, get personally involved again with recruiting, hiring and mentoring. DO NOT leave personnel decisions to HR, alone. DO Not rely on the parasitic temp agencies like creative circle and Aquent to do all the work. Get involved. Give a damn. A creative leader saw value in me, l assume someone saw value in you too. Pay it forward.

I got an offer for senior Salesforce associate for support project. The skill set mentioned was LWC, apex and configuration. Wanted to understand how the work will be for Salesforce support in PWC.

Can anyone confirm, if hpe take Hacker Rank test for senior cloud professional after 2-3 rounds of interview

I have 1.8YOE Current Packages is 5.5CTC
How much i can expect from informatica if i switch ???
How about joining bonus

what is notice period or leaving GDS -Sat service line

Is there any onsite opportunity in EY GDS for Client Technology line
If yes what's the process.

I have valid H1B petition how can I get it transferred into EY?

How to book seat for office at Pune location?I am a new joinee and planning to go office once in a while.Kindly help guys

I equally can't tell if this firm likes having me or wants me to quit.

What should be the ideal package for a SAP ABAP consultant experience of 5 years?

What’s a good amount of time to be at the senior planner level?

Are there any Freelance Motion Graphics Designers/Animators here?

Want to start saving/investing from this year. Got £11K and will have £2K a month to invest - any recommendations? I don’t want to take crazy risks, somewhere where this is steady long term growth. Have already maxed out pension and I assume next step is maxing out ISA? After that, what is best? (From UK)

Hi folks,
Anyone claiming commute expenses under Mileage for larger distance? Even in Hyderabad, my home is 25Kms from office.

Hi all

I am looking for a referral for switch on a position of Business Analsyt.
Currently in my role I work on MySql scripts, testing, analysis and documentation.

Current exp - 1.3 yr.
Current company - TCS

Fun Fact: Tuesdays are most productive. Maybe it’s because we’re motivated to get more work done to get the week to go by faster or because it’s the day with the least absenteeism, but Tuesdays are the most productive day of the week for American workers.

Generally curious about this years incoming batch of undergrads. What is your role and starting salary? Lots of HR laws ( CA, NY) and inflation this year so curious to see if people were able to use this to their advantage etc.

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.

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

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 😭

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)

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 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?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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 🙏

Hi there,
Which Excel courses you recommend for a beginner?

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?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

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)?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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?

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?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?