Excel and Power BI are two powerful tools that can be used together to analyse and visualise data. In recent years, Microsoft has introduced several new features that make it easier to work with these tools. In this blog post, we will explore some of the latest features in Excel and Power BI that can help you improve your data analysis and visualisation capabilities.

Excel Discover and Combine Data

With this feature, you can easily search for and combine data from multiple sources in Excel. You can access this feature by clicking the "Data" tab in the Excel ribbon and then selecting "Get Data". [1]

Power Query

Power Query is a data transformation and cleansing tool that allows you to extract, transform, and load data from a variety of sources. You can use Power Query to clean, reshape, and combine data from multiple sources, and then load it into Excel or Power BI.

Power Pivot

Power Pivot is an add-in for Excel that allows you to create data models, relationships, and calculations using large datasets. With Power Pivot, you can create complex calculations and build interactive dashboards that can be shared with others.

PivotTables from Power BI datasets

This feature allows you to create PivotTables in Excel that are connected to Power BI datasets. You can create these PivotTables by selecting "Connect to Data" from the "Insert PivotTable" menu in Excel. [4]

Organisation data types

This feature allows you to create custom data types in Excel that can be used across multiple workbooks and shared with others. This can help you maintain consistency and accuracy across your data.

Paginated Reports

With this feature, you can create and distribute paginated reports that can be printed or exported to PDF or Excel. You can access this feature from the Power BI service or by using Power BI Report Builder. [3]

Collaboration and co-authoring

With Excel reports connected to Power BI stored in OneDrive for Business or a SharePoint document library, you get great features for collaboration and co-authoring, so you and your colleagues can analyse data together even if you're not in the same room. [2]

Excel and Power BI offer a wide array of features for exploring and analysing data. By taking advantage of these features, users can access and visualise data more quickly and effectively. With the ability to create sophisticated dashboards and reports, users can gain valuable insights from their data. Excel and Power BI offer a great way to make data-driven decisions and to become more productive.

For more of the latest Excel news please head to https://www.xlintelligence.co.uk/news 

To book an Excel consultation service with our Excel professionals, click here