We have about 80 locations within our company and we have both hourly and salary employees. How can I have the pivot table give me a count of both salaried and hourly employees at each location?

How is Publics Sapient for Java related projects??
Tell me in terms of Work life Balance
Learning Opportunities
Job Security

My accounting edge finance is not compatible with the new Mac OS. I do not need the $15/month subscription they offering as an upgrade since I’m a lone freelancer. I’ve always kept my own books and did my own taxes. Anyone else out there with a basic bookkeeping program recommendation for Mac would be appreciated.

I need help. I'm dealing with multiple losses in the same week and having a hard time... I took some time off from work but I have no motivation to do anything. I don't want to go back to work and don't care about my work right now. I want to quit but I don't want to make a rash decision but need a long break. It's also not fair to my team that I can't give it my 100%. What can I do?

Good morning! :) This isn't a job I am directly recruiting for but a friend of mine is recruiting for a client who is seeking an HR director. The only challenge here is the industry that the client is in. The industry is adult content site. Anyone interested? I hear good benefits and flex schedule. DM me and I can connect you with the recruiter.

Anyone else have issues with Virtue?

So. MBA from a top 20 program (if that matters), working in the southeastern US with 10 years experience in private practice and hospital administration. Salary thoughts?

Good evening Everyone, I have been a PSR for 10 years with the same company, but worked for 5 different practices. Was looking to move up in our company but from what I’m understanding, we have to have a degree in management. How would I go about trying to move up in and out of my position without a degree?

How is the IBM Consulting practice in Canada? How does it compare to the Big4 consulting practices, and what sort of projects/clients does it work with?

What's going on this weekend? Any fun holiday shops or pop-up bars I could check out?

Hi friends, my wife has total 10 years of experience and currently working as Salesforce CRM consultant in witch.
The role offered in Accenture is in team Customer Sales & Service Sales force, level yet to be decided
What should be expected fixed portion of salary.

How much time BNP Paribas required to release offer letter after document submission.

How much does AVP at citi bank gets paid in FRM - ICG in NYC? Currently a senior BA getting close to get promoted and unsure if it will be a good jump or if Im demoting myself

Anyone have recommendations for GCs? Looking to renovate a new home in Dallas.

How is the job security in Accenture?

Pay progression from SE to management? Was wondering what a typical SE manager makes because it’s hard to find.

If you were to lateral in the next month or so is it standard for the new firm to guarantee your full year end bonus given where we are in the year?

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

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

What are your top Excel ninja tricks? Ones that few people know...

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?

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Would anyone be willing to teach me vlookup?

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

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

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?

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.

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?

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?

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?

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?

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 🙏