Here are some tutorials that i gathered from net. Some are as old as 5 years but all of them are great.So read them and learn from them use your brains and things will work for you. List of tutorials that can help you : You can download the sample Zip file and try it. Coder stats that he wrote a code to abstract the dbase access for C++ using its COM object. It will be better to read…
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…
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…
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…
For the love of Excel !!! I love spreadsheets though sometimes they make me feel bore but i think if you keep learning it you won’t get bored of it. There are many tricks and cheats besides the regular functions of this program.I download some of these tuts in my phone and read them whenever i got time it helped me a lot in office so i think these tuts are quite good so instead of killing time playing stupid games…
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…
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…
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…
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 …
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…
