Excel

Do you like to read Ms excel tutorials or watch ?

I have lots of Ms access and Excel tutorials resources (links from internet,videos and PDF’s along with templates and example sheets, some of them are really important and can help a lot, but the thing is that I want to know which one works for you. I basically hate reading long tuts as well as long videos as they consume a lot of time and in the end you might get the desired result or not. I will be making…

Read More

Balance sheet Format Templates In Excel

Balance sheet is a statement that shows financial position of a business on a particular date.It contains information regarding the assets and liabilities of a company along with shareholder’s equity. I have managed to collect some of the good and fine tuned template to manage B/sheet items. Following are handpicked 5 templates / examples that can be used in your spreadsheet programs (As most of them are supported by excel and others). 5 year comparative template A estimated or projected…

Read More
amortization schedule excel

Mortgage Amortization Spreadsheet

To download this mortgage amortization spreadsheet you have to click on image given below.It will directly download the sheet on your computer or device.User has to input details like loan principal amount,annual interest rate and loan period in years along with the base year of loan and base month.Key figures will be automatically calculated via sheet.I would say it is one of the must have worksheet.I have tried this one on my Asus zenfone also it works fine on Ms…

Read More

Vehicle Log Book Format Excel Spreadsheet

Here is another interesting sheet to track your vehicle mileage. As a user you have to fill in details like the type of vehicle,registration details and other stuff.     This simple sheet allows user to input details like odometer readings,Calculate business and private vehicle expenses and other information.It is printable and very simple to manage. This one is for leased vehicles…

Read More

Golf Scorecard Template Excel

There are two different worksheets within the spreadsheet one is 18 hole scorecard and the other is 9 hole scorecard. It is easy to track the scores using this sheet on your mobile. I currently use Microsoft official app for excel, but it can work on most of the apps provided on android store.Easy to maintain and shareable.¬†First download this golf scorecard template by clicking on the image given now after downloading it you have to open the excel and…

Read More

Insert digital signature in Google docs

Here is a simple add on that enables users to insert their signs in Google docs. It can track when a receipient opens and views the document.I think it is one of the best tools for electronically signing your documents.It relieves us from hazzles of printing and scanning.This sort of add in is simply a must have for project managers. It also helps you to receive the docs signed by others.Though, it is limited to 3 docs per month for…

Read More

KPI Tracking spreadsheet

Key Performance Indicators Spreadsheets This sheet may prove useful for business owners to find their right key performance indicators. As we all know that besides tackling the weaknesses of a business, one should leverage more on their KPI’s. This workbook is preloaded with examples and there are 4 different sheets : Your team,KPI by function,company goals and team K P I. You have to fill in details regarding your company and other stuff before downloading this sheet. You have to…

Read More

Bank Reconciliation Excel

A solution that i use is this checkbook assistant it is an app(add-in) for Microsoft excel that can help you manage checkbooks and back statements within spreadsheet. Entries like cheque deposited but not collected by bank or adjustments related to bank reconciliation can be done easily with this tool. You can run an anti virus check on this app before using it. You can find this tool working under ribbons >> Specialty tab   Download the add in here  …

Read More

Google Spreadsheet Sales Tracking

This spreadsheet can be really useful in case you have just started up a business.It will help you to monitor and track your sales pipeline.I actually love the simplicity of excel that makes it possible to do things in a easy way instead of some highly complex CRM tools. This sheet consists three parts (tabs) first one is for setting up your business basics like the target identified ,contacts made and other stuff under a single worksheet page.The other part…

Read More