Often times, when you download a data table from somewhere it's not in the format you need it to be. Tables are often in a summary format where you have months going down and years going across, or vice versa. It's the end result of what you want a ...
It's not often that you'll need to transpose data in Excel, but when you do you'll be happy to know how easy it is to do. In this post, I'll go over not just transposing data but converting text to columns and showing you how you can change a block ...
A countdown timer can help you track how much time there's left to do a task or until a deadline comes due. Below, I'll show you how you can make a countdown timer in Excel that can track days, hours, minutes, and seconds. In order to make it work, ...
If you've got a large data set, you know how important it is to be able to filter that data quickly and easily. Knowing how to filter efficiently in Excel can make it easy to not just pull up the data you need, but to also run calculations. Below, ...
If you've inherited or downloaded a data set, you know that sometimes you'll need to combine data together to make it in the format that you want. A good example is a list of addresses where you may have the street information in one column and the ...
Whether you're tracking sales or costs in excel, it's important to capture not just your monthly totals but your cumulative year-to-date amounts as well. And to do that in excel, you'll need to calculate a cumulative sum. Ideally, you'll want to see ...
Scroll further down if you would like to see details as to how this calculator works and a description of it. There is a new version of this calculator available here (mobile-friendly) that will make calculations at multiple price points at once ...
A word search can be a great way to pass the time and for kids, it can help them practice their spelling as well. With this free word search maker, you can easily create a random new word search in just seconds. With small, medium, and large sizes t ...
Creating charts and graphs is a great way to display data visually and make it easier for users to read and understand it. However, in some cases, you don't want or need a big chart, and something smaller would be more useful. This is where sparklin ...
If you need to collect user input in an Excel spreadsheet, you'll want to be able to minimize errors and typos in the information that you receive. That's why it's important to know how to create a drop-down list in Excel as it will limit the select ...
