Free Excel Templates

122 thoughts on “FREE Excel Templates (Download)”

1. I am interested in your timesheet template, but would want the Salary in Pounds Stirling and lunch break would be paid. is this possible to alter.

2. great

3. How to link real time stock prices to excel sheet when making a portfolio of investments in excel?

4. Thank You Trump…Ur Excel Reference Is Assume…

5. WANT TO SET UP A DAILY AVERAGE IN EXCEL TO RECORD INDIVIDUAL AND AVERAGE

6. hi sumit glad to find you in the internet
   i need a gantt chart template in order to track a production line. we are a refinery factory so all the process are one by one. do you have any idea how can i plan all the process?

7. Hello Sumit, have you ever received a request to create a Rental equipment tracking sheet? Looking for one to track IT loaner equipment such as a laptop, desktop, keyboard, mouse, projector etc. Are you able to help, please?

8. very nice collection it’s very helpfull

9. Hi do you have a template for finance management .. I mean credit vs debt and monthly expenses and savings something like that.

10. Sumit Sir,
    I need your help in developing a tracability matrix.

11. Thank you for the Leave Tracker. Can we calculate the leave hours instead of days? Sometimes employees take 2 hours for an errand or a Dr.’s Appointment. The sheet calculate by days. How can I change to hours?

12. I love what I’ve seen so far! Do you have a template that shows cost savings (monthly & annually)? A place where you can keep track of areas of current costs vs. cost savings over time per client and/or vendor (i.e., switching from a vendor to another showing monthly / yearly cost savings)?

13. Hello admin, please help me how to wrap a text in combobox or where can I get a code for formatting combobox. I’m doing a dropdownlist of diagnosis for our hospital billing statement of account. Thanks!

14. I would like to know how to scroll in three columns or five columns instead of one by one using arrow keys. Is there any way to bind three columns together so that they all show together?

15. GM All,

    i have a problem in which 2 spreadsheet , one spread sheet contain incoming of whole month, with vender code ,sap item code and incoming qty,

    and in another sheet contain vender code and sap item code , we need to take the data for incoming qty in the second one with out using filter option.

    please support. and give the best guidance.

    Hemant Sharma

    9911195566

16. Hi Sumit, will you be releasing 2018 leave tracker?

17. This is just lovely Sumit… Meet you at Hyderabad MVP meet. One of the nice professional I have ever meet. Going through your web site and it is really superb. Lots of free but very useful templates.

18. Dear Sumith need your help to send me the excel file where you cerate helping columns and retrieve the data by selecting from drop down list.
    My email ID Imran.bashir@Infofort.com

19. I am automating SAP print activity using VBA macro code.
    When is automate my repetitive active one print dialog box open and I need to press OK.

    Please suggest code for automate OK button

    https://uploads.disquscdn.com/images/c3e7231f3cf62c10d099d0a09b78366baec7abf81fde3e9102eeb5fb23dd32c2.png

20. Hi Sumit,
    I am facing a problem in excel .I have a 3 excel sheet & i want to them sort into 4 alternate parameter .How Can i do it i don’t know. I have tried Vlookup,Pivot & Conditional formatting. Can you suggest

    • Hey Harish.. Not really clear on what you want to get done. Would help if you can explain a bit more

21. This website is absolutely fantastic

22. wow your just awesome Mr.Sumit Bansal. now onwards i follow your all mail each and every tamplat is very very very educative sir i am just FAN of you sir.
    Actually i have small computer education center where poor student come to learn from me specially COMPUTER BASIC & OFFICE. data from you i found very use full.

    thanks once again for enlightening me with your precious knowledge
    thanks soo much sir.

23. Can you create a IT loaner equipment type of spreadsheet for Tracking. Like a check in check out sheet that would also generate an email to the user upon check out and reminder to return on due date.

24. may i get temp for daily cash reporting?

25. Thanks a lot these are fantastic!

26. I need help! I have looked everywhere for a paid time off calculator and tracker based on hours. Any help is so appreciated.

27. Hi Can any one help me in creating searchable drop down list in data validation itself , i have one using combo but i am unable to make it in data validation..to use at multiple location

28. Hello! I am responsible for managing a caseload of clients and tasked with assigning each client with our employees for follow-ups. Is there a template or anything which will allow me to do that? For example, if in column 1 I enter the name of a client, can this automatically assign this client to an employee? Furthermore, am I able to create a time constraint that the employee is given to follow-up with the client or complete a task associated to that client? I’m very sorry if this message is confusing 🙁

29. does anyone have a nine box model template?

30. i would love to see how to make a Check out log we have alot of printers and as we issue out ink we have a list issued out list of employees that have used ink with a date that gives us a count of days so we know how long it has been since they lasted asked for ink do you think there is a way to make a more automatic check out sheet ?

31. Hi Sumit,
    I m trying image look but it given error as reference not valid. can u help me in that.

    Thank ajit

32. Sumit,
    I am a small business owner and want to create checklist or process for my staff to follow. i would like to create a template first…then use the template to different events such as employee onboarding etc.
    can this be done via excel sheets? if so can you share an example.

33. I love your Task Matrix but I have literally HUNDREDS of activities I want to put into the To Do List but you only offer 50. I’ve been trying to figure out how to expand the number to at least 100. How would I do that?

34. sir can you suggest me how to select data from long list and place them in a table with the same order i selected

35. Many Many Thanks.

36. Hi, Sumit Sir. I am Naushad Ansari from Nepal. I am very happy having too much useful templates.
    Sir, I am working as a Principal in a School. Do you have any School Management System templates in Excel? And also for accounting. If you have please, provide me. I’ll be very thankful to you.

37. Email Generator Excel Template -file cant be found =(

38. Hi Sumit, It is an excellent work on the excel. Hats off to your hard work.

    I need to have a datewise consolidattion in the final monthly summary in the final sheet. Let me have a template please. Thanks again

39. Dear Mr.Sumit,
    Can you give me code for converting .xls to .xlsx for a batch of files

40. Thank you for all! You rock!

41. Thank you for all! You rock!

42. hello,i want to pull data form another excel file1 in to excel file2 through dropbox and in excel file1 increase day by day and excel file2 should be updating automatically.

43. http://www.fibo314.com

44. I would love to see some of these templates combined, you could have a cheap CRM in no time!

45. Sir, In Bangalore training is required for one day for 10-12 employees in an Office. Please provide your contact number for enquiry. send mail to gopalakrishnarao1@gmail.com

    • You can reach out to me at sumitbansal@trumpexcel.com

      • Hi Sumit, I need your help for Leave tracker. Are you still helping on this email id?

46. Good morning Sumit, I have downloaded your To Do list (The one with %) to use at my work to track my work load. I have customize it to fit my requirement. My question is: Am I allow to you it for Business purposes? If so, although I usually ensure to mention who is the original author of this workbook, is there a place where it is mentioned?

47. I love the Gantt chart – is there something that shows the information in both normal calendar view and Gantt chart view so I can swap between the two, i.e. when you add information in one it automatically updates the other?

48. Please make a tutorial or template for students database management.

    • Hello. I am use excel 2010. My file size 1gb. But some time is not save. And not open. Please help me.

49. IN employee sheet calucator i worked for partime that is
    7.30pm to 12.30am till midnight but it is coming error

    • Hello Shiva.. Since this leads to a change in date, the time sheet calculator gives an error. You can split it into 2 parts (Day 1 – 7:30 pm – 12:00 am) and (Day 2 – 12:00 am to 12:30 am).

      • Hi Sumit, Can I have your phone number please, The convienient time to call you.
        Thanks

      • Hi Sumit! We’ve been trying to use the Employee Leave Tracker and wondered if there is one for 2018 yet? Thanks!

        • Hey Jaime.. For 2018, create a copy of the leave tracker template and change the year in cell A2. This will automatically update the tracker.

50. I love the employee leave tracker, will you be releasing one for 2016 or how i customize it?

    • I am having trouble altering the employee tracker I keep running into Debug problems with this file when I try to add more employees

      • Hello Virginia.. Here is a template for 100 Employees – https://www.dropbox.com/s/ydyl3nltqk08a6v/Excel-Leave-Tracker-2016-100Employees-TrumpExcel.xlsm?dl=0

        • Hi Sumit ,you saved my work Stra several times .thx a lot
          for the professional tips “professor” , and i mean it

    • Hello Rodlfo.. I have updated the tracker (with some new functionalities). You can download the new version from here – http://trumpexcel.com/2015/03/excel-leave-tracker/

Comments are closed.