News

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.
If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.
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.
How to Convert SQLite to Excel. SQLite, a lightweight database suitable for managing small data systems, might power some of your business' applications and websites.
Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?