tips and tricks

I have a sheet (Attached), where I want to change the value of the total billable hours to reach a target utilization, but it's not working properly, appreciate any pointers. A B C E F G H I J K From 1/7/2023 to 30/8/2023 Working Days Target Hours Available for Work To be charged...

Hi, I have a table that contains visit data for a number of clients. I want to be able to count the number of unique clients by month and year. i have searched online and have not yet been able to find a solution. an example of my data is below: Client ID Date Call Type Area 1 01/08/2022...

Hi all, For context, we use a spreadsheet to track the progress of specific work we do for clients. Each client has an assigned prepared and reviewer, and there are a bunch of steps in the process that we complete. This involves manually adding dates on the date that the specific task has been...

I have an excel master sheet in the below format: There are 29 subjects, however a student might opt for max 5 or 6 subjects out of this 29 and only those subjects will have marks data, the marks will be blank for the subjects which is not opted by the students. Only one school name is shown...

Hi, I have a table in following format Id Name Content 1 A asdf 2 A 4erwer 3 B rwerw 4 C 4353ds For this table I want to create a Visualization Filter, where Filter should repeat A twice since Id's are different. This Data is coming from different databases. So it is expected. Please...

I have problem when using period time like this : 201301,201302 etc. But when i using formula in powerpivot such as : Sales Previous Month, Sales Month last Year, YTD, MAT. And then after i tried conversion from yymm (201301) to date time (01/01/2013) its works. See the file for the details...

Question: Is there a way to apply print specifications (ie. portrait, 70% size) to all worksheets in a workbook 1 time as opposed to doing it for each individual worksheet? thanks! Blue Rhinos