ICAEW.com works better with JavaScript enabled.
Exclusive

Excel community

Power Query resources

Author: Simon Hurst

Published: 23 Jun 2021

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

Following on from the recent webinar on Power Query: 10 everyday problems that Power Query solves best, the feedback report contained several suggestions for future events. The Excel Community will certainly be looking at these suggestions to inform its plans for future content and for the webinar programme. In the meantime, it's worth detailing some of the existing resources that are available.

Note that some of these webinars and articles are a few years old now and the areas covered have been subject to frequent change since then, so some features might have changed, or new features might have been added in the intervening time.

Other Power tools

Power Pivot and Power BI were mentioned several times in the feedback. Some previous webinars looked at these features:

Power Pivot

Power BI

In addition, we have recently been running a series using the creation of a 'portal' to Excel Community and IT Faculty content as an example of the use of Power BI. Central to the portal is the ability to display lists of posts in the various different series of posts that we have included. The Power BI portal project can be found by selecting the 'Archive project' series:

Allow Microsoft Cookies

This content is provided by Microsoft Power BI. We ask for your permission before anything is loaded, as they are using cookies and other technologies. You may want to read Microsoft's privacy policy before accepting. To view this content, please choose Allow all cookies.

The 'Open in full-screen mode' icon in the bottom right-hand corner of the embedded report should show the contents at a more readable size with the Escape key returning you to the post.

PivotTable guide

There are several webinars available that cover the use of PivotTables. Here are a couple of examples:

There are also many posts on PivotTables including a set of six articles in our recent 'Accountants' Guide' series:

Consolidation of data from existing workbooks using power query

Several posts have looked at different methods of achieving this, including:

Automate reporting using Power Query

Four years ago, the Excel Community carried a series of posts covering several aspects of this issue entitled 'Experimental Excel':

A follow-up webinar went through the process live:

Other practical applications of Power Query

In recent years, we have included multiple individual posts on different uses of Power Query but also several series. Once again these can easily be accessed using the Power BI portal mentioned above. The 'Christmas specials' series in 2019 featured 15 different Power Query solutions:

The 'Six impossible things' series looked at some more complex uses of Power Query.

For the individual posts, you can use the Keyword search Word Cloud in the archive portal to list articles for Power_Query, PivotTables or Power_BI.

Excel community

This article is brought to you by the Excel Community where you can find additional extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business.

Excel polaroid
Topics
Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250