CHATGPT in Excel

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.1
Give me a 20 rows sample data in table format where first
column must me employee id then second column must be
Indian employee name third column must be gender fourth
column must be birthdate of employee fifth column must be
employee annual CTC

This Course is Created by Satish Dhawale 7 Silver and 1 Gold Button Award winner From YouTube (16 Years Experienced in Microsoft
 Question No.2
Ok thanks for the Table of sample data now I have copied and
paste this data into my excel sheet Where employee id is
appears in A column now I want to make sum calculation first
of all tell me that how do I Change currency format of
Employee annual CTC from dollar format to Indian rupees

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.3
I have Follow the above steps but problem is that Employee
CTC has comma inside the number and $ sign is also not from
the currency format it is a character over there so I want to
remove comma from the CTC and also remove the $ sign so
tell me that how to remove this two things from employee CTC

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.4
Great guidance so far now I have got the new values in F
column I wanted to paste these values into E column but
there is formula inside F column so that's why I am not able
to paste it properly so tell me that how to paste it so that I
should Get F column values in place of E column.

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.5
Yes I did it but there is green mark on cell of E column and
it shows several options like number sorted as a text,
convert to number, help on this error, ignore error What
should I select from these option

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.6
Done, Now I wanted to get total for E column in Cell F1 so
what will be the formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.7
Now I wanted to calculate total Male and Female gender
CTC separately so what will be the formula?

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.8
Wanted to calculate CTC of employee who those are born
before 1990 so what will be the formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.9
Now I Want to calculate CTC of employee who those are
born before 1990 and they are Male so what will be the
formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.10
To count the total number of employee those who born
before 1990 what will be the formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.11
To count the total number of employee those who born
before 1990 only female employees what will be the
formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.12
I want to Count the employees whose age is below 30 so
what will be the formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.13
To Count the employees whose age is below 30 and they
should be Female so what will be the formula

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.14
Count the employees whose names is begins with "S"

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.15
Give me the total CTC of employee whose name is begins
with "A" and gender should be Male and they should born
after 1990 also add one more condition that is take CTC of
those employees whose CTC is greater than 60000.

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.15
Now tell me the formula to calculate the age of every
employee

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.16
Above formula is little bit correct but I want to calculate
complete year, months and days too so what will be
formula because above formula is showing only year

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.17
Now tell me the steps to highlight entire row with color
whose CTC is greater than 70000

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.18
I want to add one more column in my existing table that is employee
joining date so generate sample column for this but show employee
joining date between January 2017 to April 2023 year and remember
do not generate entire table with employee name, gender, etc. only
generate joining date column for 20 employees

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.19
I wanted give bonus salary to employee based on following
condition, If employee is working with us more than or equal
to 5 years then 5% bonus on their CTC if he is working with us
more than or equal to 3 years then calculate 3% bonus on
CTC and for the rest of the employees give 1% bonus on CTC

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 Question No.20
now give me the count of the employees who those are
working with us from last 2 years

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)
 VBA CODE QUESTION
Now give me the VBA code which will display the
employee list those who are working with us more than 2
years and list should be display on new worksheet.

This Course is Created by Satish Dhawale (Founder of CoursePe – 7 Silver and 1 Gold Button Award winner From YouTube)