Here is a collection of free Excel templates. Every template has a brief description along with the download link. If you want to learn more about the templates, click on the read more link.
This section is updated frequently with new Excel Templates.
FREE Excel Templates
Below is the category of Excel templates available for download.
This Tutorial Covers:
TogglePRODUCTIVITY TEMPLATES
This section has some useful personal productivity Excel templates.
You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the ‘Read more’ option.
Excel To Do List Template (Printable)
Here is a simple excel template where you can fill the tasks and take a print-out. If you prefer writing the tasks yourselves, simply print it first and then fill in the tasks.
Read more about the Excel To Do List Template (Printable)
Click here to download the Excel template
Excel To Do List Template (Drop Down List)
Use this Excel Template to jot down all the TO DO list items and then mark it as completed by simply selecting it from the drop-down. The completed tasks get checked off and highlighted in green.
Read more about the Excel To Do List Template (Drop Down List)
Click here to download the Excel template
Excel To Do List Template (with Check Boxes)
Use this Excel Template to jot down all the TO DO list items and then mark it as completed by checking the box for that item. The completed tasks get checked off and highlighted in green.
Read more about the Excel To Do List Template (with check boxes)
Click here to download the Excel template
Task Matrix Productivity Template
This Excel template is inspired by the highly successful technique – Eisenhower Decision Matrix (popularized by Stephen Covey in his book 7 habits of highly effective people).
This is a simple and easy to use Excel Template that will help you prioritize work and increase productivity.
It helps you divide tasks into categories based on Importance and Urgency.
Read more about the Excel Task Matrix Template | Watch Video
Click here to download the Excel template
Shared Expense Calculator Template
This template can be used to calculate ‘who owes whom’, when the incurred expenses are shared by many people (for example, sharing apartment expenses or vacation/trip expenses).
Simply enter the expense incurred by different people and it automatically gives you the summary.
Read more about the Shared Expense Calculator Template
Click here to download the Excel template
Calendar Integrated with To Do List Template
A calendar template that also doubles as your To-do list template. Simply double click on a date and enter the to-do task list (as shown above).
The list is stored for each date and reflected in the calendar. You can also get to see the list of all the task in the month by clicking on ‘Show Monthly Tasks List’.
This Excel template is created using Excel functions and VBA.
Read more about this Excel Template
Click here to download the Excel template
Vacation Itinerary Template
Use this Vacation Itinerary Template to have all the details in one place (such as flight/travel details, hotel details, and activities/meetings details).
It’s an editable template and you can fill the details in Excel, or can take a printout and fill it.
Read more about this Excel Template
Click here to download the Excel template
Vacation Packing List Template
This free Excel template will help you be more efficient while you pack for your next vacation/trip.
You can either use the template in Excel or can take a print out and manually cross off items that you have packed. It’s an editable file so you can add/delete items based on the nature of your trip.
If you are using this template as an Excel workbook, you can simply mark the items as packed by double clicking on the cell to the left of the item name. As soon as you do that, the item gets a check mark on the left and gets shaded in green color.
Read more about this Excel Template
Click here to download the Excel template
PROJECT MANAGEMENT TEMPLATES
This section has some useful project management templates. These are ready to use templates that you can download and start using.
With most of the Excel templates, you will also find links to the tutorials on how these have been created.
You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the ‘Read more’ option.
Employee Leave Tracker Template
A ready-to-use Excel template to keep a track of employee leaves.
This template has the built-in functionality to select the working and non-working days. It automatically accounts for specified holidays as well.
Highly recommended projected management tool.
Read more about this Excel Leave Tracker Template
Click here to download the Excel template
Excel Timesheet Calculator Template
A timesheet calculator template that will calculate the total number of regular and overtime hours and the total payout based on in time and out time.
Available in 3 formats – weekly, bi-weekly, and monthly.
When printed, it fits perfectly on a single page.
Read more about this Excel Timesheet Template
Click here to download the Excel template
Milestone Chart Template
Use this milestone chart Excel template to depict project scope and timelines/milestones.
Just specify the milestones along with the date, and it automatically builds out the chart for you. Highly recommended for project management.
Read more about this Excel Template | Watch Video
Click here to download the Excel template
Pareto Chart Template
Remember the Law of Vital Few (better known as the 80/20 rule or Pareto Rule).
Here is an Excel template you can use to quickly create a Pareto chart in Excel.
To make it even better, there is a dynamic version of the chart as well.
Read how to create this Pareto chart in Excel
Click here to download the Excel template
Excel Gantt Chart Template
Gantt Chart is a simple yet powerful tool to create a schedule or track progress.
Here is a free Excel template that Batman used to get his Batsuit ready 😉
To make it even better, there is a dynamic version of the chart as well.
Read how to create this Gantt chart in Excel
Click here to download the Excel template
Excel Thermometer Chart Template
A Thermometer chart is a good way to show target and actual values in a dashboard.
Just specify the target and actual value and it automatically depicts it in the thermometer chart.
Read how to create this Thermometer chart in Excel
Click here to download the Excel template
OTHER EXCEL TEMPLATES
This section has some additional useful Excel templates that you can use for personal/professional work.
You can download each Excel template by clicking on the download button. If you want to learn more about the template and how to use it, click on the ‘Read more’ option.
Excel Calendar Template
This calendar template has two different set of calendars – Monthly calendar and Yearly calendar.
It updates automatically when you update the year (in the yearly calendar template) or Month & Year (in the monthly calendar template). The calendar is built in a way that you can easily take a print and will fit in a single page.
Read more about this Excel calendar template
Click here to download the Excel template
Excel Holiday Template
This Excel template will give you all the national US holidays for the selected year.
Even better, it tells you the number of days to the next holiday and the long weekend.
Read more about this holiday calendar template
Click here to download the Excel template
Random Group Generator Template
This Excel template will help you quickly create random groups of people/items.
You can use it if you’re a teacher and want to create a random group of students or if you want to create random groups of employees/team-members.
This template uses some basic Excel formulas and VBA.
Read more about this random group generator template
Click here to download the Excel template
Excel Stopwatch Template
Here is an excel template that has a stopwatch in it.
It has the options to start, stop and reset the timings. It also automatically records the timings as soon as you hit the reset key.
It has been customized for a ToastMasters kind of meeting where the speeches are timed and the speaker is shown a green card after 1 minute, a yellow card after 1.5 minutes, and a red card after 2 minutes.
Read more about this stopwatch template
Click here to download the Excel template
Excel Age Calculator Template
Download this Free Age Calculator Template in Excel.
You can specify the Date of Birth and it automatically calculates the total age till date (using the current date). You can also change the current date to any date and it will calculate the time elapsed in the given time interval.
This Excel template can also be used to calculate service tenure or the duration of a project.
Read more about this Age Calculator Template
Click here to download the Excel template
Excel Invoice Generator Template
You can use this Invoice Generator template to instantly create and save invoice as PDF (or Excel files). All you need to do is double click on the name of the client and it automatically creates an invoice for it, converts it into a PDF, and saves it in the specified folder in seconds.
Using this template, you can generate hundreds of invoices in a few minutes.
Read more about the Invoice Generator Template
Click here to download the Excel template
Military Alphabet Code Generator Template
‘A’ as in Alpha, ‘B’ as in Bravo, ‘C’ as in Charlie… Heard this before?
These are called the military alphabet codes. It is often used during telephonic conversations to communicate the name, address, or email address.
Here is a template that will automatically generate the military alphabet code for you as soon as you enter a word
Read more about this Military Alphabet Code Generator Template
Click here to download the Excel template
Useful Excel Tutorials:
122 thoughts on “FREE Excel Templates (Download)”
On the Timesheet calculator, I need to add another in and out time for when my time is split on the same day. Can you tell me how to formulate the cells for it to figure the times correctly?
Hello! I have been using your Leave tracker for 3 years, and it works every time, its just so great! thank you.
In light of Covid and safe workspace, i think an idea for you is to create an excel which enables employees to mark days in the office, and grey out days for their neighbors? 🙂
Brilliant works.
Sadly this is not what I was looking for.
I tried to get a little problem to calculate automatically.
I use it manual today and want to make it easier.
The problem is when we play bowling and make series over 200 we get points for that.
If you score 200 you get 2 points and following.
If you make 205 you get 2,5 points and so on. 210 makes 3 points.
220 makes 4 points, 240 makes 6 points.
You take the first number 2 and add whit the following 2 and 3. I can´t get it to work in Excel.
Thanks for all the help I can get.
Stefan
Dear Excel Guru,
I have an issue that I am finding hard to resume and I hope that Excel has the functionality to resolve.
1. I have an excel spreadsheet that tracks purchases in a school tuckshop. I have a menu list that has been abbreviated to reduce the size of the document.
2. This list has been converted into a multiple selections drop-down list using VBA.
Problem:
I am trying to figure out how I can get the multiple selections in the drop-down list to transfer the calculation of items purchased into a total box. e.g. MS = $3:50, BA=$2:50.
The dropdown list would look in a cell MS,BA – then in a seperate cell the total $6.00 the addition of the two abbreviated items.
Can this be done
Thank you
Dear Sir,
I want in A column only the highlighted/ colored cells to be numbered sequentially, while the unlighted cells numbers undisturbed. As soon as I highlight the cell it should give automatically the next number.
1 Highlighted
1
2
2 Highlighted
1
2
3
3 Highlighted
1
2
4 Highlighted
1
2
3
4
5 Highlighted
1
2
3
1 Highlighted
2
3
4
Can you help me in this matter ?
Thank You.
Dr. Prakash Kulkarni
How can i copy a specific data from word to excel with minimum efforts ?
How can I change the colour of the weekends or the employee leave tracker? I can’t find where you have put the code for that. I really don’t like brown for the holidays. Thank you.
Awesome work Sumit
Absolutely Brilliant
Thanks , Very Nice Template, Do you have any templates for Inventory Receipts and Issues and Closing Balance
great stuff sumit! more power to you!!!
Very good tips! Good job! Thank you for that! It’s very helpful!
Hey man, God bless you! This really has been helpful.
It’d be nice if people could take a moment to appreciate the amount of effort has been put in by the creator of this content rather than ungratefully asking for more templates. 🙂
Is there a template for resizing a womens handbag pattern. We have the instructions – no pictures of pattern pieces – but instructions for sizes of each piece in the bag. we would like to make the bag bigger and need to know the new sizes of each piece. thank you
Hi, The videos are so educative. Could you please give a template for Apartment maintenance or for Apartment association which maintains the accounts and reords.
Thanks
Hello do you have a monthly employee scheduling template that calculates hours for you once times are entered?
Hello, I cannot access your 50 employees leave tracker through dropbox, would there be a way to access the file somewhere please? Many thanks Faz
Brilliant, very helpful.
Hi I am looking for a milage report spreadsheet. I travel to 10 regular places and know the milage.I want the milage column to autofill when I insert the destination, drop down list or type in destination cell is fine.
How would All my orders and automatically group and sort them by workday on another sheet. Each workday day is a header which will then show all orders underneath for that particular day/date.
Do you have a leave tracker template that tracks in hours instead of days? I have lots of employees that do not use an entire days when taking leave. Thanks in advance.
This is already here.
Great work. I downloaded the Leave Tracker (50 Employees). If an employee is going on leave which will include the weekends too then how to change the formula in the Leave Breakup to show the number of days. At present it excludes the weekend. Thanks a lot
Brilliant very helpful
Thank uuuuuu very
math
شكرا THANK S
I want make excel sheet to maintain users list. Multiple users use multiple application. I want to track the User which use multiple application in one Excel Sheet with search option. Can you please help me.
Need some help to get forgotten password of encrypted Excel file.
SIR
IS THERE ANY OPTION IN EXCEL TO NUMBER TO TEXT IF YES PLEASE LET ME KNOW THE METHOD
(EX: IF I TYPE 2000 IN CELL A5, CELL 25 SHOULD DISPLAY LIKE “TWO THOUSAND)
very useful kudos
Hi, I want to create a form that has a box that a person can put their email in to it and another box to say submit. And a way to save the addresses in a spreadsheet.
The excel sheet was awesome but now companies are not using share drives, they are using the google drive. but while i tried to update the leave tracker on the google drive, the macro are not running. Could you please improvised it so it may be use in Google drive also ?
Hi i m unable to download ebook.
Great…..
Hi,
Any ready made template for website menu and Submenus is available (eCommerce).
Thx
Great……..
Hello Sumit,
I am looking for an excel formula to locate (find) and match a list (Column A) of SKU numbers example AA/SC/12646 to a list (Column F) of images that are label as example img_12646.jpg. In essence, I want to marry or match the images to the SKU numbers.
FYI we need to match about 2,000 line items with the appropriate image.
A sample workbook was attached to my email to you for your perusal.
Your assistance would be most appreciated.
Kind regards,
M J Perret
Hello,
I downloaded the Excel Timesheet Calculator and it works perfectly fine but something that I noticed that I was wondering to see if you can help me adjust was the Overtime. The excel workbook has overtime by the day depending on the regular hours that is entered. Is there a way to have the OT be calculated on a weekly basis?
For example, if an employee works 10 hours each day, Mon – Fri, they will have 50 hours worked for the whole week. Anything after 40 in a week would be considered overtime no matter how many hours you put in one day. Basically, it should show Mon – Thur being “Regular Hours” and then Friday being overtime.
If I need to explain this in more detail please let me know.
I have made a template to be used Canadian Lottery numbers and quantities. I would like to be able to put the first three numbers o lotto Max numbers on the top line and not go through having to copy and past it to my page. Could you please help me.
Thank you
Dwight
can I please get a spreadsheet for close out documents on a construction job. also a template for equipment lists. also a copy of a color schedule please thank you
sir can i get a template for a loan management system using excel
Terima kasih atas kebaikan hatinya untuk share pelajaran yang sangat berharga
Sir,
Very Useful Tamplates Thanks
Wow I feel lucky to have just found all of the templates you have created! There are a few templates that will not allow me to download, the webpage populates full of characters rather than the downloaded file.
All others I’ve downloaded are amazing and easy to use, thank you so much.
Thanks for letting me know Natasha.. I have fixed all the templates that weren’t downloading
Will you email me the Calendar Integrated with To Do List Template, when attempting to download from the site I get webpage full of character texts.
I’m anxious to try your Task Matrix (Eisenhower Box) but the download link doesn’t work. Thanks.
These templates are very helpful. As commented already, the invoice generator download does not work? Will this be restored in the near future? Already?
please i need help. i want to do this.but i do not know.
cell a1=3000 and cell b1=nutil 1600
cell b2=400 ( b1+b2)=2000 and
cell b3=>2001
thanks nery much
Very helpful thank you. I did notice that the invoice generator link is broken. I was not able to download it.
Too Helpful
This website is very much informative.
Thank you, Sumit ji for sharing all this.
Keep Going!!!
Are the templates completely free or is this a free trial ?
Calendar Integrated with a To Do List Template in Excel, This template will not allow me to download. Webpage populates full of characters rather than file download box.
I want to ask if there is an excel formula that will format a specific cell (with colour) when one of the other cells is hit? What I am trying to do is this: When one of the coloured buttons is hit I in the row, that “Status” (F column) would change colour formatting at each stage. So if H121 is “marked with an X, the colour in F121 would be orange, if I121 is marked with an X, F121 would turn Yellow and so on. Is this possible first off and if it is I presume from “G” to “S” would need a formula referring back to “F” Do you get what I mean? Perhaps using the insert “check box” so when checked it will change the cell to the same colour as selected with the check box.
Hey Sumit
Wonderful website. Im extremely happy with content of this site. Very useful for employees of every company in their routine life.
I need, an I suspect many others do as well, a template to track 15 minute paid breaks. My state requires that we keep track of breaks to prove that employees are offered morning and afternoon paid breaks. I have been spending a lot of time to create something to use, but this is not my area of expertise. I suspect a pro could whip something up in no time, ore even knows of something already out there.
Search on Sumit’s website for this…
Free Excel Leave Tracker Template (Updated for 2019)
Hi, really nice termplates. I really appreciated. Need a help please. Inside Excel Calendar Template I´m trying to apply 8 diferent conditional formats with colors based on events but holidays per month. January is ok, but I could not figure out from Feb to Dec. Tried different Vlookup formulas. Any idea?
I like this website so much !!
So cool Excel !!
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.
great
How to link real time stock prices to excel sheet when making a portfolio of investments in excel?
Thank You Trump…Ur Excel Reference Is Assume…
WANT TO SET UP A DAILY AVERAGE IN EXCEL TO RECORD INDIVIDUAL AND AVERAGE
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?
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?
very nice collection it’s very helpfull
Hi do you have a template for finance management .. I mean credit vs debt and monthly expenses and savings something like that.
Sumit Sir,
I need your help in developing a tracability matrix.
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?
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)?
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!
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?
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
Hi Sumit, will you be releasing 2018 leave tracker?
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.
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
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
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
This website is absolutely fantastic
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.
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.
may i get temp for daily cash reporting?
Thanks a lot these are fantastic!
I need help! I have looked everywhere for a paid time off calculator and tracker based on hours. Any help is so appreciated.
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
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 🙁
does anyone have a nine box model template?
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 ?
Hi Sumit,
I m trying image look but it given error as reference not valid. can u help me in that.
Thank ajit
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.
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?
sir can you suggest me how to select data from long list and place them in a table with the same order i selected
Many Many Thanks.
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.
Email Generator Excel Template -file cant be found =(
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
Dear Mr.Sumit,
Can you give me code for converting .xls to .xlsx for a batch of files
Thank you for all! You rock!
Thank you for all! You rock!
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.
http://www.fibo314.com
I would love to see some of these templates combined, you could have a cheap CRM in no time!
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?
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?
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?
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.
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.
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.