How to calculate percentages in Excel

How to calculate percentages in Excel

PixieMe/Shutterstock If you are using Microsoft Excel to manage numerical data, at some point you’re inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit easier. This is where the percentage formula in Excel can give you the answer you need in seconds. And … Read more

How to merge and unmerge cells in Microsoft Excel

How to merge and unmerge cells in Microsoft Excel

Image used with permission by copyright holder Microsoft Excel is a powerful application, capable of acting as a full-featured spreadsheet and data analysis tool. While Excel is fully capable of some powerful data manipulation tasks, sometimes you need to do something simple like merge and unmerge cells. That essentially means placing the value of one … Read more

How to freeze rows and columns in Excel

How to freeze rows and columns in Excel

If you’ve ever worked with an enormous Excel spreadsheet, you’ll know just how daunting all those rows and columns can be. Once you’re over 10 or 15 different values and labels, it can get pretty difficult to hang onto any info you’ve gleaned from these early cells. Fortunately, there’s a simple way to lock those … Read more