AI tools are frequently used in data visualization — this article describes how they can make data preparation more efficient ...

This is an External Tool for Power BI Desktop to connect Excel to the local model hosted in Power BI Desktop. The goal is to be just one click away from an Excel report. While the initial version must ...

I love Excel as an alternative to Power BI reports, especially now that Excel Online allows you to interact with browser-based Excel reports that use Power BI datasets or the Excel Data Model (aka ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart Your email has been sent PivotCharts and slicers go together like peanut butter and jelly — the slicer ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...

In part 4 of this series (sorry for the long wait since then!) I finished off looking at what you can do with named sets. Now, before I go on to more important topics like Excel cube functions and ...

Have you found this content useful? Use the button above to save it to your profile. Simon Hurst continues ExcelZone's Five Minute Pivot Tip series with a look at the layout options for PivotCharts, ...