Here you will get some useful Excel templates and formats to download.
SIP Calculator:Calculate the maturity amount of SIP or compound interest investment.
Currency to Word converter: Indian currency to word converter. You can copy paste the whole sheet and use this in the back of your sheet to convert currency to word.
Invoice format with new invoice button: Just the invoicing sheet you want. Edit the original invoice sheet as you want and keep it empty from data and intact. Bill a customer every time and press the new invoice button to generate a fresh invoice sheet. Don’t forget to enable Macro after opening.
Salary Slip Format: This is an useful employee database and salary slip format
Employee Birthday Reminder: This is an useful employee birthday reminder from employee database. Just update the employee database as requirement and change the data source of PivotTable. (See Lesson 56)
Employee Attendance Sheet: This is an useful employee attendance sheet with employee database and salary calculator.
Monthly home budget planner: Plan your monthly home expenditure here
Day wise monthly budget planner: Monthly home budget planner day wise
Travel budget planner: Plan your travel budget here.
Day Wise Project Schedule: Day wise Working schedule or a auto updating gantt chart made by formula and conditional formatting. Put the start date and end date of activity and see the bars automatically updated.
Month Wise Project Schedule: Month wise Working schedule or a auto updating gantt chart made by formula and conditional formatting. Put the start date and end date of activity and see the bars automatically updated.
Scope breakup Schedule: Copy the whole formula row every time because the first cell of chart area having different formula than next other cells. This sheet automatically breakup scope of activity with your schedule. Put start date, end date and scope.
Month wise project schedule (Advanced): This is an advance project schedule. If you put a start to start or finish to start relation with other activities then it shows the activity. For more details click on the link.
Calendar for showing any month you want: See the whole month calendar of any date you want
Age calculator: Age calculator or date difference calculator
20X20 graphical multiplication table
Calculate value of word
Name separator: This sheet contains formula by which you can separate first name, middle name and last name from a full name.
Master word separator: This sheet contains a master formula to separate nth word from any sentence.