Excel Templates for free Download

Excel Templates for free Download

If you can make excel templates based on whatever the requirement of the situation is, you are going to be very valuable as a professional. There are many ways to do it and training materials are available which can help you build quality formats in excel. We have provided some of the key Excel Templates for free Download and will be adding to it on regular basis. In order to download the file, kindly click on the download button below each file.

Sales Invoice

Sales Invoice Format

Sales Invoice Format

Bank Payment Voucher

Save the file as macro-enabled as there are two macros in it. One to convert the amount into words and other the “create new voucher” button. The button will create new blank Payment voucher template in a new sheet for you to enter a new voucher.

Payment Voucher Format

Payment Voucher Format

Sales Reports Pivot Table

Sales Reports prepared using Pivot table. You can either use as it is or modifies it as per your needs.

Sales Report Pivot Table

Sales Report Pivot Table

Attendance Sheet – School

The attendance sheet is used as a control factor in school. You can use the attendance sheet in a printed form or change it as per your needs.

Attendance Sheet - School

Attendance Sheet - School

Daily Working Schedule

Planning is very important in order to get tasks done on time and to have check & balance. Daily working schedule sheet is exactly having the same purpose and is prepared to keep the daily task list in mind. The sheet is prepared with the sample conditional formatting formula.

Daily Working Schedule - Gantt Chart

Daily Working Schedule - Gantt Chart

Salary Payslip

Salary Slip Format

Attendance & Timesheet (Staff)

Staff Attendance sheet

Staff Attendance sheet

Monthly Reports (Personal Income Vs Expenses)

This useful document consists of three sub-sheets. The data need to be entered in data entry sheet. The middle sheet consists of Income and Expense categories. The final and the most important one is similar to the image shown below. You will change the month and the charts and reports will update itself.

 Personal Budget Report Format

Personal Budget Report Format

School Fee Voucher

Another useful form linked to the detail student fee. If properly understood and used, will save precious staff time.  Vlookup function is used to build this template which extracts data based on the unique criteria i.e. Student ID.  Change the student ID and it will accumulate data based on the ID.

School Fee Voucher Format

School Fee Voucher Format

Financial Statements

Financial statements are the point where all the transaction related to the business are summarized. On this very report, investors take decisions if the company is good for investments or not. This file contains a Balance Sheet and Profit & Loss statements. You can modify it according to your needs.

Financial Statements Format

Financial Statements Format

Excel Dashboard

Dashboards are of great use in excel as it brings information regarding key performance indicators. This dashboard is related to the sales department and sales are analyzed from product, year, sales persons, sales region and customer point of view. In case you want to read the more detail of the exact steps used for its preparation, kindly refer to the main article on Excel Dashboard. To download the excel file please click on the Download button below.