If you want to rearrange your data from rows to columns or vice versa (rotate or transpose it), it is very easy to do so in Excel. Just use the TRANSPOSE feature, let me show you how to convert columns to rows in excel. There are 2 methods you can use to switch between rows…
When using Excel tables, you sometimes need to calculate the summarized data of all its rows and columns. Whether you need the average, the total sum, the smallest and largest value in the column or something else, you can use the Excel total row to calculate all of those things in just a few seconds….
When working with data in Excel, you might need to start comparing numbers. The best way to see the difference in between those values is by calculating the percentage difference between them. In this article, I’ll show you how to calculate the percentage difference between two numbers in Excel in the easiest possible way. How…
If you have data in excel that contains dashes or hyphens and you need just the numbers. If you have a handful of dashes, you can just do it manually and call it a day but if you have to deal with a big set of data this is certainly not an option. So, today…
In Excel, you can use various formulas to calculate data quickly and accurately. Sometimes, however, you may just need the value of the cell and not the formula needed to get it. That way, you can change the values of other connected cells without worrying about your cell changing. In this tutorial, I will show…
If you are a service provider or consultant, you are probably looking for a nice and clean Service Invoice Template. Something that is ready just out of the box to input your services and forward it to the client. THE service invoice template for service providers and consultants. There are two versions – one with…
There were times when I just hit the groceries without a clear plan what I needed. I just grabbed whatever seemed suitable for the day. Then I started making grocery lists which were just scribbled on a piece of paper. It was tedious, until I created an excel grocery list template. I could just add…
The shopping list template is an elegant three-column form. You can just keep it at hand and fill the items you need whenever you think of one. The shopping list template is readily available anytime, anywhere. You will never again forget what you need to shop. After you are done with shopping, just print a…
The Commercial Invoice is considered to be one of the most important documents in internal and international trade. It is an absolute must if you are in the export business, as it will be required by the customs. Surely, it is extremely important that the commercial invoice is filled in as accurately and clearly as…
If you are in the business of selling goods, you most probably need our Sales Invoice Template. Developed from scratch, this is exactly what we have successfully using and tweaking for many years. It’s a proven template that was able to meet and exceed the high expectation of our co-workers even without much additional customization….