Replicate SUMPRODUCT in Power Query In my previous post, MMULT in Power Query, I showed how to recreate Excel SUMPRODUCT using List.Generate. This post will show an alternative method using List.Accumulate. Power Query does not come
Tag Archives: excel
Replicate Excel MMULT in Power Query When you start getting into Power Query and the M language you realize the immense benefits this tool provides you with. Even the VBA geeks like myself realize that,
List all Files from a folder and all subfolders with Power Query A common task some people have is listing all files within a folder and its subfolders and then sort them by either file
Excel Clock Chart Download the file When we look at a clock, we are looking at the first chart invented by the human kind, so why not build one in Excel? The steps are not
Excel Animated Sine Cosine Chart While researching on the web yesterday I saw a nice animated chart showing the sine and cosine functions connected to each point of a circle which I thought would be
Gauge Charts A gauge chart should be used sparingly, especially in professional reports or dashboards when much better alternatives are available (bullet charts come to mind). In spite of that, it is a good Excel
Excel People Connections Chart Download the file Suppose you have one table like the below which lists the relationship between two people: 0 No Relationship, 1 they just knows each other, 2 they are good
Opswat Report In this quick post I wanted to provide an alternative Excel market share chart to that found in the Opswat Report. Download the file The data is shown below. It is a simple
Building a searchable Userform using a Recordset In my previous post How to create a disconnected recordset I showed how to create a disconnected Recordset with ADO. Now we will use this disconnected recordset to create a
Disconnected Recordsets Disconnected Recordsets are great when you want to retrieve and work with data from your database without the risk of creating conflicts with other users, in fact they are a fully functional Recordsets