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

Have you ever wished your spreadsheets could think for themselves? Imagine an Excel feature so advanced it doesn’t just assist you, it acts as your personal data analyst, automating complex tasks and ...

In yet another Tech Community blogpost, Microsoft has confirmed that the Visio Data Visualizer add-in for Excel will be officially retired next year. The add-in will be removed from the Excel add-in ...

What becomes possible if Excel evolved to a world where cells weren’t limited to just a single, flat, piece of text, but could instead hold a far richer concept? The new data types in Excel feature ...

For fixing Windows errors, we recommend Fortect: Fortect will identify and deploy the correct fix for your Windows errors. Follow the 3 easy steps to get rid of Windows errors: Collaboration on Excel ...

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

Data analysts often turn to add-ins when they encounter complicated computations in Excel. Here we examine and compare some common add-ins in terms of deployment process, development efficiency, ...

Hamza is a certified Technical Support Engineer. The “Compile error in hidden module” error occurs when you open a VBA project in Microsoft Excel. It occurs when ...

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