viveknetan

"Greetings All, Income Tax has announced that the employer can issue Form 16 with a Digital Signature vide CIRCULAR NO. 2/2007, DATED 21-5-2007. Today, I downloaded the Form 16 with digital signatures and found that it is showing an error "signatures not verified." Here are the steps to be followed fo" ... (more)

"Greetings all, I am facing a problem and request your assistance in finding a solution. I need to calculate the utilization and availability of an equipment. Let’s consider the following scenario: Shift hours for a month = 300 Work hours = 147 Breakdown hours = 21 Idle hours = 300 - (147 + 21" ... (more)

"Greetings All, If you are working in an organization and you have a lot of equipment/vehicles, and you want to ensure timely servicing of your assets, then here is my sheet for you to schedule your service." ... (more)

" We can create a shortcut for the same! I have made it this way! The ALT key along with the ~ key is the combination that works fine. Regards, Prem Yes, ALT+~ symbol works for the same, but we have to choose the Rupee Foradian font every time." ... (more)

"Greetings All, This post is about how to get a warning with colorful formatting in Excel if your results are crossing the budget limits. I have taken the example of fuel norms, and you can change it as per your requirements." ... (more)

"Hello Vivek, Thank you. This works fine with MS Word. Please tell me how do I get the Rupee Symbol in MS Excel? As per your requirement, there is no shortcut for the Rupee Symbol in MS Excel. a. Open the zip file containing the currency symbol in Excel attached here. After extracting this file, you wil" ... (more)

"Greetings All, Excel has a lot of possibilities, and one is Graph. We can create a graph as per our requirements. Graphs look good if there is a large amount of data. A few days back, I faced a problem where I had to display an increase or decrease in Excel. I tried a lot, and then I found this hand" ... (more)

" No doubt, it is a good effect. Why not add wage/salary calculation in another sheet? Please update and attach, as it is more useful to all. Additionally, you can include the total number of days along with leave, which is referred to as payable days in the month. Thank you. As per your suggestion, " ... (more)

"Greetings all, I frequently use MS Word, and whenever I have to choose the new ₹ symbol, I have to complete a typical process. For example, I have to select the Rupee Foradian font every time I need the ₹ symbol. After many attempts, I have discovered a new trick to use the ₹ symbo" ... (more)

" I cannot open the workbook properly. All I am getting is a number of characters but not a proper worksheet. I am using Office 2003. What version is this xls using? Dear, I am again uploading these files, and now they are in .xlsx extension (Office 2007). However, you are using Office 2003, so you hav" ... (more)

" Greetings sir, I can’t able to open this file. Kindly resend the format freshly as I am very interested in this. Regards, L. Saravanan I think you are using MS Office 2007 and this sheet is created in a lower version. When you open this sheet, Excel will show a warning message. Click "Yes," an" ... (more)

"Attendance sheet for a small organization. In my sheet, you can easily calculate present days and leave days. Waiting for your suggestions." ... (more)