FREE EXCEL TEMPLATES, SPREADSHEET DASHBOARDS AND TOOLS
Download free Excel & Spreadsheet Templates, Dashboards, Tools and Calculators for Personal and Professional use. Further, We have excel Templates and Dashboards for Invoices, Project Management and Business/ Management Information Systems (MIS). All our templates contains formulas for ease of doing your day day work. Moreover, you can get automated reports and graphs for data visualization.
Also, get calendar and activity planner templates for managing your day-to-day activities and holidays. Further more. we have budget templates that are helpful in defining your budgets for business and personal finance.
Excel Template Categories
DOWNLOAD FREE EXCEL TEMPLATES. NO FEE & REGISTRATION REQUIRED!
Employee Welcome Letter
Employee Welcome Letter is a ready-to-use excel template which helps you issue a letter welcoming …
GST Debit Note Format
GST implement from 1st July 2017. As a register business will now have to issue …
Social Media Content Calendar
Social Media Content Calendar is an Excel Template to plan and schedule your social media …
Blood Sugar log
Our blood sugar log chart lets you track your blood sugar levels throughout the day. It also …
Depreciation Calculator
Depreciation is a term used to describe the reduction in the value of as asset over …
Periodic Table
A good periodic table is necessary part of every chemist’s, or future chemist’s, materials. After …
UAE VAT Payable Calculator
UAE VAT Payable Calculator provides you the exact payable amount of VAT to Federal Tax …
UAE VAT Credit Note
Every business entity has to issue a UAE VAT Credit Note, whenever the goods are …
VAT Invoice Template
VAT Invoice Template is an excel template in compliance with GCC VAT Law. You can …
Accounts Receivable With Aging
Accounts Receivable Template With Aging is a ready-to-use template in Excel that find your Accounts …
Monthly Budget
What is the Monthly Budget for Project? The monthly budget is known as the fund …
RACI matrix
RACI matrix (pronounced as “ray see”) is an acronym for Responsible, Accountable, Consulted, Informed. Mostly, …
We Create Your Life Easy With Our Free Excel Templates & Spreadsheet Dashboards
Use free Excel Templates, Tools and Dashboards to create and draft a professional looking dashboards and computation sheet for your personal and business use. You can Explore Calendars, Activity Planners, Invoice Templates, Sales Forecast Sheets, Budget templates and various business information delivering Templates in Excel and Spreadsheet at XLSX Templates.
These templates, dashboards and tools are useful in various occasions. You can also customize these templates as per your requirement. Modification of fields and data source helps in making the template more relevant.
Learn Microsoft Excel : Blogs and Articles
Learn about various tips and tricks in Microsoft Excel and Spreadsheet. Create best templates and dashboards using free tricks and tutorials in excel and spreadsheet. These tutorial posts are useful for everyone who wants to master the skills in excel and spreadsheet.
Formula Bar in Excel
Table of Contents Key Points To Consider Using Formula Bar You can hide or unhide the formula bar. You can …
How to use Goal Seek in Excel Sheet
In school days, we used to solve mathematical equations….where we have the result of the equation… ..but don’t have the input …
Tips for customizing quick access toolbar in Excel
Below are some of the tips that you can learn to use the quick access toolbar to its best. How …
How to Create a Data Entry Form in Excel without VBA
The best way to enter data in a table is Data Entry Form. But, creating a form to enter data it …
Quick Access Toolbar in Excel
Table of Contents Quick access toolbar important to have all the commands that you frequently use in one place so …
How to Update a Pivot Table Range in Excel Automatically
Table of Contents Updating a pivot table is a pain, isn’t it? I’m sure that pivot tables are everyday part …
Basic VBA Macro Codes in Excel
Custom Header & Footer
Sub CustomHeader() Dim myText As String myText = InputBox(“Enter your text here”, “Enter Text”) With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader …
Add Header and Footer Date
Sub DateInHeader() With ActiveSheet.PageSetup .LeftHeader = “” .CenterHeader = “&D” .RightHeader = “” .LeftFooter = “” .CenterFooter = “” .RightFooter …
Open Calculator
Sub OpenCalculator() Application.ActivateMicrosoftApp Index:=0 End Sub In Windows, there is a specific calculator and by using this macro code you …
Unmerge Cells
Sub UnmergeCells() Selection.UnMerge End Sub Unmerge Cells code simply uses the unmerge options which you have on the HOME tab. …
Remove Text Wrap
Sub RemoveTextWrap() Range(“A1”).WrapText = False End Sub This code will help you to remove text wrap from the entire worksheet …
Auto Fit Rows
Sub AutoFitRows() Cells.Select Cells.EntireRow.AutoFit End Sub You can use this code to auto-fit all the rows in a worksheet. When …
Auto Fit Columns
Sub AutoFitColumns() Cells.Select Cells.EntireColumn.AutoFit End Sub Use above Excel macro code to auto fit rows in all your sheet at …
Insert Multiple Columns
Sub InsertMultipleColumns() Dim i As Integer Dim j As Integer ActiveCell.EntireColumn.Select On Error GoTo Last i = InputBox(“Enter number of …
Insert Multiple Rows
Sub InsertMultipleRows() Dim i As Integer Dim j As Integer ActiveCell.EntireRow.Select On Error GoTo Last i = InputBox(“Enter number of …