Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

My excel version is old 2007 so some features r not there.

so to answer that question which i cant do in excel i m writing here

d.

To make customized ribbon

go to option of excel then click on new tab and your choices accordingly.

i.

to separate text

add new column accordingly

use textsplit()

select u want to split and then select the first word u want to separate.