You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.

You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.