Power Pivot

Home/Power Pivot

HYPERLINK and XLOOKUP to jump to a result

by Wyn Hopkins Use HYPERLINK and XLOOKUP to jump to a result   XLOOKUP will return a range so we can use it inside other formulas such as HYPERLINK to be able to jump to our result. Want to learn more? Jump on to one of our courses We've trained over 1,000 people from all [...]

Dynamically consolidate multiple ranges

By Yury Tokarev Dynamically consolidate multiple ranges when loading Excel files from Folder in Power Query We've come across a task where we need to consolidate a client's budget data from Excel files, each representing a division, where any of the files may have multiple similarly structured tabs with sub-divisional data. In our [...]

Excel Summit hits Perth

Excel Summit South is hitting Perth The biggest Excel event ever to hit Perth is coming on the 8th & 9th of August 2019. If you love Excel or want to make the most of the technology your organisation is already paying for then you cannot miss out on this. Multiple MVP's and Microsoft staff [...]

We’re going to SQLSaturday 2019

  SQLSaturday training event Access Analytic is once again happy to be involved in SQLSaturday. This event brings together Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. To find out more visit SQLSaturday here.  

Power Pivot basics

Power Pivot basics plus a Power Query technique for handling awkward data Something for everyone in this video, showing how to take awkward source data, transform it using Power Query and produce an interactive variance report in Power Pivot. The pre-built template we used is available for free from our website along other cool downloads [...]