Search results

Hi, I don't know why but I am having difficulty even getting started on this task. I was asked to chart an employee's planned work effort against the employee's actual work effort over an entire year. As an example, employee A states they have the following planned work effort. There are 40...

Hi, I am looking for ideas on how best to present the following data: over 200 employees 6 different degree types: HS; GED; Associates; Bachelors; Masters; PHD 47 different fields (of study): Accounting; Biology; Math; etc. I plan on showing a bar chart that details number of degrees...

uploading file ugh..no option to even upload a file on this thread..please delete this

Hi, I have a list of employees with their job level and years in their job level. I would like to rank each employee within their job level, with the longest in their job level being the highest ranked, and each job level's ranking starts where the previous job level ranking ended, meaning some...

Hi, I have done this so many times in the past it is second nature. However, for some reason I am now having an issue. Is it me? Am I forgetting a step? I have 135 employees assigned to 4 groups, and the 4 groups are further subdivided down into 15 different organizations. I sorted the...

Hi, 1st, I appreciate the help. I continuously have difficulties with conditional formatting. And, match & index, but that is for another post. Today, my issue is with conditional formatting. Here are the 2 scenarios: 1) a 3-column Excel 2010 spreadsheet: A) Name and B) Expiration Date and...

Hi, I am trying to use conditional formatting to do two separate actions: 1) color the cells either red, yellow, or green, and 2) use the red, yellow, and green stoplight icons This will allow the user to choose which view they want to use. This is using percentages as follows: cell G1 is the...

Hi, I have a few questions about slicers. 1) Is there a way to quickly scroll thru a long list in a slicer? I have one slicer that has over 100 options and I have to scroll thru them all to find the one I want. Of course, I can always go to multiple columns to solve the issue but if I want...

Hi, 1st, I had enrolled previously but could not remember my user name, my password, nor could I find the email sent to me with that info. So, I created a new user name in the belief I would be notified that the email address was already in use, my new registration would be stopped, and I...