Excel Data Analysis Example: Bar Chart, Crosstab Table, Excel Function Example

Create a Bar Chart to show the overall sales by the different staff for the month

Create a Bar Chart to show the overall sales by the different staff for the month(b)Create a crosstab table to show the average salary of staff (Row) and Staff Grade (column).(c)Use the excel function to count the number of staff with Gross Salary less than $3000. (d)Use the excel function “SUMIF” to compute the average Gross Salary for staff having the ageof60and above.