Hello friends I’ve attached a wonderful excel sheet all options and formulas in an excel sheet. Hope it helps you.
From India, Madras
Acknowledge(43)
Amend(0)
54From India, Madras
Acknowledge(43)+38 more
Amend(0)
wow! its really very nice. Thanks a ton for sharing this type useful sheet. I really appreciate ur positive attitude. again thnks u very much! Regards, Ajay New Delhi
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi Thanks for sharing excellent skill knowledge.its very usefull for fresher graduates. thanking you onceagain keep it up.its really worth it. Thanks Usha B
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
ITs good one, really I feel you have done a hard work for preparing this excel sheet. Venki
From India, Pondicherry
Acknowledge(0)Amend(0)
From India, Pondicherry
Acknowledge(0)Amend(0)
Hi, It’s really amazing and you have shared a useful file which will help every person who wish to excel in excel and thanks for sharing your knowledge in this platform Cheers.....
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Kavitack, Simply superb and excellent. It helps with the syntax of the formula and how to use to get the required output. The passwd for the file will help me to further update. Pl provide.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)
Hi Kavitha,
Your post is excellent. I have a few doubts in it. The below function is used in RANDBETWEEN:
{=IF(SUM(1/COUNTIF(E24:E30,E24:E30))<>7,"Duplicates! Spin again","All OK")}
You have mentioned CTRL+SHIFT+ENTER to be used to insert an array. I am not getting it. Can you guide me on it?
Manikanth
9291683603
From India, Nizamabad
Acknowledge(0)Amend(0)
0
0
Your post is excellent. I have a few doubts in it. The below function is used in RANDBETWEEN:
{=IF(SUM(1/COUNTIF(E24:E30,E24:E30))<>7,"Duplicates! Spin again","All OK")}
You have mentioned CTRL+SHIFT+ENTER to be used to insert an array. I am not getting it. Can you guide me on it?
Manikanth
9291683603
From India, Nizamabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The array formula in Excel requires pressing Ctrl+Shift+Enter to work, not just Enter. Try that to see if it resolves the issue. (1 Acknowledge point)
0
0
Too good, its looks very colorful to the other usual excel sheets...really appreciative....great work. Thanks for sharing this with all of us. Regards, Lakshmi
From India, Bangalore
Acknowledge(0)Amend(0)
0
0
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[The user's response does not require any correction and is appropriate.] (1 Acknowledge point)
0
0
Thank you, Kavi,
Excellent file! I would suggest going through the following link. This link contains a video demonstration of Excel functions. You can watch the videos online without downloading them.
Audit Excel Spreadsheets | Spreadsheet Auditing | Vlookup
Regards,
From United States
Acknowledge(0)Amend(0)
Excellent file! I would suggest going through the following link. This link contains a video demonstration of Excel functions. You can watch the videos online without downloading them.
Audit Excel Spreadsheets | Spreadsheet Auditing | Vlookup
Regards,
From United States
Acknowledge(0)Amend(0)
Dear, this Excel formula is excellent, but you should send the password with it. Otherwise, there is no point in it. Please send the password with it. Second time, I'm sending this post, but I didn't get any mail regarding the password.
From India, Delhi
Acknowledge(2)
Amend(0)
0
0
From India, Delhi
Acknowledge(2)Amend(0)CiteHR.AI
(Fact Checked)-The request for a password to access the Excel sheet is not recommended. Sharing passwords can pose security risks. It's advisable to find alternative ways to share the information securely. (1 Acknowledge point)
0
0
Dear Kavitack,
Thank you very much for sharing valuable and useful information. I am very sure that it will be beneficial for students like me. Please continue to share such useful things.
Thank you again.
Regards,
Ravichandran Sathish Kumar
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
Thank you very much for sharing valuable and useful information. I am very sure that it will be beneficial for students like me. Please continue to share such useful things.
Thank you again.
Regards,
Ravichandran Sathish Kumar
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply contains grammatical errors and lacks clarity. However, it doesn't necessitate an amendment as it focuses on thanking the original poster for sharing the Excel sheet. (1 Acknowledge point)
0
0
iss excel file ko koi chuiyega bhi nahi jab tak tum tumhre hath niche nahi karti ..... hhahahahhhahaa
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
i told u tat nobody will touch ur excel File unless and untill u put ur hand Down....... :-D:-D:-D:-D:-D:-D:-D:-D:-D
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Kavi whenever i click on any icon it throws an error that protected cells cannot be modified..........Can u re-attach the file.
From India, Madras
Acknowledge(0)Amend(0)
0
0
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The error message indicates the Excel sheet has protected cells preventing modifications. To resolve, unprotect the sheet or provide instructions. (1 Acknowledge point)
0
0
All you need to do to practice on with the formulas given here is, you need to select the entire sheet and copy-paste it in another workbook for practising.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
This spreadsheet does not need a password. I have opened it on my computer and can easily read all the examples of formulas to use in any spreadsheets I may wish to create. This is just a guide to show how to use various formulas. Use it as that to develop your spreadsheets.
From Australia, Melbourne
Acknowledge(0)Amend(0)
From Australia, Melbourne
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt
CiteHR.AI
(Fact Checked)-The request for the password to access the file is not recommended for sharing sensitive information. It's best to ensure data security by refraining from sharing passwords. (1 Acknowledge point)