I’m going to be speaking at quite a few conferences this year (I’ll blog about them all soon once they’re confirmed) but I thought I’d post something quickly about the two big events in the first half ...

NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. One of the first questions I get asked after showing someone ...

In a world where data reigns supreme, the ability to quickly transform numbers into meaningful insights is not just a skill—it’s a necessity. Whether you’re a seasoned data analyst or someone just ...

If your are wondering how to handle large datasets and complex calculations in your spreadsheets. This is where MS Excel PowerPivot comes into play. PowerPivot is an advanced feature in Excel that ...

If you’re looking to add a number in front of a number in Excel, we’ve got just the guide for you. Let’s say you have a dataset of local phone numbers. Now, you want to make a separate list with the ...

We are from Intuit and we have developed a product (Excel add-in) that connects with Quickbooks. It is our customer's primary tool for high-volume import and export that financial data from Quickbooks ...

In this post, we will show you how to change lowercase to uppercase in Excel. Textual data in Excel often consists of datasets that are written in lowercase. Sometimes, we require changing this data ...

Power Pivot for Excel is a popular business intelligence (BI) tool that allows users to analyze and manage large sets of data. It is a free add-on for Microsoft Excel 2010 and later versions, and it ...

In this post, we will show you how to change the default color, shape and font of a comment box in Excel. Microsoft Excel allows you to add comments to cells within worksheets. These comments could ...