Excel is a great tool for data manipulation. One feature that can come in handy is the ability to pivot a data row into a column or pivot data in a column of information into a row. Continue reading “Pivot a Row or Column of Data in Excel”
- In simplifying your task of putting the Workbook and Worksheets together
- and I can’t stress enough how much time this will save you from trying to re-jig your Web server to serve Excel documents using the Microsoft.Office.Interop.Excel library.
There are some great ways to hunt down duplicate values in the desktop version of MS Excel. Today I will take a look at using the free online SkyDrive version of Excel that is integrated with Outlook.com to find duplicates between two columns. Continue reading “Skydrive Excel: Find Duplicates Between Two Columns”