If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...

Since their introduction in 1993, PivotTables have remained one of Excel’s most powerful tools for summarizing and analyzing large datasets. With just a few clicks, you can transform raw, unstructured ...

When Andrew Grigolyunovich first started using Excel more than two decades ago, he never imagined the spreadsheet program would land him in Las Vegas or on ESPN.   The Latvian financial consultant ...

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...

To count distinct values in Excel, you need to add the unique values with the first of the duplicate value. Although it sounds complicated, you will see that there are a few simple formulas to apply ...

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a single ...

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

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 ...

If you’ve been combining multiple data sources, you can quickly end up with duplicate rows or cells in Excel. Whether it’s due to an accidental copy and paste or a typing error, this can be ...

Rearranging columns in Excel is a common task that can significantly improve the readability and functionality of your spreadsheet. Whether you’re incorporating new data or optimizing the layout for ...

One major reason Microsoft Excel spreadsheets are so popular is the ability to process the data entered on a sheet easily. For instance, if you are planning a wedding and individually listing expenses ...