Example of Creating A Population Pyramid In Excel

This one is a fine sample spreadsheet to construct a population pyramid in excel sheet, user have to fill in data in % divided into males and females along with their age.After the data input chart will be automatically constructed in the same sheet but in different tab provided. Easy to understand and use and understand. If you have data of actual males and females instead of percent you  can arrange the data according to this tutorial.It is quite easy…

Read More

Downloadable Cue Sheet Template

I am sharing few blank cue sheet template’s with you. These can be downloaded and filled by the user information such as publisher and composer is needed to be filled in these sheets.     Here is another one it is sports music sheet as it is uploaded to onedrive. You have to click on more… and then  choose download option  

Read More

Sort and Filter Text In MS Access

In this tutorial i will tell you how to use some properties like Table filtering and sorting in MS Access and i will also show you how to create a form in this software. First of all we will need a dummy data sheet or a example sheet for testing, First of all lets start with sorting and filtering   You have to click on the home tab to view these options. For example you want to arrange this data by…

Read More

Purchase Request Form In Excel

Track your purchase per item wise using these worksheets. They support most of the spreadsheet programs like excel,google sheets and others. You can convert them to open office format also. There are various tools available online that can do this for you in few minutes.   MAC users try this : You can download these sheets and upload them to Office web Apps that will allow you to edit files and save them online. For it you need a Live…

Read More

Backup Excel Automatically Vba

Here is a Excel VBA code that will allow you to backup your active worksheet as per your defined time. It is by default “15 seconds” but you can change the period as per your needs.   Create a folder and name it “Test” in the partition C:\ The code in a module —————————— And this code is in a workbook module

Read More

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

How to connect Ms Access With C++, c# and VISUAL C++

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…

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