Get instant live expert help with Excel and Google Sheets

I need to create dashboard containing 4 charts(pie or histogram or any) and pivot table data

Business Spread sheet. Need Help Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.

I have a list of Entities that each need a number of the same item. Some need as much as 72 of that item, some only need 1. I can only deliver 72 of that item per day, so I need to find a way to sort this list into asymmetrical groups where the total number of items needed per group is as close to 72 as possible without going over.

In column I, enter a formula to calculate the insurance charge if the renter has elected insurance coverage (Yes in column E). Use the furniture’s group code and the Monthly Insurance column in the RentalCharges table to look up the insurance charge. Remember to multiply the monthly insurance charge by the rental period. If the renter has not elected insurance, the cost is $0.

Need help with several vlookup and pivot table questions.

Hi, i have a spreadsheet which has 3 columns a = date b = time of day c = numerical result from a machine monitoring air pollution d = word describing where the person is at that time point i am trying to do two things 1. work out how long each person spends on each activity/place 2. work out total sum of the pollution monitoring for each activity i have tried sumif but it doesn't seem to work?

Write a formula for me that goes something like 'if cellA is in this range (between cellX and cellX*2), then 1. if cellA is in this range (between cellX*2 and cellX*3), then 2. Its a formula to increase '# of employees needed' based on sales volume (cellA) and hours worked capacity per 1 employee (cellX).

While trying to substract multiple cells ''=H13-H2:H12'' (=*a cell*-*bunch of cells*) doesnt work while ''=G13-G2-G3-G4-G5-G6-G7-G8--G9-G10-G11-G12'' works. Tried it the same way in google sheets and it worked.

Hi, I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2). =(G4*G2)+(H4*H2)+(I4*I2)+.... Colum marked PROBLEM How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)

I currently have a large worksheet with over 7,000 cells. I have listed regions under a column i named "Location." In that column I want to change the region from lets say "Eastern North Central" to "US-Midwest," "Mountain" to "US-West" and so on. Is there anyway I could use a function to enter under my location column so all regions change to my desired classifications so i don't have to manually change over 7,000 cells? Perhaps some convoluted IF function?