- This topic is empty.
March 11, 2013 at 3:18 am #68594
PLEASE GUIDE ME HOW TO HIGHLIGHT/CREATE IN INFO PAGE(OR ANOTHER SHEET IN XLS.2007) OF YOUR CREATED SCHOOL MANAGEMENT UTILITY LIKE AS ‘STAFF’,PAY BILL’CTC.DON’T MIND SIR ONE HIGHLIGHTED OPTION(‘AGE CALCULATER’ WITH BACK GROUND COLOR BLUE)IS DELETED.March 11, 2013 at 11:41 am #77311
Dear Mr. Sajmal,
In response to your query I am to say that it is a very easy task to create another page in the same manner. Right Click on any sheet of your choice at the bottom that page , then move or copy then choose the sheet from drop down list and then create copy.The same copy will be created instantly. If you want to create other pages like ‘Staff’, ‘Pay Bill’ .right click on the bottom of any sheet, then insert work sheet, rename the sheet by using right click button.You may use Shift key + F 11 for doing the same.
Debabratada.April 3, 2013 at 2:59 pm #77600
Dear D. P.
Please guide us step by step so that all the willing persons may get conception to create such utility.
With regards.April 4, 2013 at 4:05 pm #77614
Please share your questions one by one, so that we can help you according to your need.April 8, 2013 at 4:58 pm #77691
Respected Debabrata da……………… jibane anek kichhu chesta korechhi………kintu ajke mone hochhhe, kichhui janina…..ekbar katha bolben…………..khobei darkar………………SwapandeApril 9, 2013 at 7:54 am #77697
Respected Friend !
I want to creat an “Excel Utility” by which I can able to prepare some auto generated certificates like ‘TC’, ‘Pay Sleep’, ‘Progress Report’ etc. Can you please guide me how to creat it ?
Please ignore if I claimed impossible matter.
With best regardsApril 9, 2013 at 4:14 pm #77707
Just take the reference of Debabrata Pal’s “School management Utilities” and tapas99’s “Class V assessment register” and modify as your need. I am also uploading TC certificate ( Coursey: Debabrata Pal and Torkona). Merge all in one excel utility and your work will be easier.April 10, 2013 at 12:45 pm #77717
T.C: https://wbxpress.com/topic/find-and-replace-in-excel/ (by chanchal)
VI: https://wbxpress.com/topic/assessment-register-class-vi/ (all by tapas999)April 11, 2013 at 10:21 am #77736
Dear Mr.Swapan De
If you want to talk to me , contact over telephone by using the number:
Debabrata Paul.April 17, 2013 at 3:10 pm #77804
Just take the reference of Debabrata Pal’s “School management Utilities” and tapas99’s “Class V assessment register” and modify as your need. I am also uploading TC certificate ( Coursey: Debabrata Pal and Torkona). Merge all in one excel utility and your work will be easier.
some correction in my previous post.June 19, 2013 at 11:11 am #78153
Hi friends ! I want to know the formula about retirement gratuity & Death gratuity of WB Govt. Employees for putting in exel sheets. Will any one help me pls.June 21, 2013 at 5:38 pm #78166
Dear Pkk, as per your request, I am uploaded a automated retiring & Death gratuity calculation with bill,outer,extract etc. It may be helpful to you and others.June 24, 2013 at 6:06 am #78168
Thanks for the UTILITY. The Joining date into the Govt. Service is upto 1990. I need more. I also want to know the formulas which you have put into the xl sheet. So I am requesting you to give me the unprotection code for the sheets or pls explain the formulas.June 24, 2013 at 12:41 pm #78169
Ok, Pkk, I have made some correction.June 25, 2013 at 7:48 am #78175
Thanks. In the Bill Extract the Name of Controlling Officer is fixed. Pls Rectify.June 25, 2013 at 6:20 pm #78182
Thanks Pkk for your valuable observation. Now, I have rectified this problem.June 26, 2013 at 9:40 am #78183
Hello, Mr.nhoque ! Will you pls share with me the formula which you have put for calculation of Qualifying Service automatically in the xl utility.June 26, 2013 at 6:22 pm #78190
Sorry, Mr. Pkk, the matter of qualifying service is very large calculation. I cannot explain this formula in a word.July 9, 2013 at 8:01 am #78241
Hi Friends ! Will any one explain “How to Hyperlink with Print preview” ?May 4, 2014 at 8:05 am #79466
In a excel sheet in a particular cell i want to entry either Group A or Group B or Group C. can you plz help how can i do this?
- You must be logged in to reply to this topic.